Application Developer (Data Engineer, Informatica) at Affinity

On behalf of our Healthcare Client, Affinity is looking for an Application Developer to support the Disaster Recovery Program. The resource will design, build, document, and continuously improve technical tools that support disaster recovery capabilities, data integration, and analytics across the provincial health system.

Responsibilities:

• Design and build ETL infrastructure for extracting, transforming, and loading data from diverse sources using Informatica, SQL, SSIS, APIs, and related technologies

• Architect relational and multi-dimensional databases, including star/snowflake schemas, SCDs, fact tables, and cubes

• Optimize and automate internal data processes and pipelines for scalability and reliability

• Develop analytics tools that deliver actionable insights into operational and business performance

• Maintain, troubleshoot, monitor, backup, and support ETL and data integration environments

• Ensure datasets comply with data-sharing agreements, legislation, and architectural standards

• Mentor and support Information Analysts and junior data resources as required

Qualifications:

• Minimum 5 years experience as a Data Engineer or similar role

• One of the following education paths:

o Bachelor’s degree in IT, Engineering, or Computer Science OR

o Related diploma plus 3 additional years of experience beyond the 5-year minimum

• Minimum 2 years hands-on experience with Informatica (PowerCenter, Integration Services, Workflow Manager, IDMC, TDM)

• Resource must be located in Canada and legally eligible to work in Canada

• Only one resource may be submitted per proponent

Rated / Preferred Qualifications

• Expert-level knowledge of:

o Oracle and SQL Server

o ETL architecture and enterprise data pipelines

o Programming languages: PL/SQL, Python, R

o Unix/Linux/Windows environments and shell scripting

o APIs, algorithms, and data structures

• Extensive experience with:

o Data modeling, business process design, and workflow design

o End-to-end data management lifecycle (requirements → build → support)

o Complex problem-solving in enterprise environments

o Cloud-based data platforms

• Assets:

o Microsoft Certified: Azure Data Engineer Associate

o Healthcare data experience

Affinity Earn:

Know someone who’s great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/

About Affinity:

Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.

For more information on Affinity, please visit www.affinity-group.ca

Job Number: 12883