Rq08687 - Software Developer - Etl - Senior
Rubicon Path
RQ08687 - Software Developer - ETL - SeniorAbout the job RQ08687 - Software Developer - ETL - Senior
Responsibilities
Participate in the review of project, work request and maintenance release artefacts - Use Case, System Requirement Specification, etc.
Deliver detailed system design documents and any other supporting documentation conforming to Ministry standards.
Design logical and physical data models using Sybase Power Designer.
Implement data pipelines using Azure Data Factory (ADF), stored procedure, and Informatica PowerCenter performing extraction, transformation, and loading activities.
Implement solutions using Logic App and Function App.
Generate structured JSON file using ADF/ SQL.
Develop Azure CI/CD pipeline to automate ADF release.
Develop complex Oracle PL/SQL program to fulfill project requirements.
Implement complex data conversion, e.G., binary to character, EBCDIC to UTF.
Implement complex data transformation(s) for derived and calculated values.
Integrate data sets from diverse source systems.
Implement ADF for initial data load and incremental load.
Promote ADF and Informatica ETL/ELT through all Ministry environments including Development, Integration Testing, QA, UAT, Production.
Resolve and troubleshoot ADF pipeline, stored procedure, and Informatica workflow technical problems.
Monitor and analyze incident, provide timely resolution.
Collaborate with IT Professionals throughout the Software Development Life Cycle.
Document information from diverse business area stakeholders and subject matter experts.
Optimize performance of ADF pipeline, Azure SQL and Synapse databases, and Informatica workflow.
Monitor application functionality and performance on daily basis.
Provide effective knowledge transfer to Ministry staff at all stages of this assignment.
QualificationsEvaluation Table
ETL Development-Data Integration (40%)
Extensive experience in gathering requirements and business process knowledge in order to design correct and high-quality data transformation.
Extensive experience in design, development, and implementation with Azure Data Factory, Databricks, including:
Self-Hosted Integration Runtime
Performance tuning on large data volumes
Complex data transformations
ADF Debugger to validate data transformation.
Experience with Informatica, including:
Workflow Manager
Repository Manager
Designer
Workflow Monitor
Experience with developing solutions using Logic App and Function App.
Experience in rapid application development (RAD) methodologies.
Experience in maintaining and improving existing ETL processes.
Experience in investigating data to identify potential issues within ETL pipelines.
Experience with Business Intelligence tools IBM Cognos and Microsoft PowerBI.
Experience with CI/CD (DevOps) pipelines and concepts, including:
Branching, pull requests, build, release, multiple parallel development repositories merge.
Experience with Azure DevOps, including:
Oracle PL/SQL Development (10%)
Extensive experience in designing and developing SQL Server Stored Procedure, Oracle PL/SQL programs.
Database Technologies (10%)
Experience with Oracle, Microsoft SQL Server database and tools.
Experience with relational and hierarchical database technologies.
Extensive knowledge of Azure SQL DB and Synapse platforms, including:
Performance tuning on large data volume
Candidate is required to come in office 3 days a week.
#J-18808-Ljbffr
Responsibilities
Participate in the review of project, work request and maintenance release artefacts - Use Case, System Requirement Specification, etc.
Deliver detailed system design documents and any other supporting documentation conforming to Ministry standards.
Design logical and physical data models using Sybase Power Designer.
Implement data pipelines using Azure Data Factory (ADF), stored procedure, and Informatica PowerCenter performing extraction, transformation, and loading activities.
Implement solutions using Logic App and Function App.
Generate structured JSON file using ADF/ SQL.
Develop Azure CI/CD pipeline to automate ADF release.
Develop complex Oracle PL/SQL program to fulfill project requirements.
Implement complex data conversion, e.G., binary to character, EBCDIC to UTF.
Implement complex data transformation(s) for derived and calculated values.
Integrate data sets from diverse source systems.
Implement ADF for initial data load and incremental load.
Promote ADF and Informatica ETL/ELT through all Ministry environments including Development, Integration Testing, QA, UAT, Production.
Resolve and troubleshoot ADF pipeline, stored procedure, and Informatica workflow technical problems.
Monitor and analyze incident, provide timely resolution.
Collaborate with IT Professionals throughout the Software Development Life Cycle.
Document information from diverse business area stakeholders and subject matter experts.
Optimize performance of ADF pipeline, Azure SQL and Synapse databases, and Informatica workflow.
Monitor application functionality and performance on daily basis.
Provide effective knowledge transfer to Ministry staff at all stages of this assignment.
QualificationsEvaluation Table
ETL Development-Data Integration (40%)
Extensive experience in gathering requirements and business process knowledge in order to design correct and high-quality data transformation.
Extensive experience in design, development, and implementation with Azure Data Factory, Databricks, including:
Self-Hosted Integration Runtime
Performance tuning on large data volumes
Complex data transformations
ADF Debugger to validate data transformation.
Experience with Informatica, including:
Workflow Manager
Repository Manager
Designer
Workflow Monitor
Experience with developing solutions using Logic App and Function App.
Experience in rapid application development (RAD) methodologies.
Experience in maintaining and improving existing ETL processes.
Experience in investigating data to identify potential issues within ETL pipelines.
Experience with Business Intelligence tools IBM Cognos and Microsoft PowerBI.
Experience with CI/CD (DevOps) pipelines and concepts, including:
Branching, pull requests, build, release, multiple parallel development repositories merge.
Experience with Azure DevOps, including:
Oracle PL/SQL Development (10%)
Extensive experience in designing and developing SQL Server Stored Procedure, Oracle PL/SQL programs.
Database Technologies (10%)
Experience with Oracle, Microsoft SQL Server database and tools.
Experience with relational and hierarchical database technologies.
Extensive knowledge of Azure SQL DB and Synapse platforms, including:
Performance tuning on large data volume
Candidate is required to come in office 3 days a week.
#J-18808-Ljbffr
Vacancy posted 2 hours ago
Similar jobs that could be interesting for youBased on the Rq08687 - Software Developer - Etl - Senior in Winnipeg, MB vacancy
- ...Bursting technologies, and Informatica ETL.Responsibilities Perform analysis, design, developing, unit testing, defect fixing and... ...in Oracle PL/SQLDesign, develop and test Informatica mappingsDevelop... ...and analysis; specialized software package support at the specified...SeniorApprenticeship
- RQ09467 - Software Developer - ETL - SeniorTo respond to the priorities of the Government of Ontario through the passage of the Bill 5, Protect Ontario... ...Experience (5%) Prior experience working with OPS as a senior ETL Developer. Prior experience working with Public...SeniorWork at officeRemote work3 days per week
- ...Bursting technologies, and Informatica ETL. Responsibilities:This request is for strong developers to help in designing and... ...environment in Oracle PL/SQL Design, develop and test Informatica mappings... ...and analysis; specialized software package support at the specified...SeniorApprenticeship
- RQ09229 - Software Developer - ETL - SeniorAbout the job RQ09229 - Software Developer - ETL - SeniorDescription A Note on Assignment Type:... ...Office of the Public Guardian and Trustee (OPGT) requires a Senior Software Developer ETL to perform activities for interfacing...SeniorContract workWork at officeMonday to friday
- RQ09222 - Software Developer - ETL - Senior About the job RQ09222 - Software Developer - ETL - Senior DescriptionA Note on Assignment Type:This position is currently listed as "Onsite"; however, the Assignmentunder this request will provisionally be "Hybrid", working...SeniorContract workWork at officeMonday to friday
- The Senior Software Developer - ETL will design, build, and maintain scalable data pipelines, integrations, and reusable data services that enable enterprise AI, analytics, and data initiatives. The role will help improve access to trusted data across enterprise systems...Senior
- Client: Metrolinx – RQ00241We are seeking a Senior Software Developer – ETL with significant hands‑on experience in designing, developing, and maintaining scalable, production‑grade data pipelines and integration solutions. The ideal candidate will have strong expertise...Senior3 days per week
- RQ09315 - Software Developer - ETL - SeniorAbout the job RQ09315 - Software Developer - ETL - SeniorNOTE Assignment Type: This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from...SeniorContract workInternship3 days per week
- Senior Software Developer, ETL & AI Data Engineering Location: Toronto, ON (Hybrid, 3 days onsite per week, near Union Station)Language: Written and spoken language requirements to be confirmedDuration: 6-month contract, until May 31, 2027About the Opportunity...SeniorContract work3 days per week
- ...data into silver/gold data for reporting consumption. Design, develop, and release deploy Power BI reports and dashboards meeting KPIs... ...technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion...Work at officeMonday to friday
- ...Toronto, ON (5 days onsite in the office) Position Type: Contract Responsibilities: Power BI Development & Reporting Design, develop, and maintain interactive Power BI dashboards and reports to support business and operational needs. Create data models, measures,...Contract workWork at office
- Elevate your expertise as a Senior Software Developer ETL at the Office of the Public Guardian and Trustee. This hybrid role focuses on integrating and testing the Dynamics 365 solution. In this position, you’ll contribute to critical integrations within the integrations team...SeniorWork at office
- About the job RQ08100: Software Developer - ETLGeneral ResponsibilitiesThis role is responsible for designing, developing, maintaining, and optimizing ETL (Extract, Transform, Load) processes in Databricks for data warehousing, data lakes, and analytics. The developer will...Work at office3 days per week
- About the job RQ07956 - Sr Software Developer - ETLResponsibilities Design, implement, and continuously... ...a track record for meeting deadlines ETL Skills Knowledge and experience in... ...would be an asset Must Have Senior ETL Developer 7+ years Demonstrates...Senior
- Overview Our client, an innovative industry leader in the insurance domain, is looking for a Senior ETL Developer - Hybrid to join their growing team. The successful candidate will have extensive experience building reliable, scalable, and efficient data pipelines to operationalize...SeniorPermanent employmentFull timeWork at office3 days per week
$100 per hour
SENIOR SOFTWARE DEVELOPER/ETL (Azure & Python; Enterprise AI & Data Centre of Excellence)Requisition #: R26-3629 (RQ00241) Location: Hybrid (3 days onsite / 2 days WFH; Toronto, ON - *See WorkModel) Engagement Type: Contract Number of Resources required...SeniorHourly payContract workFor contractorsWork at office- Build Azure ETL solutions as a Senior Software Developer, using Azure Data Factory and Informatica in a hybrid office schedule. Integrate data across complex environments.This senior developer designs, implements, and supports data pipelines throughout the software development...SeniorWork at office
- You should have experience with InfoSphere on the Linux Platform administration Must have experience in DataStage and QualityStage Experience in Linux and shell scripting Strong experience in Information Services Director, Information Analyzer and PL SQL Hands on...Senior
- Build Azure ETL pipelines in a hybrid assignment supporting data migration with Azure Data Factory, Synapse, and strong SQL expertise. Work weekdays within stated hours.As a Senior Software Developer ETL, you will support the Office of the Public Guardian and Trustee’s migration...SeniorWork at officeWeekday work
$180k - $200k per year
...visionary and a strategic leader within our AI organization. While a Senior Data Scientist excels at building and deploying specific models,... ...), Agile. What You Must Have 10+ years of experience in software or data science, with at least 8+ years specifically...Senior3 days per week- ...Software Developer - ETL / Power BI - Intermediate (BBBH12319) Toronto, Canada Seeking an experienced Software Developer - ETL / Power BI to support enterprise data integration, ETL processes, and business intelligence initiatives. The successful candidate will develop and...
- Build scalable ETL pipelines and data integrations as a Senior Software Developer supporting enterprise AI and analytics initiatives.This senior role develops trusted data access across enterprise systems. You will create reusable services, prepare structured and unstructured...Senior
- Apply Ab Initio expertise as a Senior Developer in hybrid Toronto Downtown work, supporting ETL migration to SAP HANA Stored Procedures.This Senior Ab Initio Developer serves as the subject matter expert for the existing ETL ecosystem. The work involves analyzing implementation...Senior
- Elevate your career as a Senior ETL Developer with the Central Agencies Cluster in Toronto, ON. Design and maintain innovative ETL solutions to support large-scale data operations. This role focuses on building and optimizing data pipelines and architectures for the Enterprise...Senior
- Deliver senior ETL solutions with Azure Data Factory, Power BI, and SQL while translating specifications into tested applications and deployments.This Senior Software Developer specializes in extraction, transformation, and loading across complex application and data environments...Senior
- Transform data processes as a Senior DataStage ETL Developer with expertise in Linux and advanced data analysis tools. Dive into QualityStage and PL SQL tasks regularly. This role is intended for experienced ETL developers with more than 5 years focusing on DataStage and QualityStage...Senior
- ...proficiency in Teradata SQL and BTEQ is required.8-10 years of experience ETL development using various versions of Teradata6+ years of... ..., releases.Excellent written and verbal communication skills.Develops statements of problems and requirements. Can translate both business...Senior
- Design cloud ETL solutions with Informatica IICS, IDMC, PowerCenter, and SQL in a senior development capacity. Support data processing, reporting, and troubleshooting.This Senior Informatica Developer requires eight to ten years of overall ETL development experience. You will...Senior
- Design IICS and IDMC ETL solutions using strong SQL expertise across Oracle and MS SQL databases. Work with Agile teams and stakeholders to deliver data solutions.This senior developer position requires eight to ten years of overall ETL development experience. You will use...Senior
- Use Ab Initio expertise in a hybrid Senior Developer assignment, working three days weekly in Toronto Downtown. Bring eight years of experience to complex ETL migration.This Ab Initio Developer serves as the subject matter expert for an existing Ab Initio ETL ecosystem. The...SeniorWork at office
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Rq08687 - Software Developer - Etl - Senior. Be the first to apply!
Related searches
- software engineer part time Winnipeg, MB
- software engineer Winnipeg, MB
- software design engineer Winnipeg, MB
- software engineer - computer Winnipeg, MB
- software developer internship no experience Winnipeg, MB
- ingénieur logiciel Winnipeg, MB
- software engineer co-op Winnipeg, MB
- software development engineer Winnipeg, MB
- software developer Winnipeg, MB
- software engineer - ai machine learning Winnipeg, MB

