The Business Intelligence Specialist – ETL Developer role involves developing, maintaining, and optimizing data pipelines and ETL processes for data warehousing and analytics solutions. With over 7 years of experience required in ETL tools such as Microsoft SSIS and T-SQL, the role includes building and managing Azure Data Factory pipelines, wor
...
king with Azure Data Lake, and supporting both full and incremental data loads. Responsibilities also include developing ingestion frameworks, designing data models, writing design documentation, conducting testing, and contributing to knowledge transfer activities. Strong hands-on experience with Azure cloud services, SQL Server, Oracle, and data warehouse design methodologies are essential to ensure robust data integration and reporting capabilities.
Advantages
•Work with advanced data integration tools across cloud and on-premises environments.
•Gain hands-on experience with Azure Data Factory, SSIS, Databricks, and Oracle GoldenGate.
•Contribute to complex data migration, transformation, and warehousing projects.
•Collaborate with cross-functional teams including business analysts and developers.
•Opportunity to design and implement efficient ETL workflows and scalable data models.
•Involvement in end-to-end development, testing, deployment, and knowledge transfer processes.
Responsibilities
•Develop and maintain ETL pipelines using SSIS, T-SQL, and Azure Data Factory.
•Build and manage data flows from Oracle to Azure Data Lake using Databricks and Azure services.
•Analyze requirements, design data models, and create functional and detailed design documents.
•Develop incremental and full data load strategies for Data Warehouse and Data Mart.
•Review and enhance performance of ETL jobs, ensuring data consistency and optimization.
•Conduct unit tests, integrated testing, and support go-live deployment activities.
•Participate in data mapping, source-to-target documentation, and schema design using dimensional modeling techniques.
•Create release and production deployment documentation, support post-go-live operations.
•Share knowledge with team members and conduct formal knowledge transfer sessions.
Qualifications
•7+ years of experience with SQL Server, SSIS, stored procedures, and T-SQL development.
•2+ years of hands-on experience with Azure Data Lake, Azure Data Factory, and data warehousing.
•Experience with Oracle databases and tools like Oracle GoldenGate (nice to have).
•Familiarity with Python/PySpark, dimensional modeling, and slowly changing dimensions (SCD Types 1, 2, 3).
•Understanding of Kimball and Inmon data warehouse methodologies.
•Ability to design ERD, data lineage diagrams, and low-level ETL workflows.
•Strong grasp of data migration, transformation, performance tuning, and error handling techniques.
•Experience using Azure DevOps, Power Designer, Visual Studio, and SQL Server Management Studio.
•Skills in documentation, deployment, and knowledge transfer for system sustainability.
Summary
This position offers an excellent opportunity for an experienced ETL Developer to lead robust data integration efforts across on-premise and Azure environments. With a strong focus on ETL development, data modeling, and system performance optimization, the role supports large-scale data transformation initiatives while enabling reliable knowledge transfer and documentation practices.
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more
The Business Intelligence Specialist – ETL Developer role involves developing, maintaining, and optimizing data pipelines and ETL processes for data warehousing and analytics solutions. With over 7 years of experience required in ETL tools such as Microsoft SSIS and T-SQL, the role includes building and managing Azure Data Factory pipelines, working with Azure Data Lake, and supporting both full and incremental data loads. Responsibilities also include developing ingestion frameworks, designing data models, writing design documentation, conducting testing, and contributing to knowledge transfer activities. Strong hands-on experience with Azure cloud services, SQL Server, Oracle, and data warehouse design methodologies are essential to ensure robust data integration and reporting capabilities.
Advantages
•Work with advanced data integration tools across cloud and on-premises environments.
•Gain hands-on experience with Azure Data Factory, SSIS, Databricks, and Oracle GoldenGate.
•Contribute to complex data migration, transformation, and warehousing projects.
•Collaborate with cross-functional teams including business analysts and developers.
...
•Opportunity to design and implement efficient ETL workflows and scalable data models.
•Involvement in end-to-end development, testing, deployment, and knowledge transfer processes.
Responsibilities
•Develop and maintain ETL pipelines using SSIS, T-SQL, and Azure Data Factory.
•Build and manage data flows from Oracle to Azure Data Lake using Databricks and Azure services.
•Analyze requirements, design data models, and create functional and detailed design documents.
•Develop incremental and full data load strategies for Data Warehouse and Data Mart.
•Review and enhance performance of ETL jobs, ensuring data consistency and optimization.
•Conduct unit tests, integrated testing, and support go-live deployment activities.
•Participate in data mapping, source-to-target documentation, and schema design using dimensional modeling techniques.
•Create release and production deployment documentation, support post-go-live operations.
•Share knowledge with team members and conduct formal knowledge transfer sessions.
Qualifications
•7+ years of experience with SQL Server, SSIS, stored procedures, and T-SQL development.
•2+ years of hands-on experience with Azure Data Lake, Azure Data Factory, and data warehousing.
•Experience with Oracle databases and tools like Oracle GoldenGate (nice to have).
•Familiarity with Python/PySpark, dimensional modeling, and slowly changing dimensions (SCD Types 1, 2, 3).
•Understanding of Kimball and Inmon data warehouse methodologies.
•Ability to design ERD, data lineage diagrams, and low-level ETL workflows.
•Strong grasp of data migration, transformation, performance tuning, and error handling techniques.
•Experience using Azure DevOps, Power Designer, Visual Studio, and SQL Server Management Studio.
•Skills in documentation, deployment, and knowledge transfer for system sustainability.
Summary
This position offers an excellent opportunity for an experienced ETL Developer to lead robust data integration efforts across on-premise and Azure environments. With a strong focus on ETL development, data modeling, and system performance optimization, the role supports large-scale data transformation initiatives while enabling reliable knowledge transfer and documentation practices.
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more
