ETL QA with Microsoft Dynamics CRM (On-Prem and Online)

Our story

At Alight, we believe a companyu2019s 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 u201CBe Alight.u201D

Our Values:

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

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

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

Itu2019s why weu2019re 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 at .

About Us:u202FAlight is a leading company dedicated to delivering innovative solutions to our clients. We are seeking a skilled ETL QA professional with expertise in Microsoft Dynamics CRM to join our dynamic team.

Job Description:

Alight is seeking a skilled and passionate experienced ETL QA professional to ensure the quality and integrity of our data integration processes. The ideal candidate will have a strong background in Microsoft Dynamics CRM (both on-premises and online versions), back-end operations, Informatica, SQL, and .NET functionalities.

Key Responsibilities:

• Design, develop, execute and maintain test plans to validate the accuracy and integrity of data throughout the ETL process.

• Ensuring date is extracted correctly from source systems, transformed according to business rules, and loaded seamlessly into target databases.

• Working closely with data engineers and developers to identify and resolve data quality issues.

• Validate data transformations, data quality, and data integrity across various stages of ETL.

• Perform back-end testing to ensure data accuracy and consistency.

• Collaborate with developers, business analysts, and other stakeholders to understand requirements and provide feedback.

• Utilize Informatica for data integration and transformation tasks.

• Write and execute complex SQL queries to validate data.

• Test and validate .NET functionalities related to ETL processes.

• Document and report defects, and work with the development team to resolve issues.

• Ensure compliance with data governance and security policies.

Qualifications:

• Bacheloru2019s degree in computer science, Information Technology, or a related field.

• 7+ Years of overall experience and 3+ years of proven experience as an ETL QA, optimally with a focus on Microsoft Dynamics CRM (on-premises and online).

• 2+ Experience with data integration and ETL processes.

• Strong knowledge of back-end operations, Informatica Power Center or equivalent ETL tool, SQL, and .NET functionalities.

• Excellent analytical and problem-solving skills.

• Strong communication and collaboration skills.

• Detail-oriented with a commitment to quality.

Preferred Skills:

• Experience with other ETL tools and technologies.

• Knowledge of data warehousing concepts.

• Familiarity with Agile/Scrum methodologies.

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 u201CTop 100 Company for Remote Jobsu201D 5 years in a row.

Benefits

We offer programs and plans for a healthy mind, body, wallet and life because itu2019s 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 Alightu2019s 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 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.