ETL Tester (Contract)
Job Location:
Monthly Salary:
Posted:
Application Deadline:
Vacancies:
Job Summary
CoreFactor is searching for an ETL Tester on a contract basis for a Financial Services client in the GTA .
- Collaborate with developers business analysts data engineers and other stakeholders to identify troubleshoot and resolve data quality issues.
- Participate in requirements reviews source-to-target mapping sessions and design discussions to ensure testability completeness and data quality.
- Analyze source-to-target mappings define test strategies create comprehensive test cases and perform rigorous data validation.
- Validate data accuracy completeness and integrity through source-to-target reconciliation and transformation testing.
- Execute complex SQL queries perform backend testing and validate ETL transformations across Oracle SQL Server and BigQuery platforms.
- Validate end-to-end ETL workflows data pipelines and data movement across source staging and target environments.
- Work with multiple source systems containing structured semi-structured and JSON data.
- Develop and maintain automated data validation reconciliation and regression tests using Python SQL and other automation utilities.
- Support continuous improvement of ETL testing processes through automation and reusable testing frameworks.
- Own test planning test execution defect management regression validation test reporting and testing sign-off for assigned EDW initiatives.
- Collaborate with project teams to support release readiness activities and ensure delivery quality.
- Maintain test cases test results defect logs and other QA artifacts in Jira Confluence and related project repositories.
- 5 years of hands-on experience in ETL testing data validation source-to-target reconciliation data transformation testing and end-to-end validation of data pipelines in Data Warehouse environments.
- Strong experience with SQL backend testing ETL validation and complex BigQuery queries for data validation reconciliation and troubleshooting.
- Strong understanding of Data Warehousing concepts ETL processes data modeling and data quality principles.
- Hands-on experience with Oracle SQL Server BigQuery Informatica PowerCenter Airflow/Cloud Composer and GCP data services.
- Experience validating data across source staging and target systems including structured semi-structured and JSON data.
- Experience developing and maintaining ETL test automation solutions using Python SQL or similar technologies for automated data validation reconciliation and regression testing.
- Proven ability to own test planning test execution regression validation defect management and testing sign-off activities for EDW initiatives.
Required Skills:
Do you have the skills that will enable you to succeed in this role You have 10 or more years of software development experience (conceptualization design development and debugging) with at least two years of experience as a technical lead providing hands-on architectural design for software applications with an understanding of design patterns such as MVVM MVC Clean Architecture Sound technical knowledge with: Java J2EE Web Services (REST & SOAP) Angular 8() Java Script Spring Boot (Micro Services) You have experience with unit-testing code for robustness security usability and improving performance of the overall application You have a proficient understanding of code versioning tools such as Git Strong command in Computer Science concepts (SOLID etc.) Experience in integrating Third Party libraries and SDKs Experience building applications that consume web services and HTTP REST interaction with JSON Strong problem solving abilities Evaluate new technologies and participate in the continuous improvement of applications and systems Youre passionate about well-designed products and not afraid to sit with our Design Team to prototype wireframe and white-board your ideas
