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.
Data & IT Enterprise Architect
In this role, you will collaborate with leaders across IT, data management, and business units to develop a cohesive architecture that supports the organization's goals for our client, a leader in the oil and gas industry. If you are experienced in enterprise architecture, data governance, and techn...
Senior Enterprise Data Architect to develop Enterprise Data Roadmaps to address technical debt, policies, processes & strategies in the Oil & Gas Sector. (Req: 9048)
Providing guidance and consultation to individuals and groups to ensure on-going projects and initiatives are in alignment with the corporate data architecture and the evolution of key enterprise data/information management platforms supporting analytics (Data Warehouse/Lakes), content management (E...
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...
Int. Catering and Events Coordinator/Receptionist to support the Office Services Manager for a Professional Services Client
Coordinate the planning and execution of small on-premises client events and collaborate with the Admin Services team to respond to specific requests. Maintains a visible role within the Firm and to outside parties, including suppliers and other industry professionals;. Catering and Events Coordinat...
Nanny Wanted - Seeking Experienced Nanny In Calgary, Alberta $20/Hr For Occasional Weekends. I Work Out Of Town And Wat To Spoil My Lady
You will be responsible for the care of our precious infant and will help us maintain a safe and nurturing environment for our little one. The ideal candidate should be knowledgeable in CPR and have a passion for working with infants. Your main duties will include engaging with our infant, preparing...
Senior Accounts Payable Lead with SAP/JDE to manage the Procure to Pay process on a reconciliations team
Experience working with the Procure to Pay process one or more of the following:. Senior Accounts Payable Lead with SAP/JDE to manage the Procure to Pay process on a reconciliations team. This is a 14 month contract with the possibility of an extension. Experience leading a team of 4+ analysts. ...
Lead from Home: Join Our Dynamic Team with Flexibility and Growth
Requirements: A passion for leadership and driving positive change Strong communication and interpersonal skills Ability to work both independently and as part of a team A desire for professional growth and development Ready to Lead from Home? If you’re ready to elevate your career and join a ...
Intermediate Health & Safety Professional, Environment
Are you passionate about health, safety, the environment and quality (HSEQ)? Do you thrive on innovation, leadership, and making a real impact in a client centric delivery model, reinforced by a cultural and operational alignment with client values, systems and processes? We are looking for a dynami...
Manager, Data Governance & Environmental Social Governance
Lead and/or assist developing and implementing roadmaps, data management strategies, process and data flow mapping, data quality management programs, governance frameworks, business cases, cost/benefit analyses and deliverables related to the implementation of recommendations, such as policy writing...
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...