Int. ETL / BI Developer to create pipelines with InfoSphere DataStage and/or Cognos for our public sector client - 037-2024

Int. ETL / BI Developer to create pipelines with InfoSphere DataStage and/or Cognos for our public sector client - 037-2024

Duration: 11 months (till Mar 31, 2025) with extension for 9 months

Location: 1x/month in Downtown Toronto

Job Responsibilities:

• Work with technology and business teams to provide technical leadership in planning, analysis, building, configure, testing, and post implementation support data solutions with experience with enterprise ETL and data integration and reporting tooling such as IBM Infosphere Information Server DataStage and/or Cognos.
• Provide support for Enterprise Data Warehouse operations (e.g. daily data refreshes of mirror and warehouse components) to ensure the delivery of timely, accurate and reliable data to business users. This includes monitoring the update processes, updating/maintaining the appropriate system documentation, identifying potential problems and implementing solutions to ensure the efficiency and reliability of the IM operations.
• Maintain the ETL environments by monitoring their performance to ensure functionality, Integrity and security of the environments and compliance with information security and change management processes. Identify and troubleshoot problems as they arise which may involve interacting with other areas within for resolution
• Monitor and administer automated and manual data integration and ETL and reporting jobs to verify execution and measure performance
• Work with management to provide technical assistance, advice and guidance to IT staff and business clients in response to enquiries on the functionality of BI/ETL tools, and data in warehouse and related data marts to ensure efficient and uninterrupted IM services to the business users.
• Candidate should be conversant with Cloud ETL methodologies and job design with a sound knowledge and experience of integrating input/jobs from disparate systems and be able to maintain the client's standard of ETL best practices
• Worked on Data warehousing projects and involved in supporting data modelling activities as part of building the data warehouse in Azure. Strong understanding of data modeling (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts).

Must haves:

• 5+ Years of experience in designing, developing, testing and implementing Extract/Transform/load (ETL) data pipelines and reporting with InfoSphere DataStage and/or Cognos
• 4+ years’ experience in data modeling and working with common data warehouse models
• 4+ years’ experience doing analysis and developing with SQL (e.g. Oracle, MS SQL, DB2)
• Message Broker and or Event frameworks knowledge (e.g., Kafka, PubSub).
• Degree in computer science, math, engineering or equivalent work experience

Nice to haves:

• 2+ years’ development experience with Genesys Contact Manager with data integration and ETL experience with relevant application design, development and testing experience
• Knowledge of Python, IBM Message Broker