ETL Developer

Maarut Inc; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

A leading company in the technology sector is seeking an ETL Developer to design and implement data pipelines for a major modernization project in the contact center space. The successful candidate will bring substantial expertise in Azure technologies and have a strong understanding of ETL processes, working closely with both technical teams and business stakeholders to ensure seamless execution and delivery of data solutions.

Qualifications

• 3+ years of experience in ETL data pipelines with Azure.
• 4+ years in data modeling and SQL development.
• 5+ years working with DevOps tools and agile practices.

Responsibilities

• Design and develop ETL processes for Genesys Contact Center.
• Monitor and administer ETL jobs and data integrations.
• Assist clients with technical inquiries about BI/ETL tools.

Skills

ETL Development

Data Modeling

SQL

Azure Data Technologies

DevOps Practices

Agile Methodologies

Communication

Education

Degree in Computer Science

Tools

Azure Data Factory

Databricks

Azure Synapse

SQL Data Warehouse

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.
  

Requirements

Knowledge & Skills

MUST 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.