This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
Do you have extensive experience in design, development, and implementation with Azure Data Factory, Databricks or Informatica? Do you have extensive experience in designing and developing SQL Server Stored Procedure, Oracle PL/SQL programs? If so, this would be a great opportunity for you! Our client is looking for a Senior Software Developer - ETL for a 12 month contract in North York. This is an onsite role.
Job Responsibility:
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 standards
Design logical and physical data models using Sybase Power Designer
Produce transformation mapping document
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 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 staff at all stages of this assignment
Requirements:
Extensive experience in design, development, and implementation with Azure Data Factory, Databricks or Informatica
Experience with CI/CD (DevOps) pipelines
Extensive experience in designing and developing SQL Server Stored Procedure, Oracle PL/SQL programs
Experience with Oracle, Microsoft SQL Server database and tools