ETL DB Testing

Responsibilities

• Design and develop ETL processes for data extraction, transformation, and loading.
• Perform data validation and testing on ETL workflows to ensure data integrity and accuracy.
• Collaborate with data engineers and analysts to understand data requirements and specifications.
• Document ETL processes and testing results for future reference and compliance.
• Identify and troubleshoot data discrepancies and ETL issues, providing solutions in a timely manner.
• Participate in code reviews and provide constructive feedback to peers.

Skills and Qualifications

• 6-8 years of experience in ETL testing and database testing.
• Strong knowledge of SQL and experience with relational databases (e.g., Oracle, SQL Server, MySQL).
• Proficiency in ETL tools such as Informatica, Talend, or Microsoft SSIS.
• Experience with data warehousing concepts and methodologies.
• Familiarity with data modeling and data architecture principles.
• Ability to write complex SQL queries for data validation and testing.
• Strong analytical skills and attention to detail for data quality assurance.
• Good understanding of software development life cycle (SDLC) and testing methodologies.