ETL Talend Testing Lead

Galent; Markham; On-site; CAD 80,000 - 120,000; Part time

Job summary

A leading company in software development is seeking a Data Test Engineer with substantial expertise in ETL processes, SQL, and Python. The successful candidate will demonstrate strong analytical skills to manage complex data testing, including the development of comprehensive test plans. They will be responsible for maintaining high-quality standards while working on cloud-based and data warehousing projects.

Qualifications

• 5+ years of Software Quality Assurance experience on enterprise-level applications.
• Experience with Cloud Snowflake, AWS S3, and Hadoop.
• Ability to transform complex business logic into SQL or PL/SQL queries.

Responsibilities

• Testing multiple phases on medium to large projects.
• Creating requirements traceability matrix (RTM).
• Proficiency with QA automation testing tools using Python.

Skills

Software Quality Assurance

SQL

Python

Data Analysis

ETL Testing

Data Governance Principles

Tools

Informatica PowerCenter

Jira

Job description

1 day ago Be among the first 25 applicants

Direct message the job poster from Galent

Senior Executive - US IT Recruitment | Expert in C2C, W2, Contracts | Talent Acquisition Specialist with 6+ Years of Experience Pinnacle Performer at…

Individually we are people but together we are Client. Individually these are just words but together they are our Values: Care, Commitment, Community, and Confidence.

About the Job Role

As a Data Test Engineer, you must have strong technical capabilities and good knowledge of coding languages commonly used in ETL development such as Python, SQL, and XML, along with Data Warehousing concepts. You should have knowledge of troubleshooting bugs and errors and finding solutions in ETL development. Familiarity with data warehouse architecture techniques like ODS, DM, EDW, and ROLAP is also needed. Extensive experience in solving complex technical problems and troubleshooting is a must.

Key Responsibilities

• 5+ Years of Software Quality Assurance experience on enterprise-level applications, including Data Warehouse Testing.
• Experience in writing complex SQL queries and ability to determine the types of testing required (e.g., data validation, regression). Ability to evaluate requirements' testability and create comprehensive test plans supporting business and technological solutions.
• Experience testing multiple test phases in medium to large projects.
• Understanding of information governance principles and their application in testing.
• Experience and understanding of data warehouse and data mart testing.
• Identification and test data preparation techniques.
• Ability to transform complex business logic into SQL or PLSQL queries.
• Thorough knowledge of Software Test Life Cycle, Test Case Life Cycle, Defect Life Cycle, etc.
• Creating requirements traceability matrix (RTM).
• Proficiency with test case preparation and execution.
• QA automation testing tools expertise using Python.
• Extensive exposure to ETL testing with high SQL skills.
• Experience with large data sets and understanding Data Quality Framework.
• Experience in data analysis, including profiling, auditing, balancing, and reconciliation.
• Defect tracking experience (e.g., Jira, ALM).
• Experience tuning SQL queries, stored procedures, views for performance improvements.
• Detail-oriented with an analytical mindset.
• Knowledge of data models and entity relationship diagrams.
• Ability to multitask, adapt quickly, and maintain urgency in completing tasks.

Requirements

• Experience with Cloud Snowflake, AWS S3, PostgreSQL, SQL Database, Hadoop, Data Lake, and MongoDB.
• Experience using ETL tools like Informatica PowerCenter, BDM.
• Experience developing data extraction, transformation, and load programs.
• Knowledge of data modeling and design principles for data marts and warehouses.
• Excellent problem-solving and analytical skills.
• Ability to handle challenging situations and act appropriately.
• Strong learning skills and ability to guide team members.
• Self-starter, responsible, and self-driven.
• Ability to work independently and within a team.
• Commitment to high-quality output and service.

Seniority level

• Executive

Employment type

• Contract

Job function

• Information Technology

Industries

• Software Development

Referrals increase your chances of interviewing at Galent by 2x.

Get notified about new ETL Specialist jobs in Markham, Ontario, Canada.