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.
Arithmetic Private Tutoring Jobs Inside Passage and the Queen Charlottes
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...
Junior Business Analyst to implement processes and create documentation for the transition to S4 HANA in maintenance and operations (8815)
Junior Business Analyst to implement processes and create documentation for the transition to S4 HANA in maintenance and operations. Business processes relating to connected applications such as Prometheus Web (Planning & Scheduling and STO) and Primavera P6. Interpreting business requirements and t...
Child & Youth Care Worker - Lac La Biche Talent Pool
The CYCW1 is a member of a multi-disciplinary team that is primarily responsible for providing direct services that ensure a safe and secure environment, and social milieu that assesses, identifies and implements the specific needs and direct program delivery for vulnerable youth in care, who are re...
Intermediate ServiceNow Developer to implement and administer new modules for ITSM, ITOM, ITAM for a healthcare client
Work closely with and facilitate discussions with internal business clients to clarify requirements and convert them into technical and functional requirements. Demonstrated experience administering a ServiceNow instance, managing the overall security of the platform, gathering and interpreting busi...
Senior Auditor, Clinical Quality and Compliance
Auditor, Clinical Quality and Compliance is to act as lead person in the establishing audit plans, assessing/securing compliance in study conduct and to provide strong support to operations via GxP consultation. Employee may be assigned to other responsibilities that do not pertain to their former d...
Senior Solution Architect to create and support Digital Transformation roadmap to identify, implement and rationalize capabilities across technology landscape.
Architectural experience using modelling languages and frameworks (UML, TOGAF, Archimate, 4 View Model, etc), architecture practices and principles in Business, Information (data), Application, Technology, and Security architecture disciplines. Excellent communication and leadership skills, with the...
Recreation Leader: Youth Drop-In & Recreation Programs - Community Services
Your previous experience has prepared you to help develop and maintain programs with a focus on lesson plans that ensure engaging, fun, and safe activities appropriate to participants that represent a variety of ages, stages and abilities. Exceptional interaction and communication skills achieving u...
Water Sales & Support Consultant (Calgary South)
You will also support sales teams, assist with sales events and displays, and continuously update your product knowledge through training and self-directed learning, ensuring accurate information is shared with customers and team members. Provide comprehensive support to the Retail and Builder sales...
cutter operator - concrete, clay and stone products
Operate machines to grind and polish surfaces of stone blocks, slabs or other stone products to specific shape or design and to produce a smooth finish. Operate blade or wire saws to cut blocks of stone to specified dimensions. Set up, adjust and operate single-function machines to mix, drill, grind...
Vice President - Risk and Compliance
We're here to provide exceptional service to our clients, and none of that happens without each of us taking care of ourselves and being there for one another. VP Risk & Compliance will play a key role in ensuring ADP Canada is well positioned for growth through the design, implementation and op...