Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

ETL Informatica Developer

Full-time

CGI

Job Responsibility:

This role is hybrid and requires you to be in our downtown Toronto office (250 Yonge Street) 2-3 times per week - subject to change at any time.

Your future duties and responsibilities

Monitor Month End & Pre Month End Cycles in accordance with the business requirements Understand the relationship between data and business outcomes and can focus on long term strategies for data Participate in special projects and ad hoc analyses as necessary. Improve ETL performance for enterprise data warehouse system to shorten batch run completion time. Performance improvement from better table/index design and ETL code design. Maintain build and release plans for new functionality and enhancements. Establish and manage procedures for reviewing, estimating, and accepting development work requests on BAU Requests or Projects Must be able to identify any gaps in the business requirement and assist Business Analyst to rectify the gaps Introduce and enforce effective software development practices, coding standards and methodologies aimed at controlling costs and delivering quality solutions on a timely basis while building a strong well-motivated development team Support high level end-to-end architecture design from business requirement for ODS/Enterprise data warehouse type systems Maintain reconciliation procedure (between systems) to facilitate audit trail Use appropriate ETL tools (Informatica, PL/SQL, Unix shell scripting) to facilitate efficient data transformation Be proficient in the use of dynamic SQL when data transformation logic is table driven or via configuration file Improve ETL performance for ODS and enterprise data warehouse system to shorten batch run completion time. Performance improvement from better table/index design and ETL code design. Lead and champion the continuous development of the Systems Analysis function, promoting and enhancing the Systems Analysis tools/templates, techniques and approaches within the organization.
  • Work with subcontractors and Project Managers to ensure completion of agreed activities.
  • Remain abreast of relevant technology developments.
  • May act as the scrum master in a pod when working with Agile Methodology
  • Adhere to Agile and development best practices.
  • Perform analysis and defect and issue triage during project development.
  • Other duties as assigned

Required qualifications to be successful in this role

  • 5+ years experience as an ETL developer
  • Experience using Informatica
  • Experience using PL/SQL in ETL processes
  • Experience using Unix Shell scripting in ETL processes
  • Experience using Dynamic SQL in ETL processes
  • Experience using table driven transformation logic in ETL processes
Nice to have:
  • Insurance knowledge
  • Experience in ODS/Enterprise Data Warehouse systems

Together, as owners, let's turn meaningful insights into action. Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you'll reach your full potential because… You are invited to be an owner from day 1 as we work together to bring our Dream to life. That's why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company's strategy and direction. Your work creates value. You'll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise. You'll shape your career by joining a company built to grow and last. You'll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons. At CGI, we recognize the richness that diversity brings. We strive to create a work culture where all belong and collaborate with clients in building more inclusive communities. As an equal-opportunity employer, we want to empower all our members to succeed and grow. If you require an accommodation at any point during the recruitment process, please let us know. We will be happy to assist. Come join our team—one of the largest IT and business consulting services firms in the world.

Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the ETL Informatica Developer in Toronto, ON vacancy
  •  ...Position: ETL Developer Location: Onsite/Toronto Job ID#: RQ10127 Duration: 5 Months Overview The Senior ETL Developer is responsible for designing, developing, and maintaining database back-end and ETL applications for Data Warehouse and Business... 
    Suggested
    Full time

    Symbiotic Digital

    Toronto, ON
    more than 2 months ago
  •  ...Description: A highly skilled and experienced ETL Developer to design, develop, and maintain robust data integration solutions. The ideal candidate will have deep expertise in Informatica PowerCenter v10.2 and Informatica Intelligent Data Management Cloud (IDMC), PL... 
    Suggested
    Full time
    Flexible hours

    Maarut Inc

    Toronto, ON
    29 days ago
  •  ...Sr. IDMC Developer – Informatica, IICS, SQL & ETL Key Requirements & Responsibilities • 8–10 years of overall ETL development experience in large IT organizations. • Minimum 5 years of strong hands-on development experience with Informatica PowerCenter and at... 
    Suggested
    Permanent employment

    Astra North Infoteck Inc.

    Toronto, ON
    24 days ago
  •  ...Informatica Cloud Developer (IISC, IDMC) Location: Toronto, ON – Hybrid (2-4 Days WFO) Duration: 12 months Role: RBC Required Qualifications • Proven hands-on experience as an ETL Developer with a strong focus on Informatica Intelligent Cloud Services... 
    Suggested
    Full time

    Astra North Infoteck Inc.

    Toronto, ON
    26 days ago
  •  ...Job Title: ETL Developer – Data Warehouse & AWS Job Description: Role: ETL Lead Developer Location: Toronto; Hybrid 2 days a week onsite Role and Responsibilities: Resource has strong data warehouse technical knowledge. Resource have knowledge in Bank and... 
    Suggested
    Contract work
    2 days per week

    Astra North Infoteck Inc.

    Toronto, ON
    18 days ago
  •  ...companies. We’re looking for a Staff Software Engineer to join our ETL Platform team. We own the core platform that backs Census’...  ...it. Work closely with our product team to help design and develop new features to improve data pipeline observability and debuggability... 
    Full time
    Live In
    Work at office

    Fivetran

    Toronto, ON
    more than 2 months ago
  •  ...working tested applications. This includes developing detailed programming specifications...  ...track record for meeting deadlines ETL Skills: Knowledge and experience in...  ...transformation. Azure Roles ~ Experience with Informatica including: Workflow Manager... 
    Full time

    Maarut

    Toronto, ON
    more than 2 months ago
  • $86.9 - $104.28 per hour

     ...RQ11301 - Sr. Software Developer - ETL 9+ month contract (182 business days) - possible extension  ONSITE 5 days(182 business days...  ...data transformation. o Azure Roles ~ Experience with Informatica, including: o Workflow Manager o Repository... 
    Contract work

    Source Code

    Toronto, ON
    more than 2 months ago
  •  ...Hello , Hope you are doing good..!!! This is Paul (Prasanth) from Apptoza . We have an Immediate openings on Data Bricks/ETL Developer @ Toronto, ON Location. If you're interested in this position revert me back with updated resume and details Role : Data Bricks... 
    Long term contract
    Immediate start

    Atlantis IT group

    Toronto, ON
    9 days ago
  •  ...DataStage ETL Developer IBM InfoSphere & SQL Location: Toronto ON Work Model: Hybrid (4 Days WFO) Experience Required: 68 Years Required Skills IBM InfoSphere DataStage ETL Development SQL & PL/SQL Unix Shell Scripting Role Description... 
    Full time

    Astra North Infoteck Inc.

    Toronto, ON
    more than 2 months ago
  •  ...com   Please do not apply less than 8 years experience candidates and if not matching to the required criteria. Role: Full Stack Developer Location: Toronto, ON (Hybrid) Position type: Fulltime   Visa: Canadian Citizens or PR only   Years of experience... 
    Full time
    Work from home
    Worldwide

    ZAPCOM GROUP INC

    Toronto, ON
    9 days ago
  •  ...framework to enable continuous testing in a DevOps environment. Develop code to automate the testing (Unit/ Integration) of Datahub/Lake,...  ...strategies and frameworks for Data Platforms involving APIs, and ETL tools. Build and run automated functional, integration, stress... 
    Permanent employment
    Flexible hours

    Scotiabank

    Toronto, ON
    4 days ago
  • We are seeking an experienced Databricks developer with strong expertise in Azure Databricks, Apache Spark, and modern data engineering...  ...Databricks Development \\ \ Design, develop, and maintain scalable ETL/ELT pipelines using Databricks, Apache Spark, and SQL \ . \\... 
    Full time

    Kumaran Systems

    Toronto, ON
    more than 2 months ago
  • $145k - $170k per year

     ...foundation that supports decision-making across the company. The team develops data products that support product development, regulatory...  ...datasets. As an Analytics Engineer, you will design and build ETL pipelines, data models, and analytics tools that support key business... 
    Full time
    Work at office
    Flexible hours
    Shift work
    3 days per week

    Robinhood

    Toronto, ON
    more than 2 months ago
  •  ...Position: SharePoint Developer Location: Toronto, ON Job ID#: RQ10572  Duration: 10 Months Role Overview This role...  ...data pipelines through extraction, transformation, and loading (ETL) activities. Translate technical system specifications into working... 
    Full time

    Symbiotic Digital

    Toronto, ON
    more than 2 months ago
  • $59.09 - $63.31 per hour

     ...RQ11532 - Software Developer - Junior Location :222 Jarvis Street Toronto (5 days ONSITE) Duration: 9 months Contract (283 Business...  ...tables Demonstrated experience and understanding of data warehouse ETL methodologies and OBIEE Demonstrated work experience on Java... 
    Full time
    Contract work
    Manual labor

    Source Code

    Toronto, ON
    5 days ago
  •  ...Ivalua Configurator – Ivalua Configuration, SQL & ETL Position: Ivalua Configurator Job Summary: The Ivalua Configurator...  ...and translate them into technical specifications. • Develop and maintain configuration documentation, test scripts. • Provide... 
    Permanent employment
    Remote work

    Astra North Infoteck Inc.

    Toronto, ON
    26 days ago
  •  ...Position: Senior .NET Developer Location: Toronto, ON Job ID#: RQ11090  ​ Duration: 8 Months Role Overview...  ...Responsibilities Design, implement, and expand data pipelines, including ETL (extract, transform, load) processes Translate technical... 
    Full time

    Symbiotic Digital

    Toronto, ON
    more than 2 months ago
  • $100k - $130k per year

     ...multiple hats in a fast-growing fintech environment. The Database Application Developer designs, develops, tests, deploys, and supports database code powering Propel’s financial data applications, ETL processes, and reporting solutions. The role converts business requirements... 
    Full time
    Internship

    Propel Holdings Career

    Toronto, ON
    28 days ago
  • $65k - $115k per year

     ...looking for a skilled QA Engineer with experience in data validation ETL testing API testing and cloud-based data platforms. The...  ...at any time. Your future duties and responsibilities: Design develop and execute automated testing solutions for ETL processes and APIs... 
    Full time
    Manual labor
    Work at office

    CGI

    Toronto, ON
    2 days ago
  •  ...position?   We are seeking an experienced  Senior Salesforce Developer to lead the design, development, and optimization of our Salesforce...  ...external applications using  REST/SOAP APIs , middleware, and ETL tools. Ensure platform integrity, data quality, and performance... 
    Full time
    Work at office
    Work from home
    Flexible hours

    Hard Rock Digital Llc

    Toronto, ON
    more than 2 months ago
  • $80k - $90k per year

     ...Position: Power BI Developer Position reports to: Director of IT Position Overview: Greenstone Meats is seeking a Power BI Developer...  ...~ Strong SQL skills and understanding of data warehousing and ETL principles. ~ Experience with modern Dynamics 365 F&O data... 
    Long term contract
    Full time

    Greenstone Meats

    Toronto, ON
    a month ago
  • $118k - $152k per year

     ...enterprise-scale data transformation by delivering high-performance ETL solutions for a major financial services platform migration....  ...We are seeking an experienced Senior IBM InfoSphere DataStage Developer to join a large-scale credit card platform migration programme from... 
    Permanent employment
    Full time
    For contractors
    Internship
    Immediate start

    Capco

    Toronto, ON
    more than 2 months ago
  •  ...Technical Support Specialist Informatica IDMC MDM & Data Catalog Location: Toronto ON Hybrid: 3 days in office Skills: Master Data ManagementInformatica (MDM) Experience Required: 6-8 Years Must Have 5 years of experience with Informatica platforms... 
    Full time
    Work at office

    Astra North Infoteck Inc.

    Toronto, ON
    26 days ago
  •  ...Position: Senior Dynamics 365 Developer Location: Toronto, ON (Onsite) Job ID#: RQ11188  Duration: 3 Months   Role...  ...APIs, data visualization, and reporting tools. Experience with ETL processes and data integration. Strong analytical and troubleshooting... 
    Full time

    Symbiotic Digital

    Toronto, ON
    more than 2 months ago
  • $68.55 - $82.26 per hour

     ...RQ00745 -Requisition TitleData Science Developer Location: Toronto (661 University Ave, Suite 1701, Toronto, ON M5G 1M1) Duration:...  ...for analytic products and advanced analyses, including ingestion, ETL, and production for the foundational capability and for HealthMap... 
    Full time

    Source Code

    Toronto, ON
    a month ago
  •  ...Opinionated about clean, maintainable code but flexible when shipping fast matters. Bonus points Familiarity with data warehousing, ETL, or analytics pipeline concepts. Experience in frontend performance optimization and responsive UI design. Understanding of AI-... 
    Full time
    Flexible hours

    Reflow

    Toronto, ON
    more than 2 months ago
  • $88.54 - $106.25 per hour

     ...RQ11342 - Software Developer - Senior 5+ Months Contract (120 Business Days) - possible extension 5 Days ONSITE - 222 Jarvis Street...  ...Demonstrated experience and understanding of data warehouse, ETL methodologies and OBIEE Demonstrated work experience on Java and... 
    Full time
    Contract work
    Manual labor

    Source Code

    Toronto, ON
    a month ago
  • $88.86 - $106.63 per hour

     ...RQ11293 - Software Developer - Senior Duration: 7 months (144 days) + possible extension CRJMC clearance Location: 222 Jarvis...  ...experience with data querying (SQL), data integration (ETL/ELT), and supporting analytics/reporting solutions in an enterprise... 
    Full time
    Contract work
    Work at office
    Monday to friday

    Source Code

    Toronto, ON
    a month ago
  • $90.3k - $112.9k per year

     ...work makes a real impact. The Opportunity ​​ The Senior Developer plays a vital role in Atlantic's Technical Services Group,...  ...results To define and design new systems by analyzing current ETL processes. Make essential technical and strategic changes to improve... 
    Full time
    Work at office
    Local area
    Shift work

    Atlantic Packaging Products

    Toronto, ON
    more than 2 months ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to ETL Informatica Developer. Be the first to apply!