Location:

Remote / Hybrid / Onsite (As per project requirement)

Experience:

6+ Years

Employment Type:

Contract

Job Summary

We are looking for an experienced
Informatica PowerCenter / IICS Consultant

with robust expertise in designing, developing, and supporting enterprise ETL and cloud data integration solutions. The ideal candidate should have hands-on experience with
Informatica PowerCenter

,
Informatica Intelligent Cloud Services (IICS)

, SQL, and data warehousing concepts, along with experience integrating data across multiple source and target systems.

Key Responsibilities
- Design, develop, and maintain ETL workflows using Informatica PowerCenter and IICS.
- Build and support data integration pipelines for cloud and on-premises applications.
- Develop mappings, workflows, sessions, taskflows, and reusable transformations.
- Perform data extraction, transformation, and loading (ETL/ELT) from multiple data sources.
- Optimize ETL jobs for performance, scalability, and reliability.




- Work with business and technical teams to gather requirements and translate them into technical solutions.
- Troubleshoot production issues and provide timely resolution.
- Implement data validation, error handling, and data quality checks.
- Support migration of PowerCenter jobs to IICS where applicable.
- Prepare technical documentation and follow development best practices.

Required Skills
- 5+ years of experience in Informatica PowerCenter development.
- Hands-on experience with Informatica Intelligent Cloud Services (IICS).
- Strong knowledge of ETL development and data integration concepts.
- Expertise in SQL and relational databases (Oracle, SQL Server, PostgreSQL, MySQL, etc.).
- Experience with Data Warehousing concepts (Star Schema, Snowflake Schema, Facts & Dimensions).
- Hands-on experience with:
- Informatica PowerCenter
- IICS Data Integration
- Mapping Designer
- Workflow Manager
- Taskflows
- Cloud Data Integration
- Parameter Files
- Error Handling & Reco

📌 Informatica Developer (India)
🏢 Hawk Sense Business Solutions(formerly known as Hawk Sense Security Systems
📍 India