Talent.com
Rubicon Path
RQ08590 - Software Developer - ETL - SeniorRubicon Path • Toronto, ON, CA
RQ08590 - Software Developer - ETL - Senior

RQ08590 - Software Developer - ETL - Senior

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

RQ08590 - Software Developer - ETL - Senior

About the job RQ08590 - Software Developer - ETL - Senior

Scope of Services and Deliverables - The Services and Deliverables to be provided by the Vendor will include the following:

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

SkillsExperience and Skill Set Requirements

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:
    • Extensive experience in designing and developing SQL Server Stored Procedure, Oracle PL/SQL programs.

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

Must haves

  • Extensive experience in gathering requirements and business process knowledge in order to design correct and high-quality data transformation.
#J-18808-Ljbffr
Create a job alert for this search

RQ08590 - Software Developer - ETL - Senior • Toronto, ON, CA

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

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

FoilconEast York, Canada
Full-time

ETL Developer to design, develop, and maintain robust data integration solutions using Informatica PowerCenter and IDMC, with SQL, PL/SQL and data warehousing. Show more

 • Promoted

Senior Software Developer – IoT

Armstrong Fluid Technologytoronto, on, Canada
Full-time

Imagine working at the forefront of innovation in fluid-flow technology, with over 1400 colleagues across the globe, and contributing to a legacy of excellence that spans eight manufacturing facili... 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 ETL in Toronto

Source CodeToronto, Ontario, Canada
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

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

FoilconToronto County, 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

RQ10949 - Sr. Software Developer - ETL

Source CodeToronto, ON, CA
Temporary

ONSITE 5 days - 21 College Street.Security Level: CRJMC + Credit Check.Understanding of data pipeline architectures, Azure workflow orchestration tools, and concepts related to data ingestion, tran... Show more

 • Promoted

Senior Software Engineer - HashiCorp Secure Products

Cacheflowmarkham, on, Canada
Full-time

At IBM Software, we transform client challenges into solutions.Building the world’s leading AI-powered, cloud-native products that shape the future of business and society.Our legacy of innovation ... Show more

 • Promoted

Senior Software Developer - Workflows

Verily HealthToronto, ON, CA
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

RQ09444 - Sr. Software Developer - ETL

Source CodeToronto, Ontario, Canada
Full-time

IT software development and testing teams.MS Dynamics 365 Customer Relationship Management (CRM).Enterprise Resource Planning (ERP).PowerApps, Power Automate and Azure Data Factory, Azure Synapse A... Show more

 • Promoted

Etl Developer - C$80,000 - C$120,000 A Year - Remote

FidelityEast York, Canada
Remote
Full-time

Develops and supports ETL data integration solutions using Informatica and Snowflake SQL for Fidelity Canada. Show more

 • Promoted

Etl Developer - C$80,000 - C$120,000 A Year - Remote

Fidelity CanadaNorth York, Canada
Remote
Full-time

Develop and support ETL data integration solutions using Informatica and Snowflake SQL for Fidelity Canada.Requires 3+ years of relevant experience. 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

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 - Capital Markets

MindtrisToronto, ON, CA
Full-time

Step into a pivotal role as a Senior Software Developer at Mindtris in Toronto, focusing on Capital Markets solutions.Engage in hybrid development involving microservices and data analytics.In this... 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