Data Engineer ETL Tester

3 weeks ago

Greater Ottawa Metropolitan Area, Canada LeverageTek Staffing Solutions Full time

LeverageTek is actively seeking a Data Engineer ETL Tester for a permanent position with its Ottawa-based customer.



Work Location

  • The successful candidate will be required to work on-site 1x/week at the customer headquarters in Ottawa, ON.



Key Tasks

  • Lead, manage, plan, and coordinate the Data testing activities: Test Strategies, Test Plans, Test Cases, and Test Scripts
  • Write and execute complex SQL or Spark based Test Scripts, on the Azure Databricks platform, for data warehouse/engineering processes based on documented data mapping and data transformation rules
  • Record test execution results and evidence of test in Azure DevOps
  • Ensure the test activities are planned and performed according to requirements and standards from the Test Center of Excellence
  • Coordinate and support the business with User Acceptance Testing
  • Lead defect triage meeting. Document defects, work with developers to resolve, and retest
  • Develop technical system specifications and standard operating procedures documents
  • Collaborate, share knowledge, and mentor team members
  • Participate in team meetings to provide a status report of work in progress, accomplished and problems / issues encountered
  • Participate in technical meetings with client staff and advise client with technical option analyses based on leading practices



Key Qualifications

  • Minimum 5 years work experience writing tests cases and tests scripts based on documented data mapping and business data transformation rules
  • Minimum 5 years work experience with various types of software testing such as functional, integration, system integration, performance, etc. for data transformation processes
  • Minimum 5 years work experience with Microsoft Azure data platform: Azure Databricks, SQL, Databases, Azure Data Lake
  • Minimum 5 years experience with the following:
  • Experience in systems development with analysis, design, development, testing and deployment of software systems
  • Experience with the implementation of batch and stream data processing pipelines
  • Experience writing complex SQL queries, performance tuning and data optimization
  • Designing, developing, implementing, and testing data solutions for reporting applications such as Power BI



Qualifications

  • Experience working on large scale data analytics projects
  • Experience with the development of Microsoft Power BI reports and dashboards
  • Ability to communicate clearly in conversation and in presentations to both technical and non-technical staff, and to provide updates to all levels of management and customer
  • Experience with Agile sprint development using Azure DevOps
  • Experience working with spatial data is an asset (nice to have)



About LeverageTek IT Solutions

  • Thank you for taking the time to apply Since our company’s inception in March 2003, LeverageTek IT Solutions has worked resolutely to become one of the industry’s most recognized and trusted suppliers of technology staffing and business consulting services. With hundreds of successful engagements to our credit with many of Canada’s leading public and private sector organizations, we are the experts in identifying, deploying, and supporting IT and business talent on a contract, contract-to-hire, and permanent basis. We work with customers across all sectors including academia, aerospace, aviation, finance, government, health care, high tech, military, not-for-profit, and more.


Our responsive service and ability to deliver the right fit, on time and within budget, typically leads to repeat engagements and a long-standing relationship.

Accessibility accommodations are available upon request.

  • Data Engineer ETL Tester Lead

    3 weeks ago

    Greater Ottawa Metropolitan Area, Canada LeverageTek Staffing Solutions Full time

    Job Title: Data Engineer ETL Tester LeadWe are seeking a skilled Data Engineer ETL Tester to lead our data testing activities, ensuring the quality and accuracy of our data solutions. The successful candidate will be required to work on-site at our customer's headquarters in Ottawa, ON.Key Responsibilities:Plan, coordinate, and execute test strategies, test...

  • Data Engineer ETL Tester

    3 weeks ago

    Greater Ottawa Metropolitan Area, Canada LeverageTek Staffing Solutions Full time

    LeverageTek is actively seeking a Data Engineer ETL Tester for a permanent position with its Ottawa-based customer.Work Location The successful candidate will be required to work on-site 1x/week at the customer headquarters in Ottawa, ON.Key TasksLead, manage, plan, and coordinate the Data testing activities: Test Strategies, Test Plans, Test Cases, and Test...

  • Data Engineer ETL Tester

    3 weeks ago

    Greater Ottawa Metropolitan Area, Canada LeverageTek Staffing Solutions Full time

    LeverageTek is actively seeking a Data Engineer ETL Tester for a permanent position with its Ottawa-based customer.Work Location The successful candidate will be required to work on-site 1x/week at the customer headquarters in Ottawa, ON.Key TasksLead, manage, plan, and coordinate the Data testing activities: Test Strategies, Test Plans, Test Cases, and Test...

  • Data Engineer ETL Tester

    4 days ago

    Ottawa, Canada LeverageTek Staffing Solutions Part time

    LeverageTek is actively seeking a Data Engineer ETL Tester for a 12-month contract with its Ottawa based customer. Work LocationThe successful candidate will be required to work on-site 1x/week at the customer headquarters in Ottawa, ON. Security RequirementMust be eligible for a Government of Canada Enhanced Reliability Clearance. Key TasksLead, manage,...

  • Lead Data Engineer for Advanced ETL Solutions

    2 days ago

    Greater Kitchener-Cambridge-Waterloo Metropolitan Area, Canada Messagepoint Full time

    We are seeking a seasoned Lead Data Engineer to spearhead the implementation of cutting-edge ETL solutions utilizing AWS Glue.This pivotal role involves designing and configuring scalable, configuration-driven ETL processes for ingesting, wrangling, and transforming heterogeneous data sources into a centralized data lake.As a trusted leader in our technology...

  • Senior ETL Developer for Data Transformation

    6 days ago

    Greater Kitchener-Cambridge-Waterloo Metropolitan Area, Canada Messagepoint Full time

    Messagepoint is a leading software company that enables large enterprises to deliver enhanced customer experiences and achieve a better bottom line by optimizing their omni-channel customer communications.We are seeking an experienced Senior Software Developer specializing in AWS Glue and ETL to lead the integration and adoption of AWS Glue within our...

  • ETL Developer

    2 weeks ago

    Greater Montreal Metropolitan Area, CA TALTEK | TALENT en TECHNOLOGIE Full time

    TALTEK cherche à combler le poste suivant pour l’un de ses clients :Poste permanent : Développeur ETL (ADF)RÉSUMÉ DU POSTESous la responsabilité du BI Manager, qui fait partie du Group IT VP (CIO), le développeur ETL sera responsable de la conception, du développement, de la mise en œuvre et du soutien des processus ETL requis pour le Datawarehouse...

  • Data Engineer

    4 weeks ago

    Ottawa, Ontario, Canada ipvisibility Full time

    Key ResponsibilitiesData Ingestion - Design, develop, and maintain ETL jobs to ingest data into Data Lake and load data to datamarts.Data Integration - Extract data to integrate with various business applications.Data Parsing - Parse unstructured and semi-structured data such as XML.Data Mapping - Design and develop efficient mapping and workflows to load...

  • Chief Data Engineer

    7 days ago

    Greater Montreal Metropolitan Area, Canada PrecisionERP Incorporated Full time

    PrecisionERP Incorporated is seeking a highly skilled Data Architect for a 4-5 month contract in Montreal, Canada. This hybrid role offers the perfect blend of remote work and on-site collaboration.The ideal candidate will possess at least 5 years of experience in delivering data engineering projects using agile methodologies and rapid prototyping...

  • Chief Data Engineering Solutions Specialist

    5 days ago

    Greater Montreal Metropolitan Area, Canada PrecisionERP Incorporated Full time

    PrecisionERP Incorporated is seeking a skilled Chief Data Engineering Solutions Specialist for a 4-5 month contract in Montreal. The role offers a hybrid work arrangement with two days onsite per week.**Estimated Salary:** $120,000 - $150,000 per annumWe require candidates with at least five years of experience in delivering data engineering projects using...

  • Senior Data Engineer

    7 days ago

    Greater Toronto Area, Canada Robert Half Full time

    Key Responsibilities:Lead the migration of existing ETL processes from Azure Data Factory and SQL procedures to DatabricksRedesign and optimize 15 data modelsImplement Delta Lake and Databricks SQL for efficient data warehousingDevelop scalable and performant data pipelines using Spark and Delta Live TablesCollaborate with BI and data science teams to ensure...

  • AWS Glue Data Engineer

    1 week ago

    Greater Kitchener-Cambridge-Waterloo Metropolitan Area, Canada Messagepoint Full time

    Job DescriptionWe are seeking an experienced AWS Glue Data Engineer to lead the integration and adoption of AWS Glue within our technology stack. This pivotal role focuses on designing and implementing scalable, configuration-driven ETL processes for ingesting, wrangling, and transforming heterogeneous data sources into a centralized data lake.The ideal...

  • AWS Data Engineer

    7 days ago

    Greater Toronto Area, Canada Compunnel Inc. Full time

    8+ years of experience in Data Engineer with AWS, Glue, Lambda, SQL, Python, Dovps, Redshift.1 .Must have working knowledge in designing and implementing data pipelines on any of the cloud providers (AWS is preferred). Must be able to work with large volumes of data coming from various sources. Perform data cleansing, data validation etc2. Hands on ETL...

  • Senior Data Engineering Project Lead

    3 days ago

    Greater Montreal Metropolitan Area, Canada PrecisionERP Incorporated Full time

    PrecisionERP Incorporated is a leading provider of innovative ERP solutions, seeking an exceptional Senior Data Engineering Project Lead to join our team for a 4-5 month contract in Montreal. This role offers the perfect blend of challenge and opportunity, with 2 days onsite per week and a comprehensive compensation package.The ideal candidate will possess a...

  • SQL Developer

    5 days ago

    Greater Ottawa Metropolitan Area, CA LeverageTek Staffing Solutions Full time

    LeverageTek is actively seeking a SQL Developer/Data Architect for a 6-month contract with its Ottawa-based customer.Work LocationRemote position with 5-10% travel requirement to Montreal.Key TasksDefine and document data ETL procedures, standards, and metrics to support customer analytics business rules.Establish data quality processes and compliance with...

  • Senior Cloud Data Engineering Lead

    2 days ago

    Greater Toronto Area, Canada Compunnel Inc. Full time

    At Compunnel Inc., we are seeking a highly skilled Senior Cloud Data Engineering Lead to join our team.We offer a competitive salary of $250,000 per annum.Job Description:We are looking for an experienced data engineer with expertise in designing and implementing data pipelines on cloud providers, preferably AWS. The ideal candidate should be able to work...

  • Data Architect

    3 days ago

    Greater Ottawa Metropolitan Area, Canada LeverageTek Staffing Solutions Full time

    Job DescriptionWe are seeking an experienced Data Architect to lead the development of enterprise analytics solutions for our Ottawa-based customer. As a key member of our team, you will be responsible for designing and implementing data architectures that meet the evolving needs of our clients.About the Role:Define and document data ETL procedures,...

  • Senior Data Engineer

    1 week ago

    Greater Toronto Area, Canada Robert Half Full time

    Key Responsibilities:Lead the migration of existing ETL processes from Azure Data Factory and SQL procedures to DatabricksRedesign and optimize 15 data modelsImplement Delta Lake and Databricks SQL for efficient data warehousingDevelop scalable and performant data pipelines using Spark and Delta Live TablesCollaborate with BI and data science teams to ensure...

  • Senior Data Engineer

    1 week ago

    Greater Toronto Area, Canada Robert Half Full time

    Key Responsibilities:Lead the migration of existing ETL processes from Azure Data Factory and SQL procedures to DatabricksRedesign and optimize 15 data modelsImplement Delta Lake and Databricks SQL for efficient data warehousingDevelop scalable and performant data pipelines using Spark and Delta Live TablesCollaborate with BI and data science teams to ensure...

  • Senior Data Engineer

    1 week ago

    Greater Toronto Area, Canada Robert Half Full time

    Key Responsibilities:Lead the migration of existing ETL processes from Azure Data Factory and SQL procedures to DatabricksRedesign and optimize 15 data modelsImplement Delta Lake and Databricks SQL for efficient data warehousingDevelop scalable and performant data pipelines using Spark and Delta Live TablesCollaborate with BI and data science teams to ensure...