Intermediate ETL Tester with AWS Glue, S3 and Athena experience to support the validation of data accuracy, quality, and performance.

S.i. Systems
Calgary
Full-time

Our client is looking for an Intermediate ETL Tester with AWS Glue, S3 and Athena experience to support the validation of data accuracy, quality, and performance.

This role requires you to be onsite 5 days / week, working core business hours of 8-5 with free onsite parking

Must Haves :

  • 5+ years experience as a QA specifically with ETL testing.
  • Experience with AWS Glue , AWS S3 , AWS Athena , AWS Lambda , and AWS DataSync
  • Experience working with AWS Aurora (PostgreSQL), DynamoDB , and MS SQL Server
  • Experience with test automation tools and frameworks.

Nice to Haves :

  • Experience with other AWS services such as AWS Redshift and RDS
  • Familiarity with Big Data technologies (e.g., Hadoop, Spark)
  • AWS Certification related to data analytics or data engineering

Responsibilities :

  • Lead the design, development, and implementation of ETL test strategies and plans.
  • Validate data extraction, transformation, and loading processes to ensure data quality and integrity.
  • Conduct detailed testing of data pipelines utilizing AWS Glue, ensuring transformations are correctly applied.
  • Verify data storage and retrieval from AWS S3, ensuring data consistency and accessibility.
  • Utilize AWS Athena to query and validate data stored in S3, applying SQL knowledge to perform complex queries.
  • Leverage AWS Lambda for serverless functions within the testing strategy.
  • Use AWS DataSync for data transfer operations and ensure data is accurately synchronized across environments.
  • Validate the performance and accuracy of databases such as AWS Aurora (PostgreSQL), DynamoDB, and MS SQL Server.
  • Create and maintain detailed documentation of test plans, test cases, and test results.
  • Automate testing processes where possible to streamline validation efforts.
  • Continuously monitor ETL processes post-deployment to identify and address any issues.
  • Collaborate with cross-functional teams to understand requirements and deliver high-quality test results.
  • Mentor and guide junior QA engineers and testers within the team.
  • 24 days ago
Related jobs
S.i. Systems
Calgary, Alberta

SR Data Integration Developer (Data Engineer) with SQL, Python and Azure experience to support the Data management team. Collaborate with data scientists, analysts, and stakeholders to understand data needs and translate requirements into technical solutions. Monitor and troubleshoot data pipelines ...

Promoted
Superprof
Canada

Join the Superprof team by applying here and start working as a tutor today! The Ideal profileWe’re looking for individuals who:-Are eager to share their knowledge with new students. Superprof is Canada's #1 tutoring platform, and we're actively recruiting passionate tutors! Whether you're a student...

S.i. Systems
Calgary, Alberta

SCADA Systems experience to provide critical integration support and solutions. Upstream oilfield automation, compliance, and operations experience. Investigate and troubleshoot customer and internal issues. Provide support to clients, 24/7 control room, and field services staff. ...

The Toronto-Dominion Bank (Canada)
Calgary, Alberta

Can you bring your charming self to work and make customer interactions delightful one? Can you process financial transactions accurately and get a sense of achievement by providing excellent customer experience? If so then, take the next step to your future today and apply for the position of a . W...

S.i. Systems
Calgary, Alberta

This role requires the candidate to be local to Calgary to be in the office 3 days a week. Junior Business Analyst to gather and develop requirements for operations, projects, and provide input into the scrum methodology for delivering sprints for various products. ...

Deloitte
Calgary, Alberta

We bring together people with unique experiences and talents, and we are the place to develop a lasting network of friends, peers, and mentors. As a Senior Consultant, you will be working collaboratively across the data and analytics domains, helping some of the largest, most interesting organizatio...

Mannarino Systems & Software
Anywhere - Canada

Work with System Engineers and Embedded Software Developers to design software test cases and procedures to verify the applicable software requirements. Knowledge of English is required to communicate and work with customers outside the province of Quebec. The MANNARINO culture is focused on high qu...

LaowaiCareer
Calgary, Alberta

Only interns with fluent English, proficient with Microsoft Excel and other Microsoft Office applications should apply. Your daily duties and responsibilities shall consist of, but not limited to the following:. Schedule and coordinate speaking engagements, appearances, photo shoots, and other speci...

MaxSys Staffing and Consulting
Calgary, Alberta

Locate information for customers, use knowledge of film to advise customers on packaging needs to clearly communicate with customers in a positive manner reflecting Company’s philosophy of exceeding customer expectations for excellent customer support. Job Summary: Perform duties related to the Comp...

Marlon and Elsa Antonio
Chestermere, Alberta

Assist clients with bathing and other aspects of personal hygiene. Supports newcomers and/or refugees with foreign credential recognition. Develops and maintains relationships with indigenous communities, indigenous-owned businesses and organizations. Experience: 1 year to less than 2 years. ...