***For One of the Most Established (TOP10) Canadian Insurance Company in Canada!
Data Quality Engineer (ETL QA - Google Cloud Platform - GCP)
Position: Data Quality Engineer (ETL QA- Google Cloud Platform - GCP)
Rate / Compensation Total Package: $60.00 - $70.00 / hr INC.
Duration: 6-month (possibility of extension)
Working Structure: Hybrid - 40 Hours Per week
Location (On-site vs. Remote): 2 days on-site either in downtown Toronto or Waterloo Office
Start Date: ASAP
Interview Process: 1 interview with (Senior QA Lead)
Top 3 skills:
1. 7+ years of experience Quality Engineering in ETL
2. 7+ years of experience in python, SQL and BigQuery
3. GCP background *MUST HAVE*************
Nice-to-haves:
· Financial Services or Insurance
**** Currently, a lot of their Guidewire Data is on AWS because that's guidewire's preferred cloud platform. They have to have data engineers build ETL pipelines from AWS to GCP so they can use big query and other Google Analytics tools for their Data use. ****
Job Description:
CorGTA has partnered with an insurance client in the GTA (either Waterloo or downtown Toronto) in search of a Data Quality Engineer on a 6-month contracting basis with extension possibilities. The Data Quality Engineer will be a part of the continued design and development of an enterprise Data Hub which is usable for Data Science, Big Data and future Machine Learning.The successful candidate will come with strong experience in ETL quality engineering, python, SQL, BigQuery and GCP cloud.
Job Responsibilities:
- 7+ years’ experience in Quality engineering Datawarehouse, Cloud knowledge in GCP (GCP is needed, AWS or Azure as optional)
- 7+ years’ experience in technical area of specialty, specifically SQL, BigQuery, Cloud, Python/Pyspark and any data platform
- Knowledge on Airflow DAG, Cloud composer, Looker studio is must
- Experience in any DH Automation tools or technologies (Python/Pyspark)
- Experience in data ingestion, ETL testing, data integrity testing and Cloud testing
- Strong ability to analyze the business and user requirements and translate them into testing deliverables such as testing data, SQL query and validate expected results.
- Strong Ability to create test strategies, test plans and execute tests
- Strong ability to provide triage support on testing results and provide guidance and confidence to stakeholder for the closure path.
- Ability to create solutions to various complex DATA testing challenges.
- Ability to create various metrics and provide insight to stakeholders upfront with recommendations.
Additional Skills/Qualifications:
- Undergraduate/Postgraduate degree in Computer Science or a related discipline.
- Experience within the Insurance Industry
- Working knowledge on JIRA board/Zephyr is mandatory.
- Experience of Agile software development practice and methodologies
- Goal oriented; must be able to remove roadblocks and deliver goals.
- Strong communication and interpersonal skills
- Proven ability to adapt quickly and easily to change.
- Ability to work in onshore offshore model is added advantage.