Talent.com
Rubicon Path
RQ08687 - Software Developer - ETL - SeniorRubicon Path • Toronto, ON, Canada
RQ08687 - Software Developer - ETL - Senior

RQ08687 - Software Developer - ETL - Senior

Rubicon Path • Toronto, ON, Canada
30+ days ago
Job type
  • Full-time
Job description

RQ08687 - Software Developer - ETL - Senior

About 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.

Qualifications

Evaluation 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
Create a job alert for this search

RQ08687 - Software Developer - ETL - Senior • Toronto, ON, Canada

Similar jobs

RQ09230 - Software Developer - ETL - Senior

Rubicon PathToronto, Ontario, Canada
Full-time

RQ09230 - Software Developer - ETL - Senior.About the job RQ09230 - Software Developer - ETL - Senior.This position is currently listed as "Onsite"; however, the Assignment under this request will ... Show more

 • Promoted

RQ10574 - Sr. Software Developer - ETL

Source CodeToronto, Ontario, Canada
Full-time

ONSITE 5 days a week - College St.A senior Software Developer ETL is required to provide best practice migration solutions and oversee all facilities of the data and files migration from legacy app... Show more

 • Promoted

Senior ETL Developer - DataStage Focus

Apptoza Inc.Toronto, ON, CA
Full-time

We are on the lookout for a Senior ETL Developer with expertise in DataStage and Talend to lead our ETL initiatives.Enhance enterprise data integration and analytics through your skills.As a Senior... Show more

 • Promoted

Senior Software Developer

Interactoronto, on, Canada
Full-time

At Interac, we protect both — driving trust, security, and inclusion, so our digital economy thrives.Founded in 1984, Interac connects Canadians through secure digital payments, advanced identity v... Show more

 • Promoted

ETL Developer - Informatica PowerCenter

Aviva CanadaMarkham, York Region, CA
Full-time

ETL Developer / Finance Systems Data Engineer with solid experience in the insurance industry and expertise in ETL and PostgreSQL development to join our dynamic team.Join to apply for the ETL Deve... Show more

 • Promoted

Software Developer Etl 9222-0715 - C$140,000 - C$180,000 A Year

FoilconEast York, Canada
Full-time

Develop and manage ETL processes for data migration, including data analysis, transformation, and testing.Requires strong ETL principles and Azure skills. Show more

 • Promoted

ETL Developer

United States Digital Space LLCToronto, ON, CA
Full-time

ETL Developer to join our team and support the development and maintenance of enterprise data integration solutions.In this role, you will design, develop, and optimize ETL pipelines while ensuring... Show more

 • Promoted

Senior Software Developer ETL in Toronto

Source CodeToronto, ON, CA
Full-time

Take on the role of Senior Software Developer specializing in ETL processes in Toronto.This hybrid position highlights your expertise in data integration and Microsoft Azure technologies.We are see... Show more

 • Promoted

Software Developer Etl 9467-1315 - C$70,000 - C$75,000 A Year

FoilconToronto, Canada
Full-time

Join to apply for the Software Developer ETL role at Foilcon 1 day ago Be among the first 25 applicants Join to apply for the Software Developer ETL role at Foilcon HM Note: This hybrid contrac... Show more

 • Promoted

Developer

Absorb SoftwareToronto, ON, CA
Full-time

Absorb is seeking an intermediate-level Developer to take ownership of an internal ETL tool that supports billing, accounting, and operations.In this individual contributor role, you’ll help mainta... Show more

 • Promoted

Lead Diagnostics Software Engineer, ATE Integration

Advanced Micro Devices, IncMarkham, ON, CA
Full-time

At AMD, our mission is to build great products that accelerate next-generation computing experiences—from AI and data centers, to PCs, gaming and embedded systems.Grounded in a culture of innovatio... Show more

 • Promoted

ETL QA Tester

TEKsystemsMarkham, York Region, CA
Temporary

Be among the first 25 applicants.Get AI-powered advice on this job and more exclusive features.Location: Markham, ON ( 4 days onsite per week ).Contract Term: 6 months to start.We’re hiring an expe... Show more

 • Promoted

Senior Software Engineer - HashiCorp

LeadingtalentMarkham, ON, CA
Full-time

A career in IBM Software means you’ll be part of a team that transforms our customer’s challenges into industry-leading solutions.We are an infinitely curious team, always seeking new possibilities... Show more

 • Promoted

RQ09229 - Software Developer - ETL - Senior

Rubicon PathToronto, ON, CA
Full-time

RQ09229 - Software Developer - ETL - Senior.About the job RQ09229 - Software Developer - ETL - Senior.This position is currently listed as "Onsite"; however, the Assignment under this request will ... Show more

 • Promoted

Senior ETL Consultant

Maarut IncToronto, ON, CA
Full-time

Be among the first 25 applicants.Get AI-powered advice on this job and more exclusive features.Direct message the job poster from Maarut Inc.Participate in the review of project, work request and m... Show more

 • Promoted

Senior Software Developer - Workflows

Verily Healthtoronto, on, Canada
Full-time

Verily Health is a data platform and technology company purpose-built to power AI-enabled precision health solutions that accelerate research and improve care for individuals and communities.Unique... Show more

 • Promoted

Senior Software Developer (SA)

NRT Technology Corp.Toronto, ON, CA
Full-time

At NRT, we build more than solutions: we build up each other.NRT is a worldwide leader in future-ready FinTech and Information Technology designed to elevate and enhance the enterprise gaming indus... Show more

 • Promoted

Senior Software Developer Driving Virtualization and Simulation Integration

General MotorsMarkham, York Region, CA
Full-time

Elevate your career as a Senior Software Developer focusing on virtualization and simulation integration.Contribute to innovative automotive solutions with effective co-simulation environments.In t... Show more

 • Promoted

Senior Application Developer – Oracle EBS

StantecMarkham, ON, CA
Full-time

Accelerate your professional journey with Stantec as a Senior Application Developer focusing on Oracle EBS.Engage in high-level software solutions that drive efficiency in enterprise applications.B... Show more

 • Promoted

Senior Software Development Engineer - Profiling Tools

AMDMarkham, ON, CA
Full-time

WHAT YOU DO AT AMD CHANGES EVERYTHING.At AMD, our mission is to build great products that accelerate next‑generation computing experiences—from AI and data centers, to PCs, gaming and embedded syst... Show more