Do you have experience in IDMC Designs robust mappings, uses reusable transformations, parameterization, environment configs? If so, this would be a great opportunity for you!
Our client is looking for a Senior Software Developer ETL for a 3 month contract in North York.
This is an onsite role 8:00 AM and 5:00 PM.
...
Advantages
• Earn a competitive rate within the industry.
• Location: work 7.25 hours per calendar day between the standard wording hours of 8:00 AM and 5:00 PM (excluding lunch breaks) every Monday to Friday.
• Potential for extension.
Responsibilities
• Informatica IDMC ETL Development: Build ETL processes including mappings, workflows, sessions, reusable components. Apply parameterization, environment configs, scheduling, failure handling, and restartability in IDMC.
• AWS/Redshift Ingestion & Transform: design S3 landing/staging areas for data integration. Implement UPSERT/MERGE logic for dimension/fact loads. Configure CloudWatch dashboards/alerts.
• Data architecture: end-to-end data flow diagrams; data masking/PHI handling; row/column-level security design for Cognos & Redshift.
• Data modeling: conceptual/logical/physical models (star/snowflake), Redshift dist/sort keys.
• Data mapping: field-level mappings with business rules, transformations, lineage, data quality validations, and exception handling.
• Any other deliverables as assigned by the Project/Resource Manager.
• Knowledge transfer to HSC staff in the form of a detailed guide or as per project requirements..
Qualifications
MUST HAVES:
• IDMC Designs robust mappings, uses reusable transformations, parameterization, environment configs.
Summary
If you are interested in the Senior Software Developer ETL role in North York, please apply online at www.randstad.ca. Qualified candidates will be contacted.
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more
Do you have experience in IDMC Designs robust mappings, uses reusable transformations, parameterization, environment configs? If so, this would be a great opportunity for you!
Our client is looking for a Senior Software Developer ETL for a 3 month contract in North York.
This is an onsite role 8:00 AM and 5:00 PM.
Advantages
• Earn a competitive rate within the industry.
• Location: work 7.25 hours per calendar day between the standard wording hours of 8:00 AM and 5:00 PM (excluding lunch breaks) every Monday to Friday.
• Potential for extension.
Responsibilities
• Informatica IDMC ETL Development: Build ETL processes including mappings, workflows, sessions, reusable components. Apply parameterization, environment configs, scheduling, failure handling, and restartability in IDMC.
• AWS/Redshift Ingestion & Transform: design S3 landing/staging areas for data integration. Implement UPSERT/MERGE logic for dimension/fact loads. Configure CloudWatch dashboards/alerts.
• Data architecture: end-to-end data flow diagrams; data masking/PHI handling; row/column-level security design for Cognos & Redshift.
...
• Data modeling: conceptual/logical/physical models (star/snowflake), Redshift dist/sort keys.
• Data mapping: field-level mappings with business rules, transformations, lineage, data quality validations, and exception handling.
• Any other deliverables as assigned by the Project/Resource Manager.
• Knowledge transfer to HSC staff in the form of a detailed guide or as per project requirements..
Qualifications
MUST HAVES:
• IDMC Designs robust mappings, uses reusable transformations, parameterization, environment configs.
Summary
If you are interested in the Senior Software Developer ETL role in North York, please apply online at www.randstad.ca. Qualified candidates will be contacted.
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more