1

Etl Testing Jobs in Alberta (NOW HIRING)

Partner with Data Engineers to validate data pipelines, ETL processes, and data integrity during testing phases. * Reporting: Build simple Power BI reports and dashboards to track and visualize test ...

Implement scalable ETL/data transformation workflows using Databricks or similar platforms * Write ... Ensure code quality through automated testing and code reviews * Collaborate with cross-functional ...

Lead the implementation of modern data platforms and architectures on Databricks (including ETL, workload migrations, and Unity Catalog). * Design and implement data pipelines using Azure Databricks ...

Lead the design and implementation of modern data platforms and architectures on Databricks (including ETL, workload migrations, and Unity Catalog). * Partner with client executives and technical ...

Build and maintain ETL pipelines that harvest data from operational systems and load the data into the warehouse. Work with Business Analysts and Developers to ensure the warehouse contains the ...

Strong experience working with both batch and real-time ETL involving large data sets * Experience mentoring and guiding Junior Data Engineers in previous roles * Strong Experience working with SQL ...

Strong experience working with both batch and real-time ETL involving large data sets * Experience mentoring and guiding Junior Data Engineers in previous roles * Strong Experience working with SQL ...

Strong experience working with both batch and real-time ETL involving large data sets * Experience mentoring and guiding Junior Data Engineers in previous roles * Strong Experience working with SQL ...

Establish scalable ETL/ELT processes that efficiently ingest, transform, and prepare data from diverse sources for analytics and reporting. Build and manage GCP resources using Pulumi and YAML ...

next page

Showing results 1-20

Etl Testing information

What is the difference between Etl Testing vs Data Analyst?

AspectEtl TestingData Analyst
Primary FocusValidating data extraction, transformation, and loading processesAnalyzing data to identify trends and generate reports
Skills & CertificationsSQL, ETL tools, data warehousing certificationsSQL, Excel, data visualization tools, statistical knowledge
Work EnvironmentData warehouses, ETL pipelines, testing environmentsBusiness intelligence platforms, dashboards, reporting tools
Industry UsageData integration, ETL process validationData analysis, reporting, decision support

While Etl Testing focuses on validating data movement and transformation processes within data pipelines, Data Analysts interpret and analyze data to support business decisions. Both roles require SQL skills and work with data, but Etl Testing emphasizes quality assurance of data workflows, whereas Data Analysts focus on insights and reporting.

What are some common challenges faced by ETL Testers during data migration projects?

ETL Testers often encounter challenges such as handling large volumes of data, ensuring data integrity during migration, and dealing with inconsistent or incomplete source data. They must be vigilant about identifying data anomalies, mapping errors, and performance bottlenecks in ETL pipelines. Close collaboration with data engineers and business analysts is essential to clarify data requirements and resolve discrepancies, ensuring seamless and accurate data transitions.

What are the key skills and qualifications needed to thrive as an ETL Tester, and why are they important?

To thrive as an ETL Tester, you need a solid understanding of data warehousing concepts, SQL proficiency, and experience with ETL processes, typically supported by a degree in computer science or a related field. Familiarity with ETL tools like Informatica, Talend, or SSIS, as well as testing frameworks and defect tracking systems, is commonly required. Strong analytical thinking, attention to detail, and effective communication skills help ETL Testers identify data inconsistencies and collaborate with developers and business analysts. These skills ensure accurate data migration, high-quality deliverables, and support critical business decision-making based on reliable data.

What is ETL testing?

ETL testing refers to the process of validating, verifying, and ensuring the accuracy of data as it moves through the Extract, Transform, and Load (ETL) process in data warehousing. This type of testing ensures that the data extracted from source systems is correctly transformed according to business rules and loaded into the target system without loss or corruption. ETL testers check for data completeness, data integrity, and performance of the ETL process, helping organizations maintain high-quality, reliable data for analytics and reporting.

What Are ETL Testing Jobs?

ETL testing jobs are data management and software jobs in which your responsibilities are to use an extract-transform-load test to ensure that data migration projects work properly. Specifically, your duties are to ensure that information extraction that comes from different sources and is to be presented differently by the destination source is transformed and loaded into a data warehouse properly. As an ETL tester, you may work for a specific company or for a business intelligence consulting firm that specializes in ETL testing and designing new data applications. You can also consult on a freelance basis.

What are popular job titles related to Etl Testing jobs in Alberta? For Etl Testing jobs in Alberta, the most frequently searched job titles are:
What job categories do people searching Etl Testing jobs in Alberta look for? The top searched job categories for Etl Testing jobs in Alberta are:
Infographic showing various Etl Testing job openings in Alberta as of July 2026, with employment types broken down into 79% Full Time, and 21% Contract. Highlights an 100% In-person job distribution.
Senior Consultant, Databricks Data Engineer, Data & AI

Senior Consultant, Databricks Data Engineer, Data & AI

KPMG

Calgary, AB

Full-time

Posted 19 days ago


Job description

Overview

At KPMG in Canada, our people bring their unique perspectives to Canada’s most important challenges. Here, you can build momentum that reaches beyond our business, develop skills for the future, and take ownership of your career with support at every stage. Join a firm where your career can make a difference.

Are you a talented leader with a proven track record for motivating teams and delivering exceptional client service?

Our team is looking for a Data Engineer with extensive hands-on expertise in Databricks and strong consulting capability. This role will support and lead modernization initiatives from legacy/on-prem data platforms to scalable, secure, and cost-optimized Lakehouse architectures using Databricks and similar technologies.


What you will do
  • Partner with clients to understand business goals, gather requirements, and translate them into actionable technical designs and delivery plans.
  • Work with the engagement team to translate business and analytics requirements into a data strategy for the engagement including ETL/ELT, data model, and staging data for analysis.
  • Contribute to end-to-end solution architecture for repeatable, cost-optimized implementations (including non-functional requirements and operational readiness).
  • Lead delivery of modern data platforms on Databricks (ETL/ELT pipelines, workload migrations, governance enablement).
    • Implement Delta Lake / Lakehouse patterns including medallion architecture, CDC, incremental processing, and data quality controls.
    • Develop data pipelines to support streaming, incremental, batch data, etc.
    • Design and implement scalable batch and streaming pipelines using Spark and modern orchestration patterns.
    • Apply CI/CD and engineering best practices (version control, automated deployment, testing, and release management) to data engineering workflows.
    • Establish and operationalize governance using Unity Catalog, including access controls, lineage, and security frameworks.
  • Support testing and production releases, including troubleshooting, performance tuning, and stabilization.
  • Proactively contributes to the creation of presentation materials relating to data activities for stakeholder discussions.

What you bring to the role
  • University degree in computer engineering, mathematics, data science or related disciplines
  • 4+ years of professional experience in a related field like Data Engineering, Business Intelligence, or related field with a track record of manipulating, processing, and extracting value from large datasets.
  • 2+ years of hands-on experience with Databricks, including advanced features (Delta Lake, Unity Catalog) with Databricks or cloud certifications with 1-2 years of experience leading workstreams / client-facing delivery.
  • Strong proficiency in SQL and solid understanding of modern data modeling principles, dimensional modeling, and data warehousing concepts.
  • Proficiency in Python (or similar scripting languages) for data processing, automation, and analytical workflows
  • Strong experience working in teams to perform ETL (extract, transform and load) of data from a variety of databases from SQL, NoSQL, etc.
  • Proven experience leading large-scale data migrations (ETL, workloads, cloud platforms), including migration of legacy data platforms or ETL workloads to cloud-native environments.
  • Experience applying CI/CD practices to data engineering workflows, including version control, automated deployment, and pipeline orchestration.
  • Independent ability to review the data quality and data definitions and perform data cleansing and data management tasks.
  • Experience collaborating within cross-functional and multi-disciplinary teams to solve complex data challenges, including processing semi-structured and unstructured data
  • Experience in at least one major cloud service: AWS, Azure and GCP with understanding of cloud-native services, identity management, and scalable architecture principles.
  • Certifications: Databricks Certified Data Engineer (Associate or Professional) and/or relevant cloud certifications (e.g., Azure, AWS, or GCP architecture or data engineering credentials) are preferred.

KPMG Ontario Region Pay Range Information

The expected base salary range for this position is $77,000 to $102,000 and may be eligible for bonus awards. The determination of an applicant’s base salary within this range is based on the individual’s location, skills & competencies, and unique qualifications. In addition, KPMG offers a comprehensive and competitive Total Rewards program.

KPMG BC Region Pay Range Information   

The expected base salary range for this position is $73,000 to $100,000 and may be eligible for bonus awards. The determination of an applicant’s base salary within this range is based on the individual’s location, skills & competencies, and unique qualifications. In addition, KPMG offers a comprehensive and competitive Total Rewards program. 

Providing you with the support you need to be at your best


Our Values, The KPMG Way

Integrity, we do what is right | Excellence, we never stop learning and improving | Courage, we think and act boldly | Together, we respect each other and draw strength from our differences | For Better, we do what matters

KPMG in Canada is a proud equal opportunities employer and we are committed to creating a respectful, inclusive and barrier-free workplace that allows all of our people to reach their full potential. A diverse workforce is key to our success and we believe in bringing your whole self to work. We welcome all qualified candidates to apply and hope you will choose KPMG in Canada as your employer of choice.

Adjustments and accommodations throughout the recruitment process

At KPMG, we are committed to fostering an inclusive recruitment process where all candidates can be themselves and excel. We aim to provide a positive experience and are prepared to offer adjustments or accommodations to help you perform at your best. Adjustments (informal requests), such as extra preparation time or the option for micro breaks during interviews, and accommodations (formal requests), such as accessible communication supports or technology aids, are tailored to individual needs and role requirements. You will have an opportunity to request an adjustment or accommodation at any point throughout the recruitment process. If you require support, please contact KPMG’s Employee Relations Service team by calling 1-888-466-4778.

AI Usage

Weembrace the use of artificial intelligence (AI) to enhance the candidate experience and streamline our recruitment processes. AI tools may help with organizing applications or surfacing relevant qualifications. However, no hiring decisions are made using AI. Every hiring decision is made by our hiring managers and recruitment professionals, who are equipped with training that empowers them to use these tools responsibly. AI technologies used in our recruitment process undergo detailed risk assessments, including security and privacy requirements, that align with KPMG’s Trusted AI framework.

We believe technology should empower human judgment, not replace it. It’s one of the many ways we’re delivering on our vision of being a technology-first, people-driven firm.

Qualifications:
  • University degree in computer engineering, mathematics, data science or related disciplines
  • 4+ years of professional experience in a related field like Data Engineering, Business Intelligence, or related field with a track record of manipulating, processing, and extracting value from large datasets.
  • 2+ years of hands-on experience with Databricks, including advanced features (Delta Lake, Unity Catalog) with Databricks or cloud certifications with 1-2 years of experience leading workstreams / client-facing delivery.
  • Strong proficiency in SQL and solid understanding of modern data modeling principles, dimensional modeling, and data warehousing concepts.
  • Proficiency in Python (or similar scripting languages) for data processing, automation, and analytical workflows
  • Strong experience working in teams to perform ETL (extract, transform and load) of data from a variety of databases from SQL, NoSQL, etc.
  • Proven experience leading large-scale data migrations (ETL, workloads, cloud platforms), including migration of legacy data platforms or ETL workloads to cloud-native environments.
  • Experience applying CI/CD practices to data engineering workflows, including version control, automated deployment, and pipeline orchestration.
  • Independent ability to review the data quality and data definitions and perform data cleansing and data management tasks.
  • Experience collaborating within cross-functional and multi-disciplinary teams to solve complex data challenges, including processing semi-structured and unstructured data
  • Experience in at least one major cloud service: AWS, Azure and GCP with understanding of cloud-native services, identity management, and scalable architecture principles.
  • Certifications: Databricks Certified Data Engineer (Associate or Professional) and/or relevant cloud certifications (e.g., Azure, AWS, or GCP architecture or data engineering credentials) are preferred.

KPMG Ontario Region Pay Range Information

The expected base salary range for this position is $77,000 to $102,000 and may be eligible for bonus awards. The determination of an applicant’s base salary within this range is based on the individual’s location, skills & competencies, and unique qualifications. In addition, KPMG offers a comprehensive and competitive Total Rewards program.

KPMG BC Region Pay Range Information   

The expected base salary range for this position is $73,000 to $100,000 and may be eligible for bonus awards. The determination of an applicant’s base salary within this range is based on the individual’s location, skills & competencies, and unique qualifications. In addition, KPMG offers a comprehensive and competitive Total Rewards program. 

Providing you with the support you need to be at your best

Education:UNAVAILABLEEmployment Type: FULL_TIME