Sr ETL Developer

Job Description

Our story

At Alight, we believe a company s success starts with its people. At our core, we Champion People, help our colleagues Grow with Purpose and true to our name we encourage colleagues to Be Alight.

Our Values:

Champion People- be empathetic and help create a place where everyone belongs.

Grow with purpose -Be inspired by our higher calling of improving lives.

Be Alight -act with integrity, be real and empower others.

It s why we re so driven to connect passion with purpose. Alight helps clients gain a benefits advantage while building a healthy and financially secure workforce by unifying the benefits ecosystem across health, wealth, wellbeing, absence management and navigation.

With a comprehensive 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.

Join our team if you Champion People, want to Grow with Purpose through acting with integrity and if you embody the meaning of Be Alight.

Learn more atcareers.alight.com.

Alight is seeking a skilled and passionate Senior ETL Software Developer to join our team. As the Senior 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:
- 7+ years of data integration, data warehousing, or data conversion experience.
- 4+ years of SQL writing and optimization experience.
- 5+ years of Informatica PowerCenter experience.
- 3.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 and supervise formal code reviews to ensure compliance with standards
- Utilize appropriately 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:

- Bachelors 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.

Alight requires all virtual interviews to be conducted on video.

Flexible Working

So that you can be your best at work and home, we consider flexible working arrangements wherever possible. Alight has been a leader in the flexible workspace and Top 100 Company for Remote Jobs 5 years in a row.

Benefits

We offer programs and plans for a healthy mind, body, wallet and life because it s important our benefits care for the whole person. Options include a variety of health coverage options, wellbeing and support programs, retirement, vacation and sick leave, maternity, paternity & adoption leave, continuing education and training as well as several voluntary benefit options.

By applying for a position with Alight, you understand that, should you be made an offer, it will be contingent on your undergoing and successfully completing a background check consistent with Alight s employment policies. Background checks may include some or all the following based on the nature of the position: SSN/SIN validation, education verification, employment verification, and criminal check, search against global sanctions and government watch lists, credit check, and/or drug test. You will be notified during the hiring process which checks are required by the position.

Our commitment to Inclusion

We celebrate differences and believe in fostering an environment where everyone feels valued, respected, and supported. We know that diverse teams are stronger, more innovative, and more successful.

At Alight, we welcome and embrace all individuals, regardless of their background, and are dedicated to creating a culture that enables every employee to thrive. Join us in building a brighter, more inclusive future.

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 managements 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.

We offer you a competitive total rewards package, continuing education & training, and tremendous potential with a growing worldwide organization.

DISCLAIMER:

Nothing in this job description restricts managements 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.

.

Role:ETL Developer

Industry Type:IT Services & Consulting

Department:Engineering - Software & QA

Employment Type:Full Time, Permanent

Role Category:DBA / Data warehousing

Education

UG:Any Graduate

PG:Any Postgraduate