ETL Developer - Jobs in Toronto, Ontario, Canada, M4C

Job Description

Resource Profile

• This requirement is for a ETL Developer with proven experience designing, and developing complex large scale data pipelines to support reporting as part of data migration and conversion initiatives in a fast paced environment in support of the Genesys Contact Center modernization project.
• This candidate must be able to assess existing pipelines and reporting landscape built in InfoSphere DataStage, Cognos, and Oracle Exadata and facilitate the continuity of the capabilities utilizing the modernize data stack including but not limited to AWS MySql, Azure ADF, ADLS Gen 2, Synapse SQL, and Power BI by developing the necessary pipelines and data marts.

Resource Responsibilities

• Analyze and assess legacy data landscape and reporting solutions and capabilities and requirements for modernized Genesys Contact Center solution
• Design, develop, implement, and support through the full development lifecycle the creation of the data pipelines as per requirements to support the modernized solution working with the broader Genesys project team.
• Monitor and administer automated and manual data integration and ETL jobs to verify execution and measure performance.
• Work with management to provide technical assistance, advice and guidance to client 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.

RequirementsKnowledgeamp; SkillsMUST HAVE:

• 3+ years of experience in designing, developing, testing and implementing Extract/Transform/load (ETL) data pipelines with Azure data technologies such as Azure Data Factory, Databricks, Azure Synapse and/or SQL Data Warehouse
• 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, MySSQL)
• 5+ years’ experience working DevOps tools and practices
• 5+ years’ experience working with accepted methods, standards, techniques and best practices for development in agile/scrum practices
• Oral communication skills to work effectively with and discuss development approaches to clients/senior management and external stakeholders; written communications skills to document and communicate development specifications

NICE TO HAVE:

• Good knowledge of popular data standards and formats (e.g. JSON, XML, Proto, Parquet, Avro, ORC)
• Experience working with high volume data exchange and transaction processing systems Experience writing well documented unit tests and executing them
• Experience of reverse-engineering data mappings based on application-layer code highly desirable Ability to express complex technical concepts effectively, both verbally and in writing
• Strong understanding of SDLC and Agile Methodologies
• Degree in computer science, math, engineering or equivalent work experience Excellent Communication Skills
• Experience with contact center management solutions including Geneys or others.