Skills Required:

  • MUST be eligible for Reliability Status Clearance i.e. Candidate must be CONTINUOUSLY working in Canada for last 5+ Years
  • 5+ years of experience working with complex technical environments, multiple IT platforms (Windows, Unix, Cloud, ETL technologies)
  • 3+ years of experience in creating ETL jobs using AWS Glue
  • Experience in creating python scripts using data libraries
  • Worked on Spark- PySpark or Scala
  • Experience with Relational SQL (Oracle, Postgres, SQL Server) databases
  • Strong knowledge of SQL query language
  • Good understanding / Hands- on with AWS data services like Glue, Step function, Lambda, AWS Workflows, S3, Redshift, ODS
  • Experience in working with AWS SDK and integration with various AWS services
  • Experience with ETL development tools (PowerCenter and/or SSIS)
  • Experience with Powershell scripting
  • Experience with Windows/Unix scripting languages
  • Experience with SFTP and TCP network protocols
  • Experience with Job schedulers (Control-M)
  • Experience with integrating vendor packages into an established production environment consisting on various technologies and platforms
  • Knowledge of Active Directory, Single Sign-On and Web Hosting concepts
  • Proficient with the ITIL framework and processes such as Change, Incident, Problem and Configuration Management
  • Must be able to obtain Reliability Status through the Government of Canada before a start date can be confirmed (includes a background check with fingerprinting by the RCMP)

Good to have skills:

  • Experience with Tableau reporting system
  • Experience with PostgreSQL
  • Experience as AWS Glue design/ tech lead in various industries mostly in insurance and finance is preferred
  • Hands on experience with DevOps tools (Git, Jenkins, SourceTree, Ansible, etc.)
  • Experience in any object-oriented/object function scripting – Python etc.
  • Integration experience with various backend applications
  • Possess excellent Leadership, Analytical and Communication skills
  • Agile Trained
  • Any relevant AWS certification is preferred

Roles & Responsibilities:

  • Provide ongoing support and maintenance of AWS Glue ETL and related integration components, including on-call support on rotation basis, problem analysis, resolution and escalation
  • Participate in Requirement Analysis, Estimation, Solution & Design, and Development and Implementation of applications hosted on AWS
  • Contribute to defining timetables, project plans and product roadmaps
  • Configure and install software products, patches, vendor releases in multiple environments
  • Enhancements and support to the Glue, Lambda, ETL jobs
  • Apply analysis skills to understand and assess the impact of infrastructure and technical changes within the environment
  • Provide recommendations and alternatives for system enhancements
  • Take complete ownership of work assignments and ensure the successful completion of assigned tasks
  • Establish and maintain relationships with offshore and 3rd party team members, business partners, subject matter experts and software vendors
  • Create and maintain technical documentation for supported systems
  • Ensure Information Security Policies and GCC are compiled to in any solution
  • Maintain effective communication with management, team members and the business
  • Major focus on designing, developing solutions based out of AWS Glue and related services
  • Occasional weekend and after-hours work / On-call support as part of rotation
  • Occasional travel between Client locations may be required depending on work assignments