Software Engineer -?IDMC ETL

Overview

On Site
BASED ON EXPERIENCE
Contract - Independent
Contract - W2
Contract - 3+ mo(s)

Skills

Health Care
Workflow
Scheduling
Management
Dashboard
Data-flow Diagrams
Data Masking
IBM Cognos Analytics
Snow Flake Schema
Distribution
Business Rules
Data Quality
Knowledge Transfer
Documentation
Public Sector
IT Project Management
Informatica
Extract
Transform
Load
Amazon Redshift
Amazon Web Services
Amazon S3
Step-Functions
Database Design
Optimization
Security Controls
SQL
PL/SQL
Data Extraction
Critical Thinking
Attention To Detail
Data Integration
Genetics
SANS
Swift
Sourcing
Recruiting
ARM
Network
Vendor Management
Payroll
Process Improvement

Job Details

Job Title: Software Engineer - IDMC ETL
Location: Toronto, ON, CAN (On-Site)
Duration: 73 Days (Possible Extension)
Client: Public Healthcare Sector
Pay Rate: C$70-C$80/hr

Join our dynamic team as a Software Developer specializing in ETL processes, where you'll play a key role in modernizing and enhancing critical health services applications. This is a unique opportunity to work in Toronto, ON, a vibrant city known for its diverse culture and thriving tech industry.

Responsibilities

  • Develop ETL processes using Informatica IDMC, including building mappings, workflows, sessions, and reusable components. Implement parameterization, environment configurations, scheduling, failure handling, and restartability.
  • Design and manage AWS/Redshift data ingestion and transformation processes. Create S3 landing and staging areas for data integration and implement UPSERT/MERGE logic for dimension and fact loads.
  • Configure CloudWatch dashboards and alerts for effective monitoring.
  • Design end-to-end data flow diagrams, ensuring data masking and PHI handling, and implement row/column-level security for Cognos and Redshift.
  • Develop data models, including conceptual, logical, and physical models (star/snowflake), and optimize Redshift distribution and sort keys.
  • Create detailed data mappings with business rules, transformations, lineage, data quality validations, and exception handling.
  • Provide knowledge transfer to team members, including preparing detailed guides or documentation as required.
  • Complete any additional deliverables as assigned by the Project/Resource Manager.

Skills and Experience

  • Demonstrated experience with public sector projects and familiarity with I&IT project management processes.
  • Proficiency in building Informatica IDMC ETL processes and configuring, tuning, and monitoring Amazon Redshift.
  • Strong knowledge of AWS services, including S3, Athena, Lambda, Glue, Step Functions, and CloudWatch.
  • Expertise in relational database design, optimization, and security controls for sensitive data.
  • Advanced skills in SQL and PLSQL (or equivalent) for data extraction, transformation, and loading.
  • Excellent troubleshooting, critical thinking, and interpersonal skills, with the ability to present technical solutions to diverse stakeholders.
  • Proven track record of meeting strict deadlines and working effectively in a team environment.

This hybrid position requires onsite presence in Toronto, ON, four days per week, with the flexibility to work remotely one day per week. If you are a motivated, detail-oriented professional with a passion for data integration and transformation, we encourage you to apply.

If this opportunity matches your experience and career goals, please share your most updated resume for consideration.

As a certified minority-owned business, Pride Global and its affiliates - including Russell Tobin, Pride Health, and Pride Now - are committed to creating a diverse environment and are proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, pregnancy, disability, age, veteran status, or other characteristics.

Russell Tobin is a leading minority-owned professional and technical recruitment and staffing advisory organization. We are comprised of specialized practices focusing on a variety of skill sets and industries. Having a depth and breadth of industry expertise, our subject matter experts are able to provide tailored and swift sourcing solutions to fulfill client hiring needs. In other words, we connect top talent with companies. We are the staffing arm of the Pride Global network, a minority-owned integrated human capital solutions firm, with additional offerings in vendor management, payroll programs, and business process optimization.

#LI-AJ1

#RTA

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.