We are looking for ETL Software Developers with expertise in Azure Data Factory, Informatica PowerCenter, and Oracle PL/SQL. The role involves designing data pipelines, developing ETL solutions, integrating data sources, and optimizing data transformation to ensure high-quality data processing and performance.
Advantages
...
•Hands-on ETL Development – Work with Azure Data Factory, Informatica, and SQL to create and optimize data pipelines.
•Cloud Technologies Exposure – Gain experience in Azure DevOps, CI/CD pipelines, and cloud-based data transformations.
•Diverse Data Integration – Integrate large datasets from multiple source systems and work with complex data transformations.
•Performance Optimization – Work with Azure SQL, Synapse, and Oracle PL/SQL to enhance data processing efficiency.
•Collaboration & Knowledge Sharing – Engage with IT professionals, business analysts, and stakeholders to refine data strategies.
Responsibilities
•Gather requirements and analyze business processes to design effective data transformations.
•Develop and implement Azure Data Factory pipelines for ETL processing.
•Create structured JSON files using ADF and SQL.
•Implement Logic Apps and Function Apps for data integration.
•Design and optimize Oracle PL/SQL stored procedures.
•Manage and troubleshoot Informatica PowerCenter workflows.
•Perform data conversion processes, including binary-to-character and EBCDIC-to-UTF.
•Develop complex data transformations for calculated values and derived data.
•Optimize data load performance and ensure smooth incremental and batch data processing.
•Implement CI/CD pipelines using Azure DevOps.
•Configure Azure Resource Management, GitHub Repo, and source control management.
•Work with Azure Boards, Azure Test Plans, Azure Pipelines, Azure Repos, and Azure Artifacts.
•Develop and maintain database models in Sybase Power Designer.
•Monitor ETL pipeline performance, troubleshoot incidents, and resolve data processing issues.
•Optimize Azure SQL, Synapse databases, and Oracle PL/SQL applications for large data volumes.
•Ensure data integration consistency and error-free transformations.
•Document data workflows and knowledge transfer to technical teams.
Qualifications
•Extensive experience in ETL development and data transformation.
•Expertise in Azure Data Factory, Informatica PowerCenter, and Oracle PL/SQL.
•Strong knowledge of Azure Synapse, Azure SQL DB, and data optimization techniques.
•Experience in developing solutions using Logic Apps and Function Apps.
•Proficiency in Azure DevOps, CI/CD pipelines, and version control management.
•Expertise in database technologies, including Oracle and Microsoft SQL Server.
•Experience with Business Intelligence tools like IBM Cognos and Microsoft Power BI.
•Knowledge of rapid application development (RAD) methodologies.
•Experience in relational and hierarchical database modeling.
•Familiarity with industry best practices for data governance and security.
Summary
This ETL Software Developer role is ideal for professionals who specialize in data integration, cloud-based ETL pipelines, and performance optimization. The position offers an opportunity to work on large-scale data projects, develop complex transformations, and contribute to high-performance data processing solutions using cutting-edge technologies
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
We are looking for ETL Software Developers with expertise in Azure Data Factory, Informatica PowerCenter, and Oracle PL/SQL. The role involves designing data pipelines, developing ETL solutions, integrating data sources, and optimizing data transformation to ensure high-quality data processing and performance.
Advantages
•Hands-on ETL Development – Work with Azure Data Factory, Informatica, and SQL to create and optimize data pipelines.
•Cloud Technologies Exposure – Gain experience in Azure DevOps, CI/CD pipelines, and cloud-based data transformations.
•Diverse Data Integration – Integrate large datasets from multiple source systems and work with complex data transformations.
•Performance Optimization – Work with Azure SQL, Synapse, and Oracle PL/SQL to enhance data processing efficiency.
•Collaboration & Knowledge Sharing – Engage with IT professionals, business analysts, and stakeholders to refine data strategies.
Responsibilities
•Gather requirements and analyze business processes to design effective data transformations.
•Develop and implement Azure Data Factory pipelines for ETL processing.
•Create structured JSON files using ADF and SQL.
...
•Implement Logic Apps and Function Apps for data integration.
•Design and optimize Oracle PL/SQL stored procedures.
•Manage and troubleshoot Informatica PowerCenter workflows.
•Perform data conversion processes, including binary-to-character and EBCDIC-to-UTF.
•Develop complex data transformations for calculated values and derived data.
•Optimize data load performance and ensure smooth incremental and batch data processing.
•Implement CI/CD pipelines using Azure DevOps.
•Configure Azure Resource Management, GitHub Repo, and source control management.
•Work with Azure Boards, Azure Test Plans, Azure Pipelines, Azure Repos, and Azure Artifacts.
•Develop and maintain database models in Sybase Power Designer.
•Monitor ETL pipeline performance, troubleshoot incidents, and resolve data processing issues.
•Optimize Azure SQL, Synapse databases, and Oracle PL/SQL applications for large data volumes.
•Ensure data integration consistency and error-free transformations.
•Document data workflows and knowledge transfer to technical teams.
Qualifications
•Extensive experience in ETL development and data transformation.
•Expertise in Azure Data Factory, Informatica PowerCenter, and Oracle PL/SQL.
•Strong knowledge of Azure Synapse, Azure SQL DB, and data optimization techniques.
•Experience in developing solutions using Logic Apps and Function Apps.
•Proficiency in Azure DevOps, CI/CD pipelines, and version control management.
•Expertise in database technologies, including Oracle and Microsoft SQL Server.
•Experience with Business Intelligence tools like IBM Cognos and Microsoft Power BI.
•Knowledge of rapid application development (RAD) methodologies.
•Experience in relational and hierarchical database modeling.
•Familiarity with industry best practices for data governance and security.
Summary
This ETL Software Developer role is ideal for professionals who specialize in data integration, cloud-based ETL pipelines, and performance optimization. The position offers an opportunity to work on large-scale data projects, develop complex transformations, and contribute to high-performance data processing solutions using cutting-edge technologies
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
