Talent.com
Senior Software Developer - ETL
Senior Software Developer - ETLRandstad Canada • Toronto, Ontario, CA
Senior Software Developer - ETL

Senior Software Developer - ETL

Randstad Canada • Toronto, Ontario, CA
Il y a 2 jours
Type de contrat
  • Temporaire
  • Quick Apply
Description de poste

Do you have 10 + years of experience developing and performance tuning SQL, T-SQL, PL / SQL and advanced SQL query optimization? Do you have 2+ years of experience with Informatica Cloud (IDMC) including PC to IDMC migration; asset management; and configuration of secure agents, schedules, orgs and sub-Orgs, connections, users and roles? If so, this would be a great opportunity for you!

Our client is looking for a Senior Software Developer - ETL for a 1 month contract in Toronto.

This is a hybrid role.

Rate : Advantages

  • Earn a competitive rate within the industry.
  • Location : work in office 3 to 5 days per week.
  • Potential for extension

Responsibilities

  • Contribute to and support design, development, and maintenance of ETL processes using Informatica Cloud (IDMC).
  • Migrate Informatica PowerCentre v10.2 ETL code including embedded SQL and PL / SQL code developed using Oracle 11g and 19c
  • Test migrated embedded SQL code and PL / SQL based Stored Procedures.
  • Performance-tune and optimize SQL queries and PL / SQL code for performance and scalability.
  • Conduct root cause analysis and resolve ETL issues, including performance tuning and recovery to achieve optimum baseline-based performance
  • Perform data extraction, transformation, and loading (ETL) from various sources into data warehouses (star / snowflake schemas).
  • Translate technical specifications into fully tested applications and data pipelines.
  • Collaborate with vendor and entire project team for unit testing, debugging, and validation of ETL processes.
  • Document technical designs, deployment guides, and support materials.
  • Participate in Agile / Scrum development cycles and iterative delivery.
  • Ensure compliance with data governance, security, and access control policies.
  • Provide post-implementation support and participate in knowledge transfer sessions.
  • Provide database administration including configuration, backup / recovery, user roles, database
  • Qualifications

    Must haves :

  • 10+ years of experience as a BI / ETL Developer.
  • 10 + years of experience developing and performance tuning SQL, T-SQL, PL / SQL and advanced SQL query optimization.
  • 10+ years experience with Oracle tools : EXPLAIN PLAN, TKPROF, OEM, RMAN, etc.
  • 5+ years Experience with relational database including Oracle including Oracle 11g and 19c.
  • 3+ years of hands-on experience with Informatica PowerCenter v10.2 administration
  • 2+ years of experience with Informatica Cloud (IDMC) including PC to IDMC migration; asset management; and configuration of secure agents, schedules, orgs and sub-Orgs, connections, users and roles
  • Hands-on Oracle 11g and 19c experience configuring, user roles setup, RMAN, data dumps, and Golden Gate synchronization
  • Proficiency in data modeling (OLTP, OLAP, dimensional modeling).
  • Experience with REST / SOAP APIs, system integration, and cloud platforms (Azure, AWS, GCP).
  • Experience with data replication, data cleansing, and data quality assurance.
  • Excellent analytical, problem-solving, and communication skills.
  • Desirable Skills :

  • Strong understanding of Agile, SDLC, and DevOps practices.
  • Experience with Azure DevOps and version control systems.
  • Familiarity with OPS (Ontario Service) methodologies and enterprise architecture.
  • Experience in public sector projects, especially in environmental or inter-jurisdictional data systems.
  • Understanding of Information Management principles and data governance.
  • Summary

    If you are interested in the Senior Software Developer - ETL role in Toronto, please apply online at www.randstad.ca. Qualified candidates will be contacted.

    Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary / gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

    Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.

    Créer une alerte emploi pour cette recherche

    Senior Software Developer ETL • Toronto, Ontario, CA

    Offres similaires
    Senior ETL Engineer

    Senior ETL Engineer

    DeFi Planet • Toronto
    Temps plein
    Senior ETL EngineerScotiabankTorontoRequisition ID : 238183 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Team • • • We are the CRM, Sales...Voir plus
    Dernière mise à jour : il y a 24 jours • Offre sponsorisée
    ETL Developer

    ETL Developer

    Fidelity International • Toronto
    Temps plein
    Job Description • • • •You will be working on a 100% remote schedule as part of Fidelity’s dynamic working arrangement.Current work authorization for Canada is required for all openings.At Fidelity, we...Voir plus
    Dernière mise à jour : il y a 24 jours • Offre sponsorisée
    Senior Developer, IFRS 17

    Senior Developer, IFRS 17

    Munich Re • Toronto
    Temps plein
    As a Senior SQL ETL Developer, you will be responsible for building and maintaining robust data integration and transformation solutions that support financial and regulatory reporting, including I...Voir plus
    Dernière mise à jour : il y a 24 jours • Offre sponsorisée
    Senior ETL Engineer : D365 & Azure Data Integration

    Senior ETL Engineer : D365 & Azure Data Integration

    Randstad Canada • Toronto
    Temps plein +1
    Randstad Canada is seeking a Senior Software Developer ETL in Toronto for an 8-month contract.The ideal candidate will have at least 8 years of experience in ETL development and enterprise-level da...Voir plus
    Dernière mise à jour : il y a 14 heures • Offre sponsorisée • Nouvelle offre
    Senior ETL Developer

    Senior ETL Developer

    Encore Technical Solutions Inc. • Markham
    Temps plein
    A degree in Computer Science, Software Engineering, or comparable professional experience.CDC techniques, and crafting / optimizing SQL queries. MS SSIS / SSDT and Pitney Bowes migration utilities.Famil...Voir plus
    Dernière mise à jour : il y a 14 jours • Offre sponsorisée
    Senior Software Developer

    Senior Software Developer

    CI Financial Corp. • Toronto, ON, CA
    Temps plein
    At CI, we see a great place to work as one that is a safe place for everyone to have a voice, where people are empowered to take ownership over meaningful work, where there is an opportunity to gro...Voir plus
    Dernière mise à jour : il y a plus de 30 jours
    Senior ETL Engineer

    Senior ETL Engineer

    Swagher • Toronto
    Temps plein
    Senior ETL EngineerScotiabankTorontoRequisition ID : 238183 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Team • • • We are the CRM, Sales...Voir plus
    Dernière mise à jour : il y a 24 jours • Offre sponsorisée
    Senior Consultant- ETL Dev

    Senior Consultant- ETL Dev

    Virtusa • Toronto
    Temps plein
    Senior Consultant- ETL Dev - ( CREQ125383 ).Job Description for ETL Application Developer.Accountable for the design, development, testing and support of applications utilized in Lines of Business ...Voir plus
    Dernière mise à jour : il y a 24 jours • Offre sponsorisée
    Sr ETL Developer

    Sr ETL Developer

    Bevertec • Toronto
    Temps plein
    Designing and developing scalable Medallion Data Lakehouse architectures.Expertise in data ingestion, transformation, and curation using Delta Lake and Databricks. Experience integrating structured ...Voir plus
    Dernière mise à jour : il y a 20 jours • Offre sponsorisée
    Senior Software Reliability Developer

    Senior Software Reliability Developer

    Autodesk • Toronto
    Temps plein
    Autodesk is looking for a passionate and experienced Senior Software Reliability Developer to join our Autodesk Platform Services (APS) – Foundational Services team. In this role, you will help ensu...Voir plus
    Dernière mise à jour : il y a 14 jours • Offre sponsorisée
    Senior Software Reliability Developer

    Senior Software Reliability Developer

    Autodesk, Inc. • Toronto
    Temps plein
    Job Requisition ID # • •26WD94650 • •Position Overview • •Autodesk is looking for a passionate and experienced Senior Software Reliability Developer to join our Autodesk Platform Services (APS) – Foundat...Voir plus
    Dernière mise à jour : il y a 14 jours • Offre sponsorisée
    Senior Software Developer

    Senior Software Developer

    Ecruit • Toronto, Ontario, Canada
    Temps plein
    Quick Apply
    Senior Software Developer – Competitive Salary – Canada (Remote).Ready to shape the future of airline tech from anywhere in Canada? Want to take ownership of systems used every day by r...Voir plus
    Dernière mise à jour : il y a 17 jours
    Senior ETL Engineer

    Senior ETL Engineer

    Women Thrive Magazine • Toronto
    Temps plein
    Senior ETL EngineerScotiabankTorontoRequisition ID : 238183 Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. The Team • • • We are the CRM, Sales...Voir plus
    Dernière mise à jour : il y a 24 jours • Offre sponsorisée
    ETL Developer

    ETL Developer

    Tata Consultancy Services • Toronto
    Temps plein
    Tata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to c...Voir plus
    Dernière mise à jour : il y a 5 jours • Offre sponsorisée
    Senior Data Solutions Lead - SQL, ETL & Azure

    Senior Data Solutions Lead - SQL, ETL & Azure

    TD Bank • Toronto
    Temps plein
    A leading financial institution is seeking a Senior Data Management Lead in Toronto.This role requires providing technical leadership across diverse data analysis functions, including SQL, ETL, and...Voir plus
    Dernière mise à jour : il y a 5 jours • Offre sponsorisée
    Ab Initio ETL Developer

    Ab Initio ETL Developer

    Adastra Corporation • Markham
    Temps plein
    Join our team at Adastra as a Senior Ab Initio ETL Developer and be at the forefront of enterprise data solutions.In this role, you will lead ETL development, provide expert guidance, and collabora...Voir plus
    Dernière mise à jour : il y a 24 jours • Offre sponsorisée
    ETL Developer

    ETL Developer

    Compunnel, Inc. • Toronto
    Temps plein
    We are seeking a skilled ETL Developer to support our data integration and transformation initiatives.The ideal candidate will have hands-on experience in ETL / ELT development, data warehousing, and...Voir plus
    Dernière mise à jour : il y a 24 jours • Offre sponsorisée
    RQ10584 - Software Developer - ETL - Senior

    RQ10584 - Software Developer - ETL - Senior

    Maarut • Toronto, ON, ca
    Temps plein
    Quick Apply
    Contribute to and support design, development, and maintenance of ETL processes using Informatica Cloud (.Migrate Informatica PowerCentre v10. ETL code including embedded SQL and PL / SQL code develop...Voir plus
    Dernière mise à jour : il y a 2 jours