ETL Informatica Developer

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.