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.
  • 30+ days ago
Related jobs
S.i. Systems
Calgary, Alberta

Intermediate Data Analyst with PowerBI and Power Automate experience to perform data validation and support a wireless service RFP implementation project. Support documentation, data validation, and other project-related tasks to aid the RFP implementation. Validate and clean up wireless service bil...

Cenovus
Calgary, Alberta

Are you looking for an exciting Student opportunity full of meaningful, diverse, and challenging assignments working alongside industry-leading professionals? You will be part of a driven, and collaborative team completing important projects while receiving the mentorship, knowledge, and experience ...

S.i. Systems
Calgary, Alberta

Understand the technology trends and the practical application of existing, new, and emerging technologies (like AI, automation) to enable new and evolving business and operating models. Provide consulting support to architects within projects to ensure the project is aligned with the proposed solut...

Care.com
Calgary, Alberta

Hi, I am looking for a pickup and drop off of our child. We'd like someone who is reliable and lives near Calgary T2R. Looking forward to hearing from you. ...

S.i. Systems
Calgary, Alberta

Intermediate to Senior Agile Business Analysts and Project Managers (5+years) to support various software developement projects and product teams in the mining industry. Experience supporting various concurrent. Business Analyst and/or Project Manager. Vast/diverse industry experience . ...

Care.com
Calgary, Alberta

Hello! Here's what we are looking for: a responsible, reliable, and hard-working senior care provider with a few years experience who lives near Calgary. Looking for someone who can help with services such as Live-in care, Domestic work and Companionship. We can't wait to hear from you!. ...

MaxSys Staffing and Consulting
Calgary, Alberta

If you're an organized, friendly individual with a passion for the automotive industry, we want to hear from you! Submit your resume to to be considered for this exciting opportunity. Are you a Licensed Mechanic with a Red Seal endorsement, passionate about automotive maintenance and repair? We have...

Care.com
Calgary, Alberta

Outside of those challenges, he's the sweetest boy that's chock full of energy, loves the outdoors & growing to try/love so many new and different things everyday. He's also pretty self sufficient, more of an extrovert, loves interacting with people, loves music (particularly Armin Van Buuren or cla...

Royal Bank of Canada
Calgary, Alberta

Work with key internal and external stakeholders to brainstorm and execute content ideas, in line with the communications and marketing strategies. This role includes both communications and marketing duties including writing, designing, developing, producing and consulting on a variety of internal ...

iSteer Inc.
CA

Represent the organization, or delegate representatives to act on behalf of the organization, in negotiations or other official functions. Select middle managers, directors or other executive staff; delegate the necessary authority to them and create optimum working conditions. Authorize and organiz...