Data Integration Specialist

Montreal

Il n'est plus possible de postuler
à cette offre d'emploi

Orion Innovation

As an Bilingual Intermediate Data Integration / ETL Developer, you will play a crucial role in designing and implementing data integration solutions.

You’ll collaborate with various stakeholders to analyze data sources, develop ETL processes, and ensure seamless data flow across our systems.

If you are proficient in Microsoft Azure, Snowflake, and DataBricks, and have a knack for data mapping and profiling, we want to hear from you!Key Responsibilities : Analyze Data Sources : Work with source systems teams to understand data requirements and produce detailed technical specifications.

Data Mapping and Profiling : Perform data mapping and profiling to ensure accurate data integration.ETL Development : Design and develop data integration logic to meet model targets, using best practices and design patterns recommended by solution vendors.

Testing and Debugging : Participate in the development of testing strategies and perform unit and integration tests on developed features.

Data Integration Flows : Create and manage data integration flows using Azure Data Factory (ADF), connecting to various sources and transforming data effectively.

Data Transformation : Transform and load data, creating view tables and objects in Snowflake according to technical specifications.

Code Management : Use Azure DevOps to manage code and deployments, ensuring smooth operationalization.Knowledge Transfer : Document processes and conduct knowledge transfer sessions to ensure team readiness.

Qualifications : Bilingual : French & English (Mandatory).Experience : 5+ years of experience in data integration, ETL development, or a related role.

Technical Expertise : Proficiency in Azure Data Factory, Microsoft Azure (GEN2, AADF, ML), Snowflake, DataBricks, SQL Server, MS-SQL, GitHub, and Power BIAnalytical Skills : Strong ability to analyze data sources and produce clear technical specifications.

Documentation : Skilled in creating comprehensive documentation and conducting knowledge transfer sessions.Certifications : Relevant certifications in Microsoft Azure or data integration technologies are a plus.

Education : Bachelor’s degree in Computer Science, Information Systems, or a related field.

17 hours ago