Etl Tester

2 weeks ago

Toronto, Canada AlphaForce Technology Solutions Full time

**Position: Business Intelligence Specialist - ETL Tester**

**Location: 315 Front Street West, Toronto**

**Security Level: CRJMC**

Must haves:
7+ years in ETL tools such as Microsoft SSIS, stored procedures (Must Have)

2+ Azure Data Lake and Data Warehouse, and building Azure Data Factory pipelines (Must Have)

2+ years Python (Must Have)

Description

General Responsibilities

Responsible for test planning and preparation including full documentation as writing test plan, test cases, and execution of test plan.

Design, develop and implement test plan and test cases from Oracle source to Azure Data Lake - initial load and incremental ETL. Used tools are:
Azure Data Factory (expert knowledge) to validate pipeline from Oracle to Azure Data Lake

Azure Synapse to build stored procedures and read data from data lake

Review the requirements, database tables, and database relationships - Identify gaps and inefficiencies in current production reporting environment and provide recommendations address them in the new platform.

Continue to evolve and design test framework and CDC

Prepare test design artifacts

Analysis of data - physical model mapping from data source to reporting destination.

Understand the requirements. Recommend changes to the Physical model.

Develop the scripts to test physical DB.

Access Oracle DB environments, use SSIS, SQL Server and other development tools for developing solution.

Proactively communicate with business & dev team about test plan, design, communicate and review dependencies and risks.

Development of ETL test strategy and solution based on different set of modules

Understand the Tables and Relationships.

Create test design documents and test cases.

Development and testing of data with Incremental and Full Load.

ETL data from Applications to Data Warehouse

ETL data from Data Warehouse to Data Mart

Perform different methods of testing

Performance Review, data Consistency checks

Troubleshoot performance issues, ETL Load issues, log activity for each Individual package and transformation.

Review Performance of ETL Overall.

End to end Integrated testing for Full Load and Incremental Load

Provide QA sign-off once test cycle is completed for deployment

Knowledge Transfer to Ministry staff, development of documentation on the work completed.

Document share and work on the ETL end to end testing knowledge base, Troubleshooting steps, configuration and scripts review.

Transfer documents, scripts and review of documents

Experience and Skill Set Requirements

Please note this role is part of a Hybrid Work Arrangement and resource(s) will be required to work at a minimum of 3 days per week at the Office Location.

**Experience**:
Design & develop the test plan & test cases for Data warehouse, Datamart & Data Lake projects

Experience in testing data validation scenarios and Data ingestion, pipelines, and transformation processes (e.g.,ETL).

Experience in writing complex SQL queries, ability to determine the types of testing that must be conducted (i.e, data validation, regression, etc.), including evaluating the testability of requirements and create a comprehensive test plan that supports the business and technological solutions being delivered.

An understanding of Azure Data Factory Pipelines & Databricks Notes testing, Cloud data/Data Lake testing

Identification and Test Data Preparation Techniques.

Review and understand Business Requirements/Source-To-Target mapping.

Ability to transform complex Business logic into SQL or PL/SQL queries

Ability to run, read from, debug batch processes

Thorough knowledge of Software Test Life Cycle, Test Case Life Cycle, Defect Life Cycle etc

**Skills**:7+ years in testing ETL projects & Data validation (test plan creation, writing test cases and executing back end testing of ETL pipelines) (Must Have)

2+ years of experience in testing Azure Data Lake and Data Warehouse, and Datamart (Must Have)

2+ years Python/PySpark (nice to have)

Databricks

Synapse (nice to have)

SQL Server

Oracle

Ability to present technical requirements to the business

Evaluation Criteria

Design Documentation and Analysis Skills (45%)

Demonstrated experience in creating both Functional Design Documents (FDD) & Detailed Design Documents (DDD).

Experience in Fit-Gap analysis, system use case reviews, requirements reviews, coding exercises and reviews.

Experience in the development and maintaining a plan to address contract deliverables, through the identification of significant milestones and expected results with weekly status reporting.

Work with the Client & Developer(s) assigned to refine/confirm Business Requirements

Participate in defect fixing, testing support and development activities for ETL tool. Assist with defect fixing and testing support for Power BI reports.

Analyze and document solution complexity and interdependencies by function including providing support for data validation.

Development, Database and ETL experien

  • Hiring for Etl Tester!!

    3 weeks ago

    Toronto, Canada Kumaran Systems Pvt Ltd Full time

    QA ETL TESTER, with our Banking Client in Toronto, Contract 6 months with possible extension. - 5 + years of work experience, ETL Tester/Automation. - Good understanding of SDLC & STLC, Agile (Scrum) models. - Strong experience in PL/SQL and UNIX shell scripting to perform ETL data warehousing testing. - DATABASES: Oracle and Big Data ( Hadoop, Netezza) -...

  • Senior ETL Tester

    3 days ago

    Toronto, Canada Coforge Full time

    Job Title : Senior ETL Tester Skill: ETL , SQL Server, Data warehousing Experience : 8 -12 years Location: Toronto, ON (Hybrid) Duration : Fulltime We at Coforge are hiring Senior ETL Tester with following skill sets: Strong understanding of Data Warehouse & Data Quality fundamentals. 3 to 5 years o

  • Hiring for Etl Tester

    2 weeks ago

    Toronto, Ontario, Canada Kumaran Systems Pvt Ltd Full time

    QA ETL TESTER, with our Banking Client in Toronto, Contract 6 months with possible extension. 5 + years of work experience, ETL Tester/Automation. Good understanding of SDLC & STLC, Agile (Scrum) models. Strong experience in PL/SQL and UNIX shell scripting to perform ETL data warehousing testing.DATABASES: Oracle and Big Data ( Hadoop, Netezza) Test tools:...

  • Etl Tester

    3 weeks ago

    Toronto, Canada Reveille technologies Full time

    Position**:ETL Tester** Location**:Remote Work (Canada)** JD: - Minimum 8+ years of Exp is required - **Looking for an ETL Testing engineer with Experience in AWS (mandatory)**: - Experience in developing and implementing test strategies for complex initiatives - Experience providing testing oversight over multiple agile team - Experience in SQL - Strong...

  • QA ETL Tester

    2 weeks ago

    Toronto, Canada Pegasus Knowledge Solutions, Inc. Full time

    Location : Remote for Toronto, Canada or should be in EST time zone. Duration : 3-6 Months Contract to Hire / Full time Work Authorization : Unrestricted for Canada Title : QA ETL Tester. Required : ETL Tester (Tool used is Pyspark), API Testing, SQL Queries, WCAG Accessibility Standards Responsib

  • Senior ETL Tester

    3 days ago

    Toronto, Canada Coforge Full time

    Job Title : Senior ETL TesterSkill: ETL , SQL Server, Data warehousingExperience : 8 -12 yearsLocation: Toronto, ON (Hybrid)Duration : FulltimeWe at Coforge are hiring Senior ETL Tester with following skill sets:Strong understanding of Data Warehouse & Data Quality fundamentals.3 to 5 years of experience in data warehouse development/testing.3 to 5 years of...

  • Senior ETL Tester

    3 days ago

    Toronto, Canada Coforge Full time

    Job Title : Senior ETL Tester Skill: ETL , SQL Server, Data warehousing Experience : 8 -12 years Location: Toronto, ON (Hybrid) Duration : Fulltime We at Coforge are hiring Senior ETL Tester with following skill sets: Strong understanding of Data Warehouse & Data Quality fundamentals. 3 to 5 years of experience in data warehouse development/testing. 3 to 5...

  • Senior ETL Tester

    4 days ago

    Toronto, Canada Coforge Full time

    Job Title : Senior ETL TesterSkill: ETL , SQL Server, Data warehousingExperience : 8 -12 yearsLocation: Toronto, ON (Hybrid)Duration : FulltimeWe at Coforge are hiring Senior ETL Tester with following skill sets:Strong understanding of Data Warehouse & Data Quality fundamentals.3 to 5 years of experience in data warehouse development/testing.3 to 5 years of...

  • Senior ETL Tester

    4 days ago

    Toronto, Canada Coforge Full time

    Job Title : Senior ETL TesterSkill: ETL , SQL Server, Data warehousingExperience : 8 -12 yearsLocation: Toronto, ON (Hybrid)Duration : FulltimeWe at Coforge are hiring Senior ETL Tester with following skill sets:Strong understanding of Data Warehouse & Data Quality fundamentals.3 to 5 years of experience in data warehouse development/testing.3 to 5 years of...

  • Senior ETL Tester

    3 days ago

    Toronto, Canada Coforge Full time

    Job Title : Senior ETL TesterSkill: ETL , SQL Server, Data warehousingExperience : 8 -12 yearsLocation: Toronto, ON (Hybrid)Duration : FulltimeWe at Coforge are hiring Senior ETL Tester with following skill sets:Strong understanding of Data Warehouse & Data Quality fundamentals.3 to 5 years of experience in data warehouse development/testing.3 to 5 years of...

  • Senior ETL Tester

    3 days ago

    Toronto, Canada Coforge Full time

    Job Title : Senior ETL TesterSkill: ETL , SQL Server, Data warehousingExperience : 8 -12 yearsLocation: Toronto, ON (Hybrid)Duration : FulltimeWe at Coforge are hiring Senior ETL Tester with following skill sets:Strong understanding of Data Warehouse & Data Quality fundamentals.3 to 5 years of experience in data warehouse development/testing.3 to 5 years of...

  • Sr ETL Tester

    2 days ago

    Toronto, Canada Iris Software Inc. Full time

    Iris's direct client, one of the leading Banking and Financial Company, is looking to hire a Sr ETL Tester (Database Testing and Python) for a long term opportunity at Toronto, ON /Halifax, NS (Hybrid Position). Please respond back with your most recent resume if you would be interested..! Positio

  • ETL Data Tester

    4 days ago

    Toronto, Canada Iris Software Inc. Full time

    Iris's Fortune 100 direct client is looking for Data Test Engineer (SQL & Automation) . Please find below Job description and share me your updated resume at Position: ETL Data Tester (SQL & Automation) Location: Toronto Downtown Skills: Automation, SQL, Java, Python Key Responsibilities: Revi

  • QA SQL Etl Tester

    4 weeks ago

    Toronto, Canada AstraNorth Full time

    **JOB DESCRIPTION**: - ETL Tester - SQL, ETL & Testing - Any coding (preferably Python + Robot Framework) **Job Types**: Full-time, Fixed term contract Schedule: - 8 hour shift - Monday to Friday Work Location: Hybrid remote in Toronto, ON

  • Etl QA Tester

    4 weeks ago

    Toronto, Canada LTIMindtree Full time

    **Role--ETL Tester with Python Knowledge** **Location-Toronto, ON** **Full Time** **Exp SQL and some Unix** - **3+ Years of hands-on experience required into ETL Testing tools**: - **RDBMS systems like Oracle/Teradata/Sql Server/DB2 (Any One)**: - **Writing complex queries using Joins and Sql Server special functions**: - **Mapping Stored Procedures...

  • QA SQL Etl Tester

    2 weeks ago

    Toronto, Ontario, Canada AstraNorth Full time

    JOB DESCRIPTION: ETL Tester SQL, ETL & Testing Any coding (preferably Python + Robot Framework)Job Types: Full-time, Fixed term contractSchedule: 8 hour shift Monday to FridayWork Location: Hybrid remote in Toronto, ON

  • ETL Tester

    2 weeks ago

    Toronto, Ontario, Canada APPTOZA INC. Full time

    Job Title: ETL Tester Location: Toronto, ON (Hybrid) Duration: Long Term Contract Job Description:Key Responsibilities: 5+ Years of Software Quality Assurance experience on enterprise level applications which includes Data Warehouse Testing. Experience in writing complex SQL queries, Experience in writing complex SQL queries, ability to determine the types...

  • Etl Tester 10+year

    4 weeks ago

    Toronto, Canada E-Solution Full time

    Role: ETL Tester Location: Toronto, Ontario Job description: - Experience in writing automation test cases, creating test scenarios, executing tests scripts and analyzing test results - test strategy and execution. - Writing SQL queries for various scenarios. - Implement and execute automation test suites for integration testing with multiple...

  • Etl QA Tester

    2 weeks ago

    Toronto, Ontario, Canada LTIMindtree Full time

    RoleETL Tester with Python KnowledgeLocation-Toronto, ONFull TimeExp SQL and some Unix- 3+ Years of hands-on experience required into ETL Testing tools:- RDBMS systems like Oracle/Teradata/Sql Server/DB2 (Any One):- Writing complex queries using Joins and Sql Server special functions:- Mapping Stored Procedures experience: Analyzing the Technical and...

  • Senior QE ETL Tester

    2 weeks ago

    Toronto, Canada CGI Full time

    Position Description: This role is hybrid and requires you to be in our downtown Toronto office ( Yonge Street) 2-3 times per week - subject to change at any time. Job Title -Senior QA/QE ETL Tester We are Canada's largest independent information technology services firm, and after 40 years, we're still growing! Join Canada's largest IT Company...