ETL / Informatica IDMC Developer
- Location
- Pan India
- Salary
- Not specified
- Company
- Akash pawar
Job description
### Role & Company / Project Overview HIKING-IT is hiring experienced IT professionals for the role of ETL / Informatica IDMC Developer for an exciting permanent opportunity with their client. Immediate joiners are preferred. ### Key Responsibilities & Daily Duties • Strong hands-on work with Informatica PowerCenter and Informatica IDMC/IICS. • Execute end-to-end migration projects from PowerCenter to IDMC. • Leverage Cloud Data Integration (CDI), Mass Ingestion, Cloud Application Integration (CAI), and Data Quality (DQ). • Integrate REST APIs using IDMC/IICS REST V2 Connector or Web Services Connector. • Handle JSON/XML payloads, API authentication, and pagination mechanisms. • Load data accurately into relational databases and modern cloud data warehouses. • Develop SQL scripts and perform query optimization and performance tuning in Oracle and Snowflake. • Utilize UNIX/Linux Shell Scripting for automation and task orchestration. ### Required Qualifications, Skills & Experience • 6+ years of relevant experience in ETL, Informatica PowerCenter, and Informatica IDMC/IICS. • Proven track record in at least one end-to-end migration project from PowerCenter to IDMC. • Deep expertise in Cloud Data Integration (CDI), Mass Ingestion, Cloud Application Integration (CAI), and Data Quality (DQ). • Practical experience in REST API integrations using IDMC/IICS REST V2 or Web Services Connector. • Solid understanding of JSON/XML payloads, API authentication methods, and pagination. • Demonstrated experience loading data into relational databases and cloud data warehouses. • Excellent SQL development, query optimization, and performance tuning skills in Oracle and Snowflake. • Hands-on proficiency with UNIX/Linux Shell Scripting for orchestration and automation. ### Working Hours, Shifts & Location Details • Employment Type: Permanent. • Work Mode: Remote. • Notice Period: Immediate joiners preferred. ### Compensation & Benefits • Not specified. ### Application Instructions • Share your updated resume along with total experience, current location, and notice period.