ETL Developer

Our story

At Alight, we believe a company's success starts with its people. It's why we're so driven to connect passion with purpose. Our team's expertise in human insights and cloud technology, allows companies and employees around the world to transform and thrive.

With a competitive total rewards package, continuing education and training and tremendous potential with a growing global organization, Alight is the perfect place to put your passion to work.

ETL Developer

Alight is seeking a skilled and passionate ETL Software Developer to join our team. As the ETL Developer, you will be a member of a team responsible for various stages of software development, including understanding business requirements, coding, testing, documentation, deployment, and production support. As part of the ETL development team, you will focus on delivering high-quality enterprise caliber systems on Informatica PowerCenter, focused on source and targets to/from flat files, MS Dynamics CRM and Microsoft SQL Server. Your primary role will involve participating in full life-cycle data integration development projects.

Qualifications:

· Knowledge & Experience:

· 5+ years of data integration, data warehousing, or data conversion experience.

· 3+ years of SQL writing and optimization experience.

· 3+ years of Informatica PowerCenter experience.

· 1.5+ years working with Microsoft SQL Server Management Studio.

· Experience with XML file data integration.

· Experience with UNIX shell scripting.

· Experience with Microsoft Dynamics or other CRM system preferred.

· Strong understanding of using ETL tools to integrate internal and third-party systems.

· Excellent analytical and critical thinking skills

· Strong interpersonal skills with the ability to work effectively with diverse and remote teams

· Experience in agile processes and development task estimation

· Strong sense of responsibility for deliverables

· Ability to work in a small team with moderate supervision

Responsibility Areas:

· Design software solutions for small to medium complexity requirements independently, adhering to existing standards

· Develop high-priority and highly complex code for systems based on functional specifications, detailed design, maintainability, and coding and efficiency standards, working independently

· Estimate and evaluate risks, and prioritize technical tasks based on requirements

· Collaborate actively with ETL Lead, Product Owners, Quality Assurance, and stakeholders to ensure high-quality project delivery

· Conduct formal code reviews to ensure compliance with standards

· Utilize appropriate system design, development, and process standards

· Write and execute unit test cases to verify basic functionality, both for your own code and that of your peers

· Create, maintain, and publish system-level documentation, including system diagrams, with minimal guidance

· Ensure clarity, conciseness, and completeness of requirements before starting development, collaborating with Business Analysts and stakeholders to evaluate feasibility. Take primary accountability for meeting non-functional requirements.

Education:

· Bachelor's degree (with preferred concentrations in Computer Science, MIS, Engineering) or equivalent work experience. Master's Degree in related area preferred.

· Computer application certifications, as applicable.

Work hours

• 1 PM-10 PM (IST)

Join our team. Because transformation takes a workforce. Learn more at

Our commitment to Diversity and Inclusion

Alight believes diversity should be visible, valued, and sustained throughout the organization. And we're committed to enabling an inclusive culture of belonging that engages all colleagues and grows the diversity of our talent to proudly represent the clients and communities we serve.

As an affirmative action employer, we adhere to the principles of equal employment opportunity in the workplace as defined in our diversity policy statement.

Diversity Policy Statement

Alight does not discriminate against anyone based on sex, gender, race, color, religion, creed, national origin, ancestry, age, physical or mental disability, medical condition, pregnancy, marital or domestic partner status, citizenship, military or veteran status, sexual orientation, gender, gender identity or expression, genetic information, or any other legally protected characteristics or conduct covered by federal, state, or local law. In addition, we take affirmative action to employ and advance in employment qualified minorities, women, disabled persons, disabled veterans, and other covered veterans.

Alight provides reasonable accommodations to the known limitations of otherwise qualified employees and applicants for employment with disabilities and sincerely held religious beliefs, practices, and observances, unless doing so would result in undue hardship. Applicants for employment may request a reasonable accommodation/modification by contacting his/her recruiter.

Authorization to work in the Employing Country

Applicants for employment in the country in which they are applying (Employing Country) must have work authorization that does not now or in the future require sponsorship of a visa for employment authorization in the Employing Country and with Alight.

Note, this job description does not restrict management's right to assign or reassign duties and responsibilities of this job to other entities; including but not limited to subsidiaries, partners, or purchasers of Alight business units