ES
Sr. IDMC / IICS Developer
Epsilon Solutions LTD
🇨🇦 Canada
On-site
Senior
4 weeks ago
- ETL
- Informatica
- SQL
- Oracle
- Unit Testing
- Perl
- Agile
- Jira
- Bitbucket
4 weeks ago
Sr. IDMC / IICS Developer
Toronto, ON (Hybrid)
Full Time
Key Requirements:
* 8–10 years of overall ETL development experience in large IT organizations
* Minimum 5 years of strong hands-on development experience with Informatica PowerCenter and at least 2 years with IICS/IDMC
* Design, develop, and implement ETL solutions using Informatica Intelligent Cloud Services (IICS) and IDMC
* Translate detailed specifications into ETL process design and development
* Analyze, design, develop, test, and document ETL processes following industry best practices
* Strong hands-on experience in SQL with databases such as Oracle and MS SQL
* Develop and optimize complex SQL queries for data processing and reporting
* Build data sources, reports, dashboards, and KPIs to support business needs
* Work with Subject Matter Experts and stakeholders to understand requirements and design data solutions
* Perform unit testing and support SIT/QA and production troubleshooting
* Use scripting languages such as VB, Shell, or Perl to support ETL processes
* Collaborate with cross-functional Agile teams including developers, architects, and business analysts
* Prepare design documentation, review artifacts, and provide training and support to users
* Strong understanding of Agile methodologies and tools such as Jira and Bitbucket
* Excellent communication, client management, and stakeholder engagement skills
* Ability to solve complex problems and deliver high-quality solutions
Eligibility:
* Must be eligible for Reliability Status Clearance (Minimum 5 years residency requirement)
Sr. IDMC / IICS Developer · Epsilon Solutions LTD