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
- Agile
- Analytics
- API
- Automation
- AWS
- Azure
- Azure Data Factory
- Azure DevOps
- Azure Synapse
- CI/CD
- Cloud
- Data Lineage
- Data Pipelines
- Data Quality
- Data Reconciliation
- Data Warehousing
- Databricks
- DevOps
- ETL
- GCP
- Git
- GitHub
- GitHub Actions
- Integration Testing
- Jenkins
- Jira
- JSON
- Oracle
- Parquet
- PostgreSQL
- Python
- RDBMS
- Redshift
- Scrum
- SDLC
- Snowflake
- SQL
- SQL Server
- SSIS
- Talend
- Test Automation
- Unix
- Version Control
- XML
Sign in to read and join the discussion.