ETL Test Engineer – Data Warehouse Testing, SQL, ETL, Data Validation

Astra-North Infoteck Inc.

Toronto

Vor Ort

CAD 70.000 - 110.000

Vollzeit

14 Tage+

Eine vollständige Bewerbung in einer Minute

Maßgeschneiderter Lebenslauf und Anschreiben – versandbereit.

Schaffe es an den ATS-Filtern vorbei

Zusammenfassung

Astra-North Infoteck Inc. is seeking an ETL Test Engineer to join our data testing team in Toronto. The role focuses on end-to-end ETL testing of data warehouse solutions, validating data mappings, and implementing robust test cases for data quality.

The ideal candidate will have strong SQL skills, experience with UNIX/Linux, and familiarity with Informatica; Python automation is a plus. You will collaborate with developers and analysts to ensure data integrity and report findings to

Qualifikationen

  • Experience in ETL testing and data validation in data warehouse environments.
  • Proficient SQL skills for data analysis and validation.

Aufgaben

  • Perform end-to-end testing of ETL processes and data pipelines for data warehouse solutions.
  • Validate source-to-target data mappings, transformations, and business rules.
  • Design, develop, and execute test cases and scripts for data validation.
  • Collaborate with developers and analysts to understand requirements and resolve defects.
  • Support defect tracking and test reporting activities.

Kenntnisse

ETL Testing
Data Warehouse
SQL
UNIX/Linux
Informatica
Python automation

Tools

Informatica

Jobbeschreibung

ETL Test Engineer – Data Warehouse Testing, SQL, ETL, Data Validation

ETL Data Tester – ETL Testing, Data Warehouse, SQL, UNIX/Linux, Informatica

Key Responsibilities
  • Perform end-to-end testing of ETL processes, data pipelines, and Data Warehouse solutions
  • Validate source-to-target data mappings, data transformations, and business rules
  • Design, develop, and execute test cases, test scenarios, and test scripts for data validation
  • Perform data reconciliation, completeness, accuracy, and integrity checks across systems\
  • Write complex SQL queries for data analysis, validation, and defect investigation
  • Utilize UNIX/Linux commands for file validation, batch job monitoring, and troubleshooting
  • Collaborate with developers, business analysts, and stakeholders to understand requirements and resolve defects
  • Support defect tracking, root cause analysis, and test reporting activities
  • Exposure to Informatica workflows, mappings, and ETL jobs is preferred
  • Experience with Python automation for test automation, data validation, and reporting will be considered a strong advantage
Hol dir deinen kostenlosen, vertraulichen Lebenslauf-Check.

oder ziehe deine Datei hierhin.

Similar jobs

Ähnliche Jobs, die dir auch gefallen könnten

ETL Quality Analyst
ETL Quality Analyst

Insight Global (United States) • Toronto

Vor Ort
CAD 65.000 - 95.000
ETL Test Automation Engineer – Azure Data Platform
ETL Test Automation Engineer – Azure Data Platform

Astra-North Infoteck Inc. • Mississauga

Vor Ort
CAD 85.000 - 110.000
Senior Software Developer - ETL JP241
Senior Software Developer - ETL JP241

P@thlion Staffing Careers • Toronto

Vor Ort
CAD 110.000 - 150.000
Senior Software Developer - ETL JP241
Senior Software Developer - ETL JP241

Pathlion • Toronto

Vor Ort
CAD 90.000 - 120.000
Senior ETL Tester — SQL & Data Validation (Hybrid Toronto)
Senior ETL Tester — SQL & Data Validation (Hybrid Toronto)

Iris Software Inc. • Toronto

Hybrid
CAD 90.000 - 110.000
Quality Assurance Specialist
Quality Assurance Specialist

Yochana • Toronto

Vor Ort
CAD 70.000 - 90.000
ETL DataStage Developer
ETL DataStage Developer

Apptoza Inc. • Toronto

Vor Ort
CAD 80.000 - 100.000
RQ08114 - Test Lead Senior
RQ08114 - Test Lead Senior

Rubicon Path • Toronto

Hybrid
CAD 90.000 - 120.000
ETL Testing
ETL Testing

Kumaran Systems • Toronto

Vor Ort
CAD 90.000 - 130.000
ETL Consultant
ETL Consultant

Envision Technology Solutions • Montreal

Vor Ort
CAD 90.000 - 140.000