Informatica Developer
Posted on :
27-04-2024
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Req ID : 2762472
Assignment: RQ07422 Software Developer ETL Senior
Start Date:
End Date:
Office Location: 5700 Yonge Street 10th Floor Toronto ON M2M 4K5
Organization: Health Services Cluster
Ministry: Ministry of Health
# Business Days: 198.00
Title: Software Developer ETL
Hybrid: Office 3 days a week and 2 days from home
Start Date:
End Date:
Office Location: 5700 Yonge Street 10th Floor Toronto ON M2M 4K5
Organization: Health Services Cluster
Ministry: Ministry of Health
# Business Days: 198.00
Title: Software Developer ETL
Hybrid: Office 3 days a week and 2 days from home
Must haves:
- Informatica HandsOn Working Experience (10 years)
- Design build and tune ETL/ELT solutions onpremises (Informatica Powercenter)
Nice to Have:
- AWS experience
- Experience Using Informatica oncloud (IDMC)
Description
Responsibilities:
Responsibilities:
- Assist with the design and configuration of the cloud infrastructure to optimally support IDMC.
- Mentor and support our ETL developers in their transition to IDMC.
- Help with the ETL code conversion from legacy Informatica PowerCenter to IDMC;
- Help with ETL processes optimization and propose and implement technical solutions whenever Powercenter code is not supported in IDMC;
- Be the main support point for any issues faced by the team which requires advanced IDMC knowledge.
- Provide knowledge transfer to other team members as needed.
Experience and Skill Set Requirements
Informatica (10 years) and AWS (5 years) experience 50 points
Design build and tune ETL/ELT solutions onpremises (Informatica Powercenter) and oncloud (Informatica IDMC).
Informatica transformations mappings and workflows.
Migrate ETL workloads form onpremises to public cloud (AWS).
Scripting languages (Python Linux shell).
ETL processes automation and orchestration
AWS services (S3 Athena Lambda Glue AppFlow Step Functions CloudWatch etc).
Design build and tune ETL/ELT solutions onpremises (Informatica Powercenter) and oncloud (Informatica IDMC).
Informatica transformations mappings and workflows.
Migrate ETL workloads form onpremises to public cloud (AWS).
Scripting languages (Python Linux shell).
ETL processes automation and orchestration
AWS services (S3 Athena Lambda Glue AppFlow Step Functions CloudWatch etc).
Database/Data warehouse (10 years) 30 points
Relational database design and optimization experience.
Security controls to safeguard sensitive data (PI and PHI).
Query tunning.
Dimensional data modelling for data warehousing.
Advanced SQL and PLSQL (or equivalent).
Relational database design and optimization experience.
Security controls to safeguard sensitive data (PI and PHI).
Query tunning.
Dimensional data modelling for data warehousing.
Advanced SQL and PLSQL (or equivalent).
General Skills 15 points
Leadership skills with ability to identify areas for improvement and recommend solutions.
Exceptional analytical problem solving and decisionmaking skills.
Strong interpersonal verbal and written communication and presentation skills.
Proven troubleshooting and critical thinking experience.
A motivated flexible detailoriented and creative team player with perseverance excellent organization and multitasking abilities and a proven track record for meeting strict deadlines.
Leadership skills with ability to identify areas for improvement and recommend solutions.
Exceptional analytical problem solving and decisionmaking skills.
Strong interpersonal verbal and written communication and presentation skills.
Proven troubleshooting and critical thinking experience.
A motivated flexible detailoriented and creative team player with perseverance excellent organization and multitasking abilities and a proven track record for meeting strict deadlines.
Public Sector/Healthcare Experience 5 points
Knowledge of Public Sector Enterprise Architecture artifacts (or similar) processes and practices and ability to produce technical documentation that comply with industry standard practices.
Knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies.
Knowledge and understanding of Ministry policy and IT project approval processes and requirements.
Experience with large complex IT Healthrelated projects.
Knowledge of Public Sector Enterprise Architecture artifacts (or similar) processes and practices and ability to produce technical documentation that comply with industry standard practices.
Knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies.
Knowledge and understanding of Ministry policy and IT project approval processes and requirements.
Experience with large complex IT Healthrelated projects.
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
