Data Engineer ETL Tester
4 days ago
LeverageTek is actively seeking a Data Engineer ETL Tester for a 12-month contract 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.
Security Requirement
Must be eligible for a Government of Canada Enhanced Reliability Clearance.
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 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
- Minimum 5 years work experience with Microsoft Azure data platform: Azure Databricks, SQL, Databases, Azure Data Lake
- 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
Assets
- Experience working with spatial data
About LeverageTek Staffing Solutions
Thank you for taking the time to apply. Since our company's inception in March 2003, LeverageTek Staffing Solutions has worked resolutely to become one of the industry's most recognized and trusted suppliers of complete cross-functional staffing services. With hundreds of successful engagements to our credit with many of North America's leading public and private sector organizations, we are the experts in identifying, deploying, and supporting talented individuals to 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 timeJob 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 timeLeverageTek 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 timeLeverageTek 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 timeLeverageTek 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,...
-
Data Engineer
4 weeks ago
Ottawa, Ontario, Canada ipvisibility Full timeKey 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...
-
Tester
6 months ago
Ottawa, Canada 49 Solutions Full time49 Solutions is looking for a Tester Consultant to support Health Canada and the Health Products and Food Branch (HPFB) to help Canadians make health choices by modernizing business efficiency and coordinating Information Technology (IT) systems and departmental strategies on the Pharmacovigilance and Materiovigilance IT Plan Initiatives and Programs. If...
-
Data Engineer
7 months ago
Ottawa, Canada Tomlinson Group of Companies Full timeAs a Data Engineer at Tomlinson, you will play a crucial role in collaborating with the Data Architect and AI team to develop and implement data integration strategies, build data pipelines, perform data modeling, ensure data governance, and plan scalable solutions. You will work with various business units to handle diverse data objects from disparate...
-
Data Insights Professional
1 week ago
Ottawa, Ontario, Canada ECF Data, LLC Full timeWe are seeking a highly skilled Data Insights Professional to lead our data collection and analysis efforts. This role will be instrumental in developing, implementing, and managing databases, data systems, and analytics strategies that optimize statistical efficiency and quality.Key Responsibilities:Interpret complex data sets, analyze results using...
-
Data Engineer
3 weeks ago
Ottawa, Ontario, Canada Tomlinson Group of Companies Full timeData Engineer Job DescriptionTomlinson Group of Companies is seeking a skilled Data Engineer to join our team. As a key member of our data infrastructure team, you will play a crucial role in designing and implementing scalable data solutions on cloud platforms.Key Responsibilities:Collaborate with cross-functional teams to design and implement data...
-
Ottawa, Ontario, Canada Nexus Systems Group Inc. Full timeJob Description:Nexus Systems Group Inc. is seeking a highly skilled AWS Data Architect Senior Developer to join our team. This role requires a strong focus on designing, implementing, and maintaining scalable data pipelines, databases, and data warehousing solutions using AWS technologies.About the Role:The successful candidate will be responsible for...
-
Data Collection/Analytical Specialist
3 months ago
Ottawa, Canada ECF Data, LLC Full timeWe are looking for a skilled and experienced Data Collection/Analytical Specialist to gather, clean and analyse data as well as present the findings. The individual will be in charge of managing our current data systems and develop, implement and manage new databases, data collection systems, data analytics etc. The Data Collection/Analytical Specialist must...
-
Ottawa, Ontario, Canada BlackBerry Inc. Full timeBlackBerry Radar - Senior Data DeveloperEstimated Salary: $120,000 - $180,000 per yearApply locations:Time type:Job Requisition ID:Worker Sub-Type:Company OverviewAt BlackBerry Inc., our mission is to revolutionize the transportation industry by harnessing the power of data. Our cutting-edge IoT Business Unit combines innovative solutions to drive business...
-
Data Engineer
3 months ago
Ottawa, Canada Thales Full timeLocation: Ottawa, CanadaIn fast changing markets, customers worldwide rely on Thales. Thales is a business where brilliant people from all over the world come together to share ideas and inspire each other. In aerospace, transportation, defence, security and space, our architects design innovative solutions that make our tomorrow's possible.For decades,...
-
AWS Data Architect Senior Developer
3 months ago
Ottawa, Canada Nexus Systems Group Inc. Full timeAWS Data Architect Senior DeveloperSCOPE: As an AWS Data Architect Senior Developer, you will be responsible for designing, implementing, and maintaining AWS data pipelines, databases, and data warehousing solutions. You will collaborate closely with our cross-functional teams to ensure efficient data extraction, transformation, loading (ETL), and reporting...
-
Fleet Data Systems Developer
3 days ago
Ottawa, Ontario, Canada BlackBerry Inc. Full timeAbout the Role:We are seeking an experienced Fleet Data Systems Developer to join our team at BlackBerry Inc. In this role, you will design and develop technology to help the transportation industry move into the Internet age by connecting their assets to the Cloud.Key Responsibilities:Design, develop, and maintain high-performance data pipelines to...
-
Software Tester
1 month ago
Ottawa, Ontario, Canada Ford Motor Company Full timeAbout the RoleWe are seeking a skilled Software Tester to join our Vehicle Software Platform group. The team is responsible for designing and building the next generation software platform for Ford vehicles. In this role, you will have the opportunity to work on the Over-the-Air (OTA) Software Updates framework, capable of updating the entire vehicle...
-
Data Analytics Professional
4 weeks ago
Ottawa, Ontario, Canada CB Canada Full timeJob Title: ETL Developer – Data AnalyticsJob Description:We are looking for a skilled ETL Developer to join our Data Analytics team. As an ETL Developer, you will be responsible for designing, building, and maintaining complex data transformations. Your primary goal will be to load target databases using best practices and standards, while ensuring data...
-
Environmental and Sustainability Engineer
2 weeks ago
Ottawa, Canada The Chemical Engineer Full timep>Chemistry that MattersA career at SABIC provides you with an opportunity to leave a lasting positive impact on the world and yourself. From excellent health and well-being benefits to our comprehensive learning programs, we offer a wide range of benefits that recognize that our people have unique motivations and ambitions. p>As one of the world’s largest...
-
Database Systems Engineer
3 weeks ago
Ottawa, Ontario, Canada SEAMS DATA Full timeJob DescriptionWe are seeking a highly skilled Database Systems Engineer to join our team at SEAMS DATA.ResponsibilitiesDesign and develop database systems to meet the needs of our organization.Operate and manage database management systems to analyze complex data sets.Develop and implement data administration policies, standards, and models to ensure data...
-
Data Analytics
6 months ago
Ottawa, Canada CB Canada Full timeETL Developer – Data AnalyticsJob Description:The Data Analytics team is receiving an unprecedented number of requests for work packages. These requests require Impact Analysis and estimates for both Tower and CPC requests which require dedicated resources to work with the business, understand requirements, and delve into the code and database design. You...