RQ10057 | Software Developer, Senior ETL x2
Share
Job Location:
Monthly Salary:
Posted on:
14 hours ago
Vacancies:
1 Vacancy
Job Summary
Software Developer Senior - ETL x2
8 years experience
Opportunity Details
| Client Reference | RQ10057 |
| # of Openings | 2 |
| Start Date | December 15 2025 |
| End Date | March 31 2026 |
| Days for Contract | 73 |
| Extension | 1 time |
| Assignment Type | Hybrid |
| Days in Office | 4 days a week |
| Location | 5700 Yonge StreetToronto ON |
| Cluster | Health Services Cluster |
| Ministry | Ministry of Public and Business Service Delivery and Procurement |
Must Haves
IDMC Designs robust mappings uses reusable transformations parameterization environment configs
Nice to Haves
- N/A
Rated Requirements
Public Sector Experience 5%
- Experience working in the Public Sector and familiarity with I&IT project management processes
IDMC/Cloud Data Integration / Redshift50%
- Build Informatica IDMC ETL processes including mappings workflows sessions reusable components. Apply parameterization environment configs scheduling and failure handling.
- Configuring tuning and monitoring techniques for Amazon Redshift and Redshift ingestion.
- Familiar with AWS services (S3 Athena Lambda Glue Step Functions CloudWatch etc).
Core skills database and domain knowledge35%
- Relational database design and optimization experience.
- Security controls to safeguard sensitive data (PI and PHI).
- Query tunning.
- Dimensional data modelling for data warehousing.
- Advanced SQL and PLSQL (or equivalent).
- Extract/Transform/Load data.
General Skills10%
- Proven troubleshooting and critical thinking skills
- Strong interpersonal skills with ability to work with client stakeholders to understand interpret business requirements and its technical implications.
- Demonstrated ability to present technical solutions to client stakeholders technical staff and to senior management.
- A motivated flexible detail-oriented and creative team player with perseverance excellent organization and multi-tasking abilities and a proven track record for meeting strict deadlines.
Description
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.
If you are interested in this opportunity please use the Apply To This Job button at the top.
NOTE: AI tools may be used during the application process for development formatting and review of resumes and other Applicant materials. Applicant identifiers will be made anonymous.
NOTE: By submitting profile information to MERAK you consent to receive email notifications regarding information updates and communications about subcontracting work opportunities and personalized communication as needed. You are able to revoke this consent at any time through the unsubscribe link or pause notifications if you have accepted an external work opportunity by reaching out to us via email at any time.
Required Experience:
Senior IC
Key Skills
- SQL
- Pentaho
- PL/SQL
- Microsoft SQL Server
- SSIS
- Informatica
- Shell Scripting
- T Sql
- Teradata
- Data Modeling
- Data Warehouse
- Oracle
About Company
Partner with MERAK for smart software solutions tailored to your business. Our tech experts understand your unique needs and deliver results that work.
