ETL QA with Microsoft Dynamics CRM

Alight isseekinga skilled andpassionateexperienced 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,executeandmaintaintest plans tovalidatethe accuracy and integrity of data throughout the ETL process.
• Ensuringdateis extracted correctly from source systems, transformed according to business rules, and loaded seamlessly into target databases.
• Working closely with data engineers and developers toidentifyand 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 tovalidatedata.
• Test andvalidate.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:

• Bachelor s degree in computer science, Information Technology, or a related field.
• 7+ Years of overall experience and3+ years of proven experience as an ETL QA, optimallywith a focus on Microsoft Dynamics CRM (on-premises and online).
• 2+Experience with data integration and ETL processes.
• Strong knowledge of back-end operations, InformaticaPower Center or equivalent ETL tool, SQL, and .NET functionalities.
• Excellent analytical and problem-solving skills.
• Strong communicationand 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.

Role:

Industry Type:

Department:

Employment Type:

Role Category:

Education

UG:

PG: