Remote Senior Informatica Developer

TEEMA Solutions Group; Winnipeg; Remote; CAD 90,000 - 120,000; Full time

Job summary

A leading IT solutions provider in Canada is seeking an experienced Senior Informatica Developer to join their team. This role is essential for providing support and developing new data integration solutions. The ideal candidate will have over 10 years of experience in Informatica development, strong ETL skills, and the ability to collaborate effectively with stakeholders. This opportunity offers both remote and on-site options.

Qualifications

• Minimum 10 years of professional experience in Informatica development, with relevant certification.
• Proven expertise in designing, developing, deploying, testing, and maintaining Informatica ETL solutions.
• Strong written and verbal communication skills, able to explain technical concepts to various audiences.

Responsibilities

• Providing daily support for existing Informatica workloads, including issue resolution and troubleshooting.
• Designing, building, and maintaining new Informatica workflows based on business requirements.
• Collaborating with stakeholders to ensure Informatica solutions meet evolving data integration needs.

Skills

Informatica ETL Development

SQL

Data Warehousing

Relational Database Design

Agile Principles

Education

Informatica Cloud Data Governance Associate Certification

Tools

Oracle

DB2

SQL Server

Job description

Term 24 month contract, 12 month initial with 1 renewal term of 12 months and more expected

Location Winnipeg, MB or Remote in Canada

Number of Openings 2

Role Overview

We are seeking an experienced Senior Informatica Developer to join our team. This role is crucial for providing daily support for existing Informatica workloads, resolving issues, and designing, building, and maintaining new Informatica workflows based on business requirements. The ideal candidate will act as a subject matter expert, collaborate with stakeholders, and ensure our data integration solutions are scalable, flexible, and efficient.

Scope of Work & Key Responsibilities

• Daily Support and Troubleshooting: Providing daily support for existing Informatica workloads, including issue resolution and troubleshooting.
• Design and Maintenance: Designing, building, and maintaining new Informatica workflows based on business requirements.
• Subject Matter Expertise: Acting as a subject matter expert, offering guidance and sharing best practices for optimal platform use.
• Platform Administration: Assisting with platform administration, performance tuning, and standards definition.
• Stakeholder Collaboration: Collaborating with stakeholders to ensure Informatica solutions meet evolving data integration needs.
• ETL Development: Supporting, troubleshooting, tuning performance, and fixing existing Extract, Transform, and Load (ETL) systems.
• Data Flow Analysis: Tracing data flows from source to target systems for both current and future solutions.
• Requirements Analysis: Analyzing solution requirements, including source data, target systems, and necessary transformations.
• Workflow Management: Creating, updating, documenting, and scheduling ETL workflows.
• Architecture & Standards: Collaborating with the team to define information architecture and promote consistent, secure, and reusable design practices.
• Data Modeling: Reviewing and interpreting relational and dimensional data models.
• Data Warehouse Development: Developing ETL processes for data warehouse environments (inbound and outbound).
• Modern Data Management: Leveraging modern data management techniques, including integration with data lakes, data lakehouse, and cloud-native architectures to support scalable, flexible, and efficient data solutions.

Resource Qualifications

Experience

• Minimum 10 years of professional experience in Informatica development, with relevant certification.
• Proven expertise in designing, developing, deploying, testing, and maintaining Informatica ETL solutions.
• Extensive hands‑on experience with design, development, and deployment of Informatica solutions.
• Extensive experience with data warehousing best practices.
• Experience in the insurance sector is considered an asset.

Key Certifications & Skills

Key Qualifications (Preferred Certifications)

Informatica Cloud Data Governance Associate Certification

Technical Skills (Depth & Breadth)

• Proficient in relational database design, development, and optimization, including SQL, Oracle, DB2, and SQL Server.
• Proficient in data warehousing principles and dimensional modeling, including design, development, and optimization.
• Proficient in data management techniques, including integration with data lakes, data lakehouse, and cloud-native architectures.
• Skilled in analyzing business and technical requirements and producing high‑ and low‑level design documentation.

Professional & Process Skills

Strong written and verbal communication skills, with the ability to explain technical concepts to both technical and non-technical audiences.

Demonstrated ability to collaborate and maintain effective relationships with internal teams, leadership, and external vendors.

Demonstrated ability to manage multiple activities within established deadlines.

Working knowledge of Agile, Scrum, Design Thinking, and Lean principles.

Working knowledge of ITIL Service Management principles, including Incident, Problem, and Change Management.