ETL QA with Microsoft Dynamics CRM

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 .
• E nsuring date is extracted correctly from source systems, transformed according to business rules, and loaded seamlessly into target databases .
• W orking 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 :

Preferred Skills :

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

Skills Required

Data Quality, Analytical, Computer Science, Business Rules, Microsoft Dynamics, Data Governance, Informatica, data integrity, Information Technology, Sql