ETL Tester

Syncredible Solutions; Calgary; On-site; CAD 70,000 - 95,000; Full time

Job summary

Syncredible Solutions is seeking an experienced ETL Tester to validate data extraction, transformation, and loading across sources and data warehouses. You will design and execute ETL test cases, perform source-to-target validation, and write complex SQL queries to ensure data quality.

Candidate will collaborate with BI developers, data engineers, and business stakeholders, applying strong SQL, experience with ETL tools (Informatica, Talend, SSIS, DataStage), and defect-tracking using JIRA in an

Qualifications

• 5+ years of experience in ETL/Data Warehouse Testing.
• Strong SQL skills including joins, subqueries, CTEs, aggregations, and data validation.
• Hands-on experience with ETL tools such as Informatica, Talend, SSIS, DataStage, or similar.
• Experience testing databases such as Oracle, SQL Server, PostgreSQL, Snowflake, or similar.
• Strong understanding of ETL processes and Data Warehouse concepts.
• Experience with source-to-target mapping and data reconciliation.
• Experience with JIRA or similar defect-management tools.
• Good understanding of SDLC/STLC and Agile methodologies.

Responsibilities

• Design and execute ETL test cases, scenarios, and scripts.
• Validate data extraction from source systems and loading into target databases/data warehouses.
• Perform source-to-target data validation and reconciliation.
• Write complex SQL queries to verify data accuracy, completeness, and integrity.
• Test data transformations, mappings, business rules, and data quality.
• Perform ETL, data warehouse, integration, regression, and end-to-end testing.
• Identify, document, and track defects using JIRA or similar tools.
• Analyze data discrepancies and coordinate with developers/data engineers to resolve issues.
• Validate incremental loads, full loads, and error-handling scenarios.
• Participate in test planning, execution, defect triage, and reporting.
• Work closely with Business Analysts, ETL Developers, Data Engineers, and stakeholders.

Skills

ETL/Data Warehouse Testing

SQL

Informatica/Talend/SSIS/DataStage

Oracle/SQL Server/PostgreSQL/Snowflake

JIRA

SDLC/STLC & Agile

Cloud data platforms (AWS/Azure/GCP)

Python scripting

API testing

CI/CD

Education

Tools

Informatica

Talend

SSIS

DataStage

Snowflake

Databricks

AWS Redshift

Job description

At Syncredible Solutions, we believe in the transformative power of technology. we specialize in Digital transformation services, Enterprise solutions, Power BI Analytics solutions and staffing services.

Job Summary

We are looking for an experienced ETL Tester to validate data extraction, transformation, and loading processes across various data sources and target systems. The ideal candidate should have strong experience in data warehouse testing, SQL, ETL validation, and defect management.

Responsibilities

• Design and execute ETL test cases, test scenarios, and test scripts.
• Validate data extraction from source systems and loading into target databases/data warehouses.
• Perform source-to-target data validation and reconciliation.
• Write complex SQL queries to verify data accuracy, completeness, and integrity.
• Test data transformations, mappings, business rules, and data quality.
• Perform ETL, data warehouse, integration, regression, and end-to-end testing.
• Identify, document, and track defects using tools such as JIRA or similar.
• Analyze data discrepancies and work with developers/data engineers to resolve issues.
• Validate incremental loads, full loads, and error-handling scenarios.
• Participate in test planning, execution, defect triage, and reporting.
• Work closely with Business Analysts, ETL Developers, Data Engineers, and business stakeholders.

Required Skills

• 5+ years of experience in ETL/Data Warehouse Testing.
• Strong SQL skills, including joins, subqueries, CTEs, aggregations, and data validation.
• Hands‑on experience with ETL tools such as Informatica, Talend, SSIS, DataStage, or similar.
• Experience testing databases such as Oracle, SQL Server, PostgreSQL, Snowflake, or similar.
• Strong understanding of ETL processes and Data Warehouse concepts.
• Experience with source-to-target mapping and data reconciliation.
• Experience with JIRA or similar defect-management tools.
• Good understanding of SDLC/STLC and Agile methodologies.

Preferred Skills

• Experience with cloud data platforms such as AWS, Azure, or GCP.
• Experience with Snowflake, Databricks, or AWS Redshift.
• Knowledge of Python or scripting for test automation.
• Experience with API testing and data integration testing.
• Knowledge of CI/CD and automated testing frameworks.
• Experience in banking, healthcare, insurance, or other enterprise environments is a plus.

ETL Testing | Data Warehouse Testing | SQL | Data Validation | Source-to-Target Testing | Data Reconciliation | Informatica/Talend/SSIS | Snowflake | Defect Management | Agile