Senior Python ETL developer

6 months ago

Toronto, Canada Sun Life Full time

Job Description

:

Do you want to build and maintain mission critical data processing and transformation systems that will help run one of Canada’s biggest financial institutions? Do you enjoy being part of a tight-knit, empowered team? Do you have experience writing data manipulation code in a cloud using Python and/or Pyspark? If so, we’d like to hear from you

We are looking for an Extract, Transform, and Load (ETL) Developer with a strong technical background and cloud experience to join the Corporate Application Solutions (CAS) team.

This is an exciting opportunity to be part of the IT organization dedicated to excellent customer service through digital transformation, supporting continuous learning, career growth and diversity.

What will you do?

Provide ongoing support and maintenance of AWS Glue ETL and related integration components, including on-call support on a 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. Enhance and support the Glue, Lambda, and 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 overseas and 3rd party team members, business partners, subject matter experts and software vendors. Create and maintain technical documentation for supported systems. Ensure Sun Life Information Security Policies and GCC are adhered to in any solution. Maintain effective communication with management, team members and the business.

 What you need to succeed:

Bachelor’s degree in computer science, computer engineering, or equivalent experience. 5+ years of experience working with complex technical environments involving multiple IT platforms. We use Windows, Unix, Linux, Cloud, and ETL technologies. 3+ years of experience creating ETL jobs using cloud technologies (e.g., Glue, Data Bricks). Experience in creating Python scripts using data libraries. Skill with Spark, PySpark, or Scala. Experience with Relational SQL (Oracle, PostgreSQL, SQL Server) databases. Strong knowledge of SQL query language – able to perform all CRUD operations. Experience in any object-oriented/object function scripting language, such as Python. Experience with Windows/Linux/Unix scripting languages. Proficient with the ITIL framework and processes such as Change, Incident, Problem and Configuration Management.

Preferred Skills:

Experience with SFTP and TCP network protocols. Experience with integrating vendor packages into an established Production environment consisting of various technologies and platforms. Knowledge of Active Directory, Single Sign-On and Web Hosting concepts. Good understanding / hands-on experience 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. Hands-on experience with DevOps tools (e.g., Git, Jenkins, SourceTree, Ansible). Strong analytical and problem-solving skills with ability to analyze situations/problems systematically and deliver effective right-sized solutions in a timely manner. Strong organizational and planning skills. Excellent verbal and written communications skills. Experience with managing and coordinating team activities in a multi-site environment.

Nice to have:

Experience with ETL development tools (PowerCenter, Informatica and/or SSIS). Experience with PowerShell scripting. Experience with Job schedulers (Control-M). Experience with Tableau reporting system. Experience with PostgreSQL.

Notes/Unique requirements:

Occasional weekend and after-hours work. On-call support as part of a rotation. Occasional travel between Sun Life locations may be required depending on work assignments. 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).

  • Senior Python ETL Developer

    1 month ago

    Toronto, Ontario, Canada Sun Life Full time

    Job Title: Senior Python ETL DeveloperAre you a skilled Python developer looking to take your career to the next level? Do you have experience with data transformation and ETL processes? We are seeking a highly motivated and experienced Senior Python ETL Developer to join our team at Sun Life.Job Summary:We are looking for a talented developer to design,...

  • Senior Python Developer

    4 weeks ago

    Toronto, Canada First Derivative Full time

    We are seeking an experienced Senior Python Developer to join our team at First Derivative. As a key member of our Wholesale Lending business, you will be working on strategic and tactical projects using big data technologies such as Hive, Impala, and Amazon ECS.Responsibilities:Develop and maintain Python applications using advanced Python, Python-based...

  • Senior ETL Developer

    1 month ago

    Toronto, Ontario, Ontario, Canada Bevertec Full time

    Title: Senior ETL Developer(s)Duration: End of March 2025 (possible extension)The role is "Hybrid", working 7.25 hours per calendar dayMust haves:10 years of proven working experience in an ETL role; strong understanding of ETL principles, including data extraction, transformation, and loading processes; knowledge of common ETL design patterns. Understanding...

  • Senior ETL Developer

    4 weeks ago

    Old Toronto, Canada LanceSoft Full time

    ${lang_code} Job Title: Sr. ETL Developer${lang_code} We are seeking an experienced ETL developer to join our team at LanceSoft. As a key member of our data integration team, you will be responsible for designing, developing, and implementing complex data pipelines using Azure Data Factory, Azure Synapse Analytics, and other ETL tools.Responsibilities:Design...

  • Software Developer

    1 month ago

    Toronto, Canada Arthur Grand Technologies Inc Full time

    Job DescriptionArthur Grand Technologies is currently seeking a highly motivated and Skilled  Software Developer - ETL - Senior for one of our clients Position: Software Developer - ETL - Senior Location: 595 Bay Street, Toronto, Ontario (Onsite)Duration: Long Term Contract  Must Haves: 5+ years of proven working experience in an ETL role; strong...

  • Senior ETL Developer

    3 weeks ago

    Old Toronto, Canada Softline™ Technology Inc. Full time

    Data Warehouse SpecialistThis role is responsible for designing, developing, maintaining, and optimizing ETL (Extract, Transform, Load) processes in Databricks for data warehousing, data lakes, and analytics. The specialist will work closely with data architects and business teams to ensure the efficient transformation and movement of data to meet business...

  • Software Developer

    1 month ago

    Old Toronto, Canada Arthur Grand Technologies Inc. Full time

    Company DescriptionArthur Grand Technologies (www.arthurgrand.com) is in the business of providing staffing and technology consulting services. We have doubled our revenue year over year for the past 5 years. This speaks to the long-lasting relationship and customer satisfaction that we have built in this short span of time. Our company is managed by a team...

  • Senior Python Developer

    1 month ago

    Old Toronto, Canada Nexus Systems Group Inc. Full time

    Job Title: Senior Python Developer - Data Extraction SpecialistJob SummaryNexus Systems Group Inc. is seeking an experienced Senior Python Developer to join our team as a Data Extraction Specialist. The successful candidate will have a strong background in Python programming and experience with data extraction, transformation, and loading (ETL) functions....

  • Senior ETL Developer

    3 weeks ago

    Toronto, Ontario, Canada Scotiabank Full time

    About the RoleWe are seeking an experienced Senior ETL Developer to join our team at Scotiabank.The ideal candidate will have a strong background in developing strategies for Extraction, Transformation, and Loading (ETL) mechanisms, with experience in designing Server jobs using various types of stages. They should also be skilled in integrating multiple...

  • ETL Datastage Developer

    2 months ago

    Toronto, Canada Futran Tech Solutions Pvt. Ltd. Full time

    Datastage Developer Location Toronto, Canada Project Description: We are seeking an ETL Developer with BA experience to join our stimulating and dynamic team. The ideal candidate will have a deep understanding of ETL and compatible coding languages (SQL, Python, VBA, etc); as well as investment co

  • Software Developer

    1 month ago

    Old Toronto, Canada LanceSoft Full time

    Role: Software Developer - ETL - SeniorLocation: Toronto, ON (Hybrid)Duration: 6 Months with Possible ExtensionCriteria 1: Data Migration, ETL - 40 PointsDemonstrated experience with ETL development, data pipelines, workflow orchestration and data ingestion, transformation, and movement.Demonstrated experience in integrating various data sources and systems,...

  • Senior Data Engineer

    4 weeks ago

    Toronto, Ontario, Canada Sun Life Full time

    Job Summary: We are looking for a highly skilled Senior ETL Developer to join our team at Sun Life. As a key member of our Corporate Application Solutions (CAS) team, you will be responsible for designing, developing, and maintaining mission-critical data processing and transformation systems.About the Role: The ideal candidate will have a strong technical...

  • ​ Senior Python Developer

    3 months ago

    Toronto, ON, Canada First Derivative Full time

    Are you a technologist who has a hunger to dig deep and get involved in providing first-class solutions to real-world problems? First Derivative is a people-first company. We are powered by our ever-growing teams of specialist problem-solvers and process-evolvers. Our extensive capabilities offer agile solutions and exciting career opportunities – whether...

  • Senior Python Developer

    3 months ago

    Toronto, Canada First Derivative Full time

    Are you a technologist who has a hunger to dig deep and get involved in providing first-class solutions to real-world problems? First Derivative is a people-first company. We are powered by our ever-growing teams of specialist problem-solvers and process-evolvers. Our extensive capabilities offer agile solutions and exciting career opportunities – whether...

  • Senior Python Developer

    3 months ago

    Toronto, Canada First Derivative Full time

    Are you a technologist who has a hunger to dig deep and get involved in providing first-class solutions to real-world problems?First Derivative is a people-first company. We are powered by our ever-growing teams of specialist problem-solvers and process-evolvers. Our extensive capabilities offer agile solutions and exciting career opportunities – whether...

  • Senior Python Developer

    3 months ago

    Toronto, Canada First Derivative Full time

    Are you a technologist who has a hunger to dig deep and get involved in providing first-class solutions to real-world problems?First Derivative is a people-first company. We are powered by our ever-growing teams of specialist problem-solvers and process-evolvers. Our extensive capabilities offer agile solutions and exciting career opportunities – whether...

  • Senior ETL Developer Position

    1 month ago

    Toronto, Ontario, Canada Futran Tech Solutions Pvt. Ltd. Full time

    Role: Senior ETL Developer Location: Toronto, Canada (Candidate will be visiting the office 4 days per week)Job Overview: We are seeking an ETL Developer with BA experience to join our stimulating and dynamic team.About the Position: The ideal candidate will have 6+ years of capital markets experience and strong skills in data integration and ETL...

  • Data Analyst with Python and ETL

    6 months ago

    Toronto, Canada Scotiabank Full time

    Is this role right for you? Work within a cross functional Agile team to analyse and troubleshoot technical issues and production support tickets and deliver solutions for the same. Change request delivery – requirements gathering, design, implementation, and testing as part of new regulatory initiatives. Support of advanced issue triage and ad-hoc...

  • Senior ETL Developers

    4 weeks ago

    Toronto, Canada Wirehead Full time

    Client: GovernmentType: ContractRole: Software ETL Developers x 4Term: 5 Months + 1 year extensionPay Rate: $90.00Start date: 2-3 weeksLocation: Toronto / HybridReq ID: RQ08079Requirements: What you'll need Skills, Knowledge, Experience, and Qualifications:Mandatory Requirements5+ years of proven working experience in an ETL role; strong understanding of ETL...

  • ETL Developer

    3 weeks ago

    Toronto, Canada TEEMA Full time

    ETL Developer4+ months contract3 days onsite per week is required/Toronto LocationMust Haves:10 years using ETL tools such as Microsoft SSIS, stored procedures, T-SQL 2+ Delta Lake, Databricks and Azure Databricks pipelinesStrong knowledge of Delta Lake for data management and optimization.Familiarity with Databricks Workflows for scheduling and...