Software Developer ETL 9309-2410

Join to apply for the Software Developer ETL 9309-2410 role at Foilcon

This hybrid contract role requires three (3) days in the office. Candidates must include their first and last name in their resume.

Job Description

The vendor will provide the following services and deliverables :

• Review project, work request, and maintenance release artifacts such as Use Case and System Requirement Specification.
• Deliver detailed system design documents conforming to Ministry standards.
• Design logical and physical data models using Sybase Power Designer.
• Produce transformation mapping documents.
• Implement data pipelines using Azure Data Factory (ADF), stored procedures, and Informatica PowerCenter for extraction, transformation, and loading activities.
• Implement solutions using Logic App and Function App.
• Generate structured JSON files using ADF / SQL.
• Develop Azure CI / CD pipelines to automate ADF releases.
• Develop complex Oracle PL / SQL programs to meet project requirements.
• Implement complex data conversions, such as binary to character and EBCDIC to UTF.
• Perform complex data transformations for derived and calculated values.
• Integrate datasets from diverse source systems.
• Implement ADF for initial and incremental data loads.
• Promote ETL / ELT solutions through all Ministry environments.
• Resolve and troubleshoot technical issues with ADF pipelines, stored procedures, and Informatica workflows.
• Monitor and analyze incidents to provide timely resolutions.
• Collaborate with IT professionals throughout the Software Development Life Cycle.
• Document information from business stakeholders and subject matter experts.
• Optimize performance of ADF pipelines, Azure SQL, Synapse databases, and Informatica workflows.
• Monitor application functionality and performance daily.
• Provide knowledge transfer to Ministry staff at all stages.

Required Skills and Experience

Evaluation criteria include :

Azure Technologies

Oracle PL / SQL Development

Database Technologies

Must-haves

Additional Details

#J-18808-Ljbffr