Job Title:  Consultant | ETL Testing | Bengaluru | Engineering

Job Summary:

We are seeking a meticulous and experienced ETL Tester with 2-5 years of experience to ensure the quality and integrity of data warehouse and ETL processes. The ideal candidate will have a strong understanding of ETL tools, data validation techniques, and experience working in Agile environments. As an ETL Tester, you will work closely with developers, analysts, and product teams to ensure that data pipelines meet business requirements and operate efficiently.

Key Responsibilities:

1. Test Planning & Strategy:

• Analyze business requirements, data mappings, and technical specifications to design comprehensive test plans and test cases for ETL processes.
• Develop testing strategies for data extraction, transformation, and loading workflows in the data warehouse.

1. ETL Testing Execution:

• Validate ETL processes to ensure accurate data extraction, transformation, and loading into data warehouses.
• Perform data validation by comparing source and target systems for data integrity and accuracy.
• Execute functional, regression, and system integration testing for ETL processes.

1. Defect Management:

• Identify, document, and track defects using tools like Jira or Bugzilla.
• Collaborate with developers and data engineers to resolve issues and verify fixes.

1. Agile Collaboration:

• Actively participate in Agile ceremonies such as sprint planning, daily stand-ups, and retrospectives.
• Work closely with developers, product owners, and business analysts to ensure quality deliverables within sprint timelines.

1. Data Quality Assurance:

• Perform data profiling and data validation to ensure accuracy, completeness, and consistency.
• Validate data transformation rules and business logic to ensure compliance with requirements.

1. Test Automation (Optional):

• Develop and execute automated test scripts for ETL processes using tools like Python, Selenium, or any relevant ETL automation frameworks.
• Optimize and maintain existing automation frameworks for better efficiency.

1. Reporting & Documentation:

• Create detailed test documentation, including test cases, results, and defect logs.
• Provide regular updates on testing progress and quality metrics to stakeholders.

Required Skills & Qualifications:

• Experience: 2-5 years of experience in ETL and data warehouse testing.
• ETL Tools: Hands-on experience with ETL tools like Informatica, Talend, SSIS, or DataStage.
• SQL Skills: Strong proficiency in writing complex SQL queries for data validation and back-end testing.
• Agile Methodology: Experience working in Agile environments, with familiarity in Scrum or Kanban practices.
• Data Validation: Solid understanding of data modeling, data transformation rules, and data quality concepts.
• Defect Tracking: Experience using defect tracking tools such as Jira, Bugzilla, or equivalent.
• Communication Skills: Excellent communication and collaboration skills to work effectively with cross-functional teams.

Preferred Qualifications:

• BI Tools: Experience testing BI reports/dashboards using tools like Tableau, Power BI, or MicroStrategy.
• Automation Skills: Exposure to automation testing tools/frameworks for ETL or data pipelines (e.g., Python, Selenium).
• Big Data: Knowledge of testing data in Big Data environments, including Hadoop or Spark.
• Cloud Platforms: Familiarity with cloud data platforms such as AWS Redshift, Google BigQuery, or Azure Synapse.
• Certifications: ISTQB or other relevant certifications in testing are a plus.