IAM Technical Support Engineer

Responsibilities:

Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading

Required to translate technical systems specifications into working, tested This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit

Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion, and

• Experience in programming and analysis; specialized software package support at the specified experience level
  
• Ability to collaborate with IT Professionals throughout the Software Development Life Cycle
  
• Experience in structured methodologies for the development, design, implementation and maintenance of applications
  
• Experience in design, code, test, debug and document applications
  
• Experience in the use of object and/or third generation language development tools
  
• Experience in one or more programming languages
  
• Experience in application design, latest design patters, deployment and troubleshooting
  
• Experience with relational and hierarchical database technologies
  
• Experience in the use of information retrieval packages using query languages
  
• Experience with one or more communications protocols
  
• Experience in structured methodologies for the design, development, implementation and maintenance of applications
  
• Experience eliciting and documenting information from diverse business area stakeholders and subject matter experts
  
• Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills
  
• A team player with a track record for meeting deadlines
  

ETL Skills

• Knowledge and experience in gathering requirements and business process knowledge in order to transform the data in a way that s geared towards the needs of end users
  
• Knowledge and experience maintaining and improving already existing
  
• Knowledge and experience ensuring that the data architecture is scalable and maintainable
  
• Knowledge and experience working with the business in designing and delivering correct, high quality data
  
• Experience investigating data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions
  
• Experience preparing detailed documentation for further reference
  

Desirable Skills:

• Knowledge and experience with programming Internet-ready applications
  
• Knowledge and experience in rapid application development (RAD) methodologies
  
• Knowledge and understanding of Information Management principles, concepts, policies and practices
  
• Experience with middleware and gateways
  
• Experience reviewing, analyzing, and modifying product installation scripts including encoding, testing, debugging
  
• Ability to provide post-implementation support and resolve any post-implementation technical issues
  
• Experience conducting design walkthrough sessions with project team
  
• Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards
  
• Ability to provide user and system documentation as required
  
  

Requirements

Experience and Skill Set Requirements

Core Technical Skills

• Demonstrates 5 - 10 years of experience designing, developing, and implementing ETL solutions using Azure Data
  
• Demonstrates development and solution design experience in an environment where Azure Data Factory, and PowerBI are used
  
• Experience in designing data warehouses and data marts for databases such as Oracle, SQL Server, Azure Blob, Azure SQL Database as well as having a strong understanding of the architectural implications associated with each platform regarding
  
• Experience in debugging mappings, transformations, mapplets, source qualifier files and
  
• Demonstrates experience with developing ETL solutions to populate data warehouses and create data extracts for the purpose of business intelligence
  
• Demonstrates experience developing star schema multi-dimensional
  
• Experience with developing, debugging and enhancing the performance of complex SQL
  
• Demonstrates experience developing Unix shell
  
• Demonstrates experience using Power Designer to review data models, as well as make changes and generate DDL
  
• Demonstrates experience developing application code package using Azure
  
• Demonstrates development experience with SQL Server 2016+, Azure Blob and Azure SQL Database, Oracle
  
• Demonstrates experience with documenting code changes, creating release packages and deployment
  
• Experience with performing unit testing and conducting System Integration Testing and User Acceptance
  
• Demonstrated Experience with Informatica and Powercenter would be an
  

Public Sector Experience

• Previous experience in an organization of equivalent size and complexity to the Public Demonstrates experience designing and developing applications that comply with GO-ITS standards would be an
  

Mandatory :

• Demonstrates 5 - 10 years of experience designing, developing, and implementing ETL solutions using Azure Data
  
• Demonstrates development and solution design experience in an environment where Azure Data Factory, and Power BI are used
  
• Experience in designing data warehouses and data marts for databases such as Oracle, SQL Server, Azure Blob, Azure SQL Database as well as having a strong understanding of the architectural implications associated with each platform regarding
  
• Azure Cloud