The Business Intelligence Specialist (ETL Developer) is responsible for designing, developing, and implementing robust data ingestion pipelines from Oracle sources to Azure Data Lake and Databricks environments. This role involves hands-on development using tools like Azure Data Factory, SSIS, SQL Server, and Python/PySpark to transform raw data
...
into curated and analytical layers following Delta Lake architecture. The specialist will also contribute to optimizing performance, conducting unit testing, creating detailed design documentation, and ensuring successful deployment into production. This role supports both initial and incremental data loads with a strong focus on data quality, performance, and scalability.
Advantages
•Work with modern cloud-based platforms including Azure Data Lake, Databricks, and Azure Data Factory
•Contribute to enterprise-level data warehouse modernization and transformation initiatives
•Exposure to advanced ETL practices, including GoldenGate-based Change Data Capture (CDC)
•Participate in full lifecycle development, from design through deployment and support
•Collaborative and cross-functional environment involving developers, analysts, and DevOps
•Opportunity to optimize existing systems and contribute to long-term data strategy
Responsibilities
•Design and build ETL pipelines from Oracle sources to Azure Data Lake using Databricks and ADF
•Implement initial and incremental load mechanisms using CDC and Oracle GoldenGate
•Transform data through Delta Lake zones (bronze, silver, gold) using PySpark
•Review source data models and recommend optimal transformations and schema designs
•Prepare design artifacts, process diagrams, STTM documents, and physical schema scripts
•Develop and deploy Databricks notebooks and packages for scheduled data loads
•Conduct unit testing, validate data quality, and resolve performance or load issues
•Create production deployment plans, execute go-live activities, and provide post-deployment support
•Perform dimensional modeling and data mart schema design (star/snowflake)
•Facilitate knowledge transfer sessions and develop supporting documentation for ongoing maintenance
Qualifications
•7+ years in Data Warehousing and ETL development
•3+ years in Azure Data Lake, Data Factory, Databricks, Python, and PySpark
•Proficiency with SQL Server, SSIS, T-SQL, and Oracle PL/SQL
•Experience with GoldenGate CDC and Delta Lake architecture
•Familiarity with dimensional modeling and tools like PowerDesigner
•Experience with DevOps pipelines, Agile methodologies, and cloud deployment
•Strong documentation and knowledge transfer capabilities, including training delivery
•Expertise in performance tuning, ETL optimization, and troubleshooting
Summary
This role is ideal for experienced ETL developers who thrive in modern data environments and want to play a key role in building and optimizing Azure-based data pipelines. With hands-on involvement in development, design, and deployment, this opportunity offers both technical depth and strategic impact across enterprise data initiatives.
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) is responsible for designing, developing, and implementing robust data ingestion pipelines from Oracle sources to Azure Data Lake and Databricks environments. This role involves hands-on development using tools like Azure Data Factory, SSIS, SQL Server, and Python/PySpark to transform raw data into curated and analytical layers following Delta Lake architecture. The specialist will also contribute to optimizing performance, conducting unit testing, creating detailed design documentation, and ensuring successful deployment into production. This role supports both initial and incremental data loads with a strong focus on data quality, performance, and scalability.
Advantages
•Work with modern cloud-based platforms including Azure Data Lake, Databricks, and Azure Data Factory
•Contribute to enterprise-level data warehouse modernization and transformation initiatives
•Exposure to advanced ETL practices, including GoldenGate-based Change Data Capture (CDC)
•Participate in full lifecycle development, from design through deployment and support
•Collaborative and cross-functional environment involving developers, analysts, and DevOps
...
•Opportunity to optimize existing systems and contribute to long-term data strategy
Responsibilities
•Design and build ETL pipelines from Oracle sources to Azure Data Lake using Databricks and ADF
•Implement initial and incremental load mechanisms using CDC and Oracle GoldenGate
•Transform data through Delta Lake zones (bronze, silver, gold) using PySpark
•Review source data models and recommend optimal transformations and schema designs
•Prepare design artifacts, process diagrams, STTM documents, and physical schema scripts
•Develop and deploy Databricks notebooks and packages for scheduled data loads
•Conduct unit testing, validate data quality, and resolve performance or load issues
•Create production deployment plans, execute go-live activities, and provide post-deployment support
•Perform dimensional modeling and data mart schema design (star/snowflake)
•Facilitate knowledge transfer sessions and develop supporting documentation for ongoing maintenance
Qualifications
•7+ years in Data Warehousing and ETL development
•3+ years in Azure Data Lake, Data Factory, Databricks, Python, and PySpark
•Proficiency with SQL Server, SSIS, T-SQL, and Oracle PL/SQL
•Experience with GoldenGate CDC and Delta Lake architecture
•Familiarity with dimensional modeling and tools like PowerDesigner
•Experience with DevOps pipelines, Agile methodologies, and cloud deployment
•Strong documentation and knowledge transfer capabilities, including training delivery
•Expertise in performance tuning, ETL optimization, and troubleshooting
Summary
This role is ideal for experienced ETL developers who thrive in modern data environments and want to play a key role in building and optimizing Azure-based data pipelines. With hands-on involvement in development, design, and deployment, this opportunity offers both technical depth and strategic impact across enterprise data initiatives.
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
