ETL Consultant - Testing

You will validate data integrity and accuracy across end-to-end ETL processes. You will own the testing lifecycle from source extraction to final load, ensuring data completeness and correct transformations.

Responsibilities

• Perform data analysis and mapping to ensure accurate transformations and integrations.
• Develop, validate, and optimize SQL scripts to maintain data integrity.
• Troubleshoot SQL queries, ETL jobs, and data warehouse or data mart models.
• Conduct data validation testing across various data sources.
• Create detailed requirements and document procedures for ETL development and testing.

Required Skills

• 7+ years of experience in ETL testing and data validation.
• Proficiency in SQL, including PL/SQL, MySQL, and Transact SQL.
• Strong background in data analysis, data mapping, and data modeling.
• Experience with Transform and Data Mining.
• Proven ability to troubleshoot ETL jobs and complex data warehouse models.
• Experience performing end-to-end testing from source extraction to final load.
• Ability to validate data mappings for correct transformations.

Preferred Skills

• Bachelor's Degree in Computer Science, Information Technology, or equivalent experience.