ETL Tester Opening with CAPCO-Bangalore/Mumbai

ETL Tester

Role Summary

Key Responsibilities

• Design and execute

  ETL test cases

  for migrated Snowflake workflows based on legacy DataStage logic
• Perform

  data reconciliation

  between DB2 EDW outputs and Snowflake outputs (row-level and aggregate-level)
• Validate

  business rules, transformations, and calculations

  implemented in Snowflake
• Identify, log, and track

  data defects and discrepancies

  , supporting root-cause analysis
• Partner with DataStage and Snowflake developers to

  triage and resolve medium and high priority defects

• Validate

  job execution results, dependencies, and scheduling outcomes

• Support

  Dev and QA test cycles

  , including regression testing across tranches
• Ensure test evidence, results, and sign-off artifacts are

  properly documented

Required Skills & Experience

• Strong experience in

  ETL / data warehouse testing

• Hands-on experience with

  SQL-based data validation

• Understanding of

  ETL workflows, data transformations, and reconciliation techniques

• Experience testing

  large-scale EDW or data platform migrations

• Familiarity with

  defect tracking tools

  and structured QA processes
• Strong analytical mindset and attention to detail

Nice to Have

• Experience testing

  Snowflake-based pipelines

• Exposure to

  DataStage or other legacy ETL tools

• Financial services domain experience