Software Developer - ETL - Senior x2:
On behalf of our Health Services client, Procom is searching for a Software Developer - ETL - Senior x2 for a contract role. This position is onsite at our client’s Toronto office.
Software Developer - ETL - Senior x2 - Job Description:
The role involves working on a critical project concerning ETL processes using Informatica IDMC. The project includes building and optimizing ETL processes, as well as configuring and monitoring AWS services. This is a new development initiative within the Health Services Cluster.
Software Developer - ETL - Senior x2 - Responsibilities:
Build ETL processes including mappings, workflows, sessions, and reusable components using Informatica IDMC
Apply parameterization, environment configurations, scheduling, failure handling, and restartability in IDMC
Design S3 landing/staging areas for data integration and implement UPSERT/MERGE logic for dimension/fact loads
Configure CloudWatch dashboards/alerts and monitor AWS services such as Redshift
Develop end-to-end data flow diagrams, data masking, and security designs for Cognos \& Redshift
Create data models including conceptual, logical, and physical models (star/snowflake), and Redshift dist/sort keys
Perform data mapping with business rules, transformations, lineage, data quality validations, and exception handling
Software Developer - ETL - Senior x2 - Mandatory Skills:
Expertise in building Informatica IDMC ETL processes
Experience with configuring, tuning, and monitoring Amazon Redshift
Familiarity with AWS services like S3, Athena, Lambda, Glue, Step Functions, CloudWatch
Strong relational database design and optimization experience
Advanced SQL and PLSQL or equivalent
Proven troubleshooting and critical thinking skills
Strong interpersonal skills and ability to present technical solutions
Software Developer - ETL - Senior x2 – Nice-to-Have Skills:
Experience working in the Public Sector
Familiarity with I\&IT project management processes
Security controls to safeguard sensitive data (PI and PHI)
Dimensional data modeling for data warehousing
Experience with data architecture and data flow diagrams
Software Developer - ETL - Senior x2 – Assignment Length:
The contract is until March 2026, with potential for extension.
Software Developer - ETL - Senior x2 - Start Date:
ASAP.
Software Developer - ETL - Senior x2 - Assignment Location:
Toronto, Ontario, Canada. This position is onsite 5 days a week.