Senior Test Engineer, ETL, Datawarehouse Testing

Jobtailor; Chennai District; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Jobtailor in Chennai, India is seeking a QA Specialist for Enterprise Datawarehouse testing. You will design and execute test plans for ETL processes and BI reports, ensuring data accuracy and reliability across systems.

Responsibilities include collaborating with data engineers and BI teams, documenting defects, performing root cause analysis, and validating data migrations. A strong SQL skill set and knowledge of data governance are essential for success in this role.

Qualifications

• 4-6 years of experience in Information Technology with specialization in Datawarehouse/ETL Quality Assurance.
• 4+ years of hands-on proficiency in SQL and data querying tools.
• Strong understanding of Datawarehouse concepts, including ETL, Business Intelligence Reports.
• Proven experience in quality assurance in Enterprise Datawarehouse environments.
• Strong understanding of data management principles, data governance, and data quality standards.
• Experience with ETL tools and Query platforms such as Informatica, Azure Data Factory, SSMS, TOAD.
• Excellent analytical and problem-solving skills.
• Bachelor’s degree or foreign equivalent degree in Computer Science or a related field.

Responsibilities

• Develop, implement, and maintain comprehensive test plans and test cases for Enterprise Datawarehouse solutions.
• Conduct thorough testing of ETL and BI Reports to ensure data accuracy, consistency, and reliability.
• Collaborate with cross-functional teams to understand data requirements and business rules.
• Identify, document, and track defects and inconsistencies in data management processes.
• Perform root cause analysis on data quality issues and recommend corrective actions.
• Validate data integration and data migration processes to ensure seamless data flow across systems.
• Develop test scripts for data testing in Enterprise Datawarehouse for data accuracy, data completeness & data integrity.

Skills

SQL

ETL testing

Datawarehouse concepts

BI reports

Data governance

Analytical skills

Communication

Education

Bachelor's degree in Computer Science

Tools

Informatica

Azure Data Factory

SSMS

TOAD

Job description

Responsibilities

• Develop, implement, and maintain comprehensive test plans and test cases for Enterprise Datawarehouse solutions
• Conduct thorough testing of ETL and BI Reports to ensure data accuracy, consistency, and reliability
• Collaborate with cross‑functional teams to understand data requirements and business rules
• Identify, document, and track defects and inconsistencies in data management processes
• Perform root cause analysis on data quality issues and recommend corrective actions
• Validate data integration and data migration processes to ensure seamless data flow across systems
• Develop test scripts for data testing in Enterprise Datawarehouse for data accuracy, data completeness & data integrity

Requirements

• 4-6 years of experience in Information Technology with specialization in Datawarehouse/ETL Quality Assurance
• 4+ years of hands‑on proficiency in SQL and data querying tools
• Strong understanding of Datawarehouse concepts, including ETL, Business Intelligence Reports
• Proven experience in quality assurance in Enterprise Datawarehouse environments
• Strong understanding of data management principles, data governance, and data quality standards
• Experience with ETL tools and Query platforms such as Informatica, Azure Data Factory, SSMS, TOAD
• Excellent analytical and problem‑solving skills
• Bachelor’s degree or foreign equivalent degree in Computer Science or a related field