RQ10057 - Software Developer - ETL - Senior
Job Description
Job Description
Job Description
Description:
- 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.
Requirements
Experience and Skill Set Requirements:
Must Haves:
- IDMC Designs robust mappings, uses reusable transformations, parameterization, environment configs;
Skill Set Requirements:
Public Sector Experience:
- Experience working in the Public Sector and familiarity with I&IT project management processes
IDMC/Cloud Data Integration / Redshift:
- 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 knowledge:
- 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 Skills:
- 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.
How to Apply
Ready to start your career as a RQ10057 - Software Developer - ETL - Senior at Maarut Inc?
- Click the "Apply Now" button below.
- Review the safety warning in the modal.
- You will be redirected to the employer's official portal to complete your application.
- Ensure your resume and cover letter are tailored to the job description using our AI tools.
Frequently Asked Questions
Who is hiring?▼
This role is with Maarut Inc in East York.
Is this a remote position?▼
This appears to be an on-site role in East York.
What is the hiring process?▼
After you click "Apply Now", you will be redirected to the employer's official site to submit your resume. You can typically expect to hear back within 1-2 weeks if shortlisted.
How can I improve my application?▼
Tailor your resume to the specific job description. You can use our free Resume Analyzer to see how well you match the requirements.
What skills are needed?▼
Refer to the "Job Description" section above for a detailed list of required and preferred qualifications.