Senior Python ETL developer

2 weeks ago

Toronto, Ontario, 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).

  • Python Developer

    2 weeks ago

    Old Toronto, Ontario, Canada Dive Into Python Full time

    We are looking for a skilled Python Engineer to join our team. As a Python Engineer, you will be responsible for designing, developing, and maintaining Python-based applications and systems. You will work closely with cross-functional teams to deliver high-quality software solutions that meet our clients' needs.ResponsibilitiesDesign and develop scalable,...

  • Data Engineer-SQL, Python, ETL- Canada

    2 weeks ago

    Old Toronto, Ontario, Canada Zortechsolutions Full time

    Role: Data Engineer-SQL, Python, ETLLocation: Remote/CANADADuration: 6+ MonthsJob DescriptionKey Skills required:We are looking for Senior Data Engineering Candidates based out of the US/Canada. Expertise in SQL, Python and ETL flows is a must have. Medium expertise/working knowledge in Scala is also needed, as our data pipelines are written in both Scala...

  • ETL Developer

    2 days ago

    Toronto, Ontario, Canada Atlantis IT group Full time

    Role : ETL Developer ( AWS )Location : Toronto , ONDuration : ContractJob Description :1. Must have working knowledge in designing and implementing data pipelines on any of the cloud providers (AWS is preferred). Must be able to work with large volumes of data coming from various sources. Perform data cleansing, data validation etc.2. Hands on ETL developer...

  • ETL Developer with AWS

    6 days ago

    Toronto, Ontario, Canada Atlantis IT group Full time

    Role name: ETL Developer With AWS Toronto, ON Role Description: Cloud DEJob Description1. Must have working knowledge in designing and implementing data pipelines on any of the cloud providers (AWS is preferred). Must be able to work with large volumes of data coming from various sources. Perform data cleansing, data validation etc.2. Hands on ETL developer...

  • SQL Developer with ETL

    4 weeks ago

    Toronto, Ontario, Canada Atlantis IT group Full time

    Role Description: Undergraduate Degree or Technical Certificate. A minimum of 5 years experience with large SQL data marts. Expert relational database experience, Canditate should demonstrat ability to navigate through massive volumes of data to deliver effective and efficient data extraction, design, load, and reporting solutions to business partners,Strong...

  • SQL Developer with ETL

    2 months ago

    Toronto, Ontario, Canada Atlantis IT group Full time

    Role Description: Undergraduate Degree or Technical Certificate. A minimum of 5 years experience with large SQL data marts. Expert relational database experience, Canditate should demonstrat ability to navigate through massive volumes of data to deliver effective and efficient data extraction, design, load, and reporting solutions to business partners,Strong...

  • Python Developer

    2 weeks ago

    Toronto, Ontario, Canada CSC GENERATION Full time

    CSC Generation Holdings family of brands is an Altos Ventures backed technology company that is saving retail by acquiring store and catalog-based retailers, and transforming them into high performing, "digital first" brands. In just seven years, we've acquired and turned around brands including: Sur La Table, Direct Buy, One Kings Lane, Touch of Modern,...

  • Senior Python Developer

    2 weeks ago

    Toronto, Ontario, Canada Cognizant Full time

    Senior Python Developer At Cognizant, our global community sets us apart—an energetic, collaborative and inclusive workplace where everyone can thrive. And with projects at the forefront of innovation, you can build a varied, rewarding career and draw inspiration from dedicated colleagues and leaders. Cognizant is right where you belong. Role overviewWhat...

  • Senior Python Developer

    4 weeks ago

    Toronto, Ontario, Canada Cognizant Full time

    Senior Python Developer At Cognizant, our global community sets us apart—an energetic, collaborative and inclusive workplace where everyone can thrive. And with projects at the forefront of innovation, you can build a varied, rewarding career and draw inspiration from dedicated colleagues and leaders. Cognizant is right where you belong. Role overviewWhat...

  • Python developer

    2 weeks ago

    Toronto, Ontario, Canada Iris Software Inc. Full time

    Iris's direct client, one of the leading Banking and Financial Company, is looking to hire a Python Developer Job Title:Python Developer Should be good with Python and SQL Senior software developer with 5+ years of experience, Proficient in Python programming. Proficient in Unix/Linux operating system. Knowledge of SQL/Sybase database. Iris Software...

  • Senior Python Developer

    2 weeks ago

    Toronto, Ontario, Canada Pyramid Consulting, Inc Full time

    Immediate need for a talented Senior Python Developer. This is a months Contract opportunity with long-term potential and is located in Toronto, ON (Remote). Please review the job description below and contact me ASAP if you are interested.Job ID:Pay Range: CAD 50/hr- CAD 55/hour. Employee benefits include, but are not limited to, health insurance (medical,...

  • Python Developer

    2 weeks ago

    Toronto, Ontario, Canada Prodigy Labs Full time

    As a Software Developer working on the currency project, you will be concentrating on migrating on prem applications to cloud. Responsibility of this position includes the following: Effective and clean code development based on requirements Perform unit testing & integration testing Optimize current ETL code Assist support team on debugging production...

  • Python Developer

    2 weeks ago

    Toronto, Ontario, Canada Iris Software Inc. Full time

    Hi, Hope you are doing well Iris's Direct client, the largest bank in the Canada is looking to hire Python Developer Please find below the job details and share your resume if interested at Job Title:Python Developer Location: Toronto, ON (Hybrid)Key Responsibilities: Senior software de

  • Senior Data Engineer

    2 weeks ago

    Toronto, Ontario, Canada Intelliswift Software Inc Full time

    Corporate Job Senior Data Engineer Experienc: 7.0 to 9.0 Years Location: Any Location Job Description: Senior Data Engineer Position Overview We are seeking a talented and experienced Senior Data Engineer to join our dynamic team. The ideal candidate will have a strong background in Python development, extensive experience with Azure...

  • Etl QA

    2 weeks ago

    Toronto, Ontario, Canada Amaze systems Full time

    Detailed Job DescriptionETL QATORONTOStrong experience in ETL testingStrong experience in SQLWork experience in any of the automation tools like selenium, python, robot framework, java is added advantageCapital Markets and Data testing DomainStrong communicationExperience of Data mapping, validation across systemsQA test planning, scripting and QA process...

  • Senior Full Stack Developer

    2 weeks ago

    Toronto, Ontario, Canada First Derivative Full time

    Who are we?First Derivatives (FD) is a leading software and services company, with world-leading intellectual property in ultra-high-performance analytics (KX) across industries, and extensive domain expertise and capabilities in capital markets systems and technology (managed services and consulting).Senior Full Stack Developer - Python/ReactRequired...

  • Python Developer

    2 weeks ago

    Toronto, Ontario, Canada Raise Full time

    Python DeveloperLocation: Toronto, ON- Hybrid – (3 days per week in the office)Contract Length: 7 Months with possibility of extension.We at Raise are hiring a Python Developer for one of our top clients. After establishing themselves as an industry leader, they're now expanding their team to meet rising demand.We're hiring right now; if you're interested,...

  • Hiring for Etl Tester

    2 weeks ago

    Toronto, Ontario, Canada Kumaran Systems Pvt Ltd Full time

    QA ETL TESTER, with our Banking Client in Toronto, Contract 6 months with possible extension. 5 + years of work experience, ETL Tester/Automation. Good understanding of SDLC & STLC, Agile (Scrum) models. Strong experience in PL/SQL and UNIX shell scripting to perform ETL data warehousing testing.DATABASES: Oracle and Big Data ( Hadoop, Netezza) Test tools:...

  • ETL Developer

    1 month ago

    Toronto, Ontario, Ontario, Canada Atlantis IT Group Full time

    Role name: Data Bricks/ETL DeveloperRole Description: ? Designing and implementing efficient data ingestion pipelines from multiple sources using Azure Data factory and/or Azure Databricks? Integrating the end-to-end data pipeline to take data from different source systems to target data repositories ensuring the quality and consistency of data.? Processing...

  • ETL Developer

    4 weeks ago

    Toronto, Ontario, Ontario, Canada Atlantis IT Group Full time

    Role name: Data Bricks/ETL DeveloperRole Description: ? Designing and implementing efficient data ingestion pipelines from multiple sources using Azure Data factory and/or Azure Databricks? Integrating the end-to-end data pipeline to take data from different source systems to target data repositories ensuring the quality and consistency of data.? Processing...