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.
Senior Infrastructure Analyst/Test Environment Management Specialist to support integration quality assurance and testing activities.
Collaborate with cross-functional teams (development, testing, infrastructure) to define, set up, and monitor test environments, troubleshooting issues and implementing automated tools for efficiency. You will coordinate the preparation, support, and availability of test environments for both projec...
Commercial Lines Underwriter (Oil and Gas)
Start your career at Travelers with a minimum of 20 days Paid Time Off (“PTO”) annually, plus the opportunity to purchase additional days to allow for up to a total of 36 PTO days per year. Responsible for the profitability, growth, and retention of an assigned book of business through thorough know...
Senior Security Architect to identify security risks and control gaps for new technologies being implemented on behalf of a crown corporation client
Work with the technology stakeholders to explain how an assessment is performed and what information is required as part of an architecture to complete an assessment. Initial 1 Year Contract with strong possibility of extension to a maximum total term of 3 years - minimum 1-2 days/month required on-...
Will and Estate Consultant
As an integral member of Wealth Management Services, your role as a Will & Estate Consultant is to work with Investment Advisors to provide consulting services to their clients, which can then be implemented in coordination with their own tax and legal professionals. We thrive on the challenge to be...
Community Support Worker, Evening & Weekend (PT)
Maintain awareness of and adherence to Agency policies and procedures; work in accordance with Creating Excellence Together (CET) Accreditation Standards. Ability to coordinate and access appropriate services and supports with clients and their networks . Provide support with community inclusion inc...
network support technician
Maintain, troubleshoot and administer the use of local area networks (LANs), wide area networks (WANs), mainframe networks and computer workstations and peripheral equipment. Evaluate and install computer hardware, networking software and operating system software. Perform routine network start up a...
Senior Cloud Architect to migrate and consolidate Google Cloud Platform (GCP) environments for our public sector client (Req 357)
Senior Cloud Architect to migrate and consolidate Google Cloud Platform (GCP) environments. Experience working with stakeholders. Our public sector client is seeking a. Candidates can be % remote in Canada (Working MST hours) 37. ...
Intermediate Structural Engineer, Hydro & Dams
Our experts work together to provide our clients with services that live up to our vision of meeting the highest industry standards and innovating to exceed them. If you are looking to join a world-class team in the renewable energy industry, while being part of a team with strong roots in its envir...
server - food and beverage services
Present bills to customers and accept payment in cash, credit or debit cards, travellers cheques or room billings. Prepare and serve specialty food at customers' tables. Clear and clean tables, trays and chairs. Address customers' complaints or concerns. ...
Grade 12 Math & Chemistry In-Person Tutor Needed (NW Calgary)
The Tutor must also be able to adhere to a set schedule for a minimum of the student’s school term. A to Z Tutoring is looking for qualified tutors to help students reach their academic potential. Our tutors provide one-on-one tutoring in the comfort of the student’s home. We match tutors with stude...