Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

BULL-IT SOLUTIONS LTD

NewBe an early applicant

ETL Tester Analyst

Posted

Summary

ETL Tester Analyst focused on testing data pipelines and warehouses: running source-to-target validation, reconciliation, and transformation/SCD checks with SQL against databases like SQL Server, Oracle, PostgreSQL, and Snowflake, using ETL tools such as Informatica, Talend, SSIS, and Azure Data Factory.

Required Skills

  • Strong hands-on experience in ETL Testing and Data Validation.
  • Strong knowledge of SQL, including joins, subqueries, aggregate functions.
  • Experience performing source-to-target data validation and reconciliation.
  • Strong understanding of ETL processes, data pipelines, data warehouses, and data integration concepts.
  • Experience validating transformation rules and business logic.
  • Experience performing data completeness, accuracy, integrity, duplicate, NULL, and reconciliation testing.
  • Good understanding of fact tables, dimension tables, primary/foreign keys, and data warehouse concepts.
  • Knowledge of Slowly Changing Dimensions (SCD Type 1 and Type 2) and their validation.
  • Experience validating full, incremental, and delta data loads.
  • Experience with relational databases such as SQL Server, Oracle, PostgreSQL, Snowflake, or similar platforms.
  • Experience with ETL/data integration tools such as Informatica, Talend, SSIS, DataStage, Azure Data Factory, or similar tools.
  • Experience with defect management tools such as Jira.
  • Strong understanding of SDLC, STLC, Agile/Scrum, and defect lifecycle management.
  • Strong analytical, troubleshooting, problem-solving, and communication skills.

Preferred Skills

  • Experience with cloud data platforms such as Snowflake, GCP, Azure Synapse Analytics, Databricks, or AWS Redshift.
  • Experience with cloud-based data integration tools.
  • Knowledge of Python, unix for data validation and test automation.
  • Exposure to ETL test automation and data reconciliation frameworks.
  • Experience working with large-volume datasets and complex data pipelines.
  • Knowledge of data quality frameworks, metadata validation, and data lineage.
  • Experience validating CSV, JSON, XML, Parquet, and flat-file data.
  • Exposure to API and database integration testing.
  • Knowledge of CI/CD and version control tools such as Git, Jenkins, Azure DevOps, or GitHub Actions.
  • Experience supporting UAT, production validation, and post-production data reconciliation.
  • Ability to communicate in Spanish is preferred for Mexico client engagements.


Skills

Apply

See also

QA jobs by country — openings, pay and top skills →