Employer Active
Scope of Services and Deliverables - The Services and Deliverables to be provided by the Vendor will include the following:
Monitor and analyze incident, provide timely resolution
Participate in the review of work request and maintenance release artefacts - Use Case, System Requirement Specification,
Deliver detailed system design documents and any other supporting documentation conforming to Ministry standards
Design logical and physical data models using Sybase Power Designer
Produce transformation mapping document
Implement solution using Azure Data Factory (ADF) pipeline and stored procedure, and Informatica PowerCenter
Develop Azure CI/CD pipeline to automate ADF release
Implement complex data conversion, , 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
Debug ADF pipeline and stored procedure, and Informatica workflow to investigate and fix defects
Actively participate, support and provide feedback to project team during design/development/testing/implementation phase
Produce supporting documentation
Optimize performance of ADF pipeline, Azure SQL and Synapse databases, and Informatica workflow
Monitor application functionality and performance daily
Provide effective knowledge transfer to Ministry staff at all stages of this assignment
Skill Set Requirements:
ETL and BI Development
Extensive experience with ETL tools Informatica PowerCenter and Microsoft SSIS
Extensive experience with Azure Data Factory, including:
Self-Hosted Integration Runtime
o Data movement, ETL pipelines
o Performance tuning on large data volumes
o Complex data transformations
o ADF Debugger to validate data
o Azure Roles
Experience with CI/CD (DevOps) pipelines and concepts, including:
o Azure Resource Management
o GitHub Repo
o Source code version control
o Branching, pull requests, build, release, merging pipeline across multiple parallel development
Experience with Azure DevOps,
Azure Boards
Azure Test Plans
Azure Pipelines
Azure Repos
Azure Artefacts
Expert experience with Business Intelligence tools IBM Cognos and Microsoft PowerBI:
Data Modelling
Proven expert experience with Oracle Siebel data model and data
Proven experience in data modelling using Sybase Power
Database Technologies
Experience with Oracle, Microsoft SQL Server database and tools
Extensive knowledge of Azure SQL DB and Synapse platforms, including:
Performance tuning on large data volume
Skills
Experience and Skill Set Requirements
Evaluation Table
ETL and BI Development:
Extensive experience with ETL tools Informatica PowerCenter and Microsoft
Extensive experience with Azure Data Factory, including:
o Self-Hosted Integration Runtime
o Data movement, ETL pipelines
o Performance tuning on large data volumes
o Complex data transformations
o ADF Debugger to validate data transformation
o Azure Roles
Experience with CI/CD (DevOps) pipelines and concepts, including:
o Azure Resource Management
o GitHub Repo
o Source code version control
o Branching, pull requests, build, release, merging pipeline across multiple parallel development repositories
Experience with Azure DevOps, including:
o Azure Boards
o Azure Test Plans
o Azure Pipelines
o Azure Repos
o Azure Artefacts
Expert experience with Business Intelligence tools IBM Cognos and Microsoft PowerBI
Data Modelling
Proven expert experience with Oracle Siebel data model and data
Proven experience in data modelling using Sybase Power
Database Technologies
Experience with Oracle, Microsoft SQL Server database and tools
Extensive knowledge of Azure SQL DB and Synapse platforms, including:
o Performance tuning on large data volume
Mandatory
Extensive experience with ETL tools Informatica PowerCenter and Microsoft SSIS;
Extensive experience with Azure Data Factory
Experience with CI/CD (DevOps) pipelines and concepts
Full Time