Akkodis is seeking a Senior ETL Software Developer for a contract position with a client located in Toronto, ON. Ideally seeking a professional experienced in Informatica IDMC Designs robust mappings, uses reusable transformations, parameterization, environment configurations. Preference would be someone with the required skills and experience, particularly in large organizations.
Job Title: Senior ETL Software Developer
Location: Toronto, ON (Onsite)
Required Skills:
- 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).
- 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.