: Informatica Developer

Position: Informatica Developer

Experience: 4-8 Years

Location: [Location]

Employment Type: Full time

Job Summary

We are seeking an experienced Informatica Developer to design, develop, test, and maintain enterprise data integration solutions using Informatica PowerCenter/IICS. The ideal candidate should have strong ETL development experience, data warehousing knowledge, and expertise in database technologies.

Key Responsibilities

- Design, develop, and implement ETL workflows using Informatica PowerCenter or Informatica Intelligent Cloud Services (IICS).
- Analyze business requirements and translate them into technical ETL solutions.
- Create and maintain mappings, mapplets, workflows, worklets, sessions, and transformations.
- Perform data extraction, transformation, and loading from multiple source systems to target databases and data warehouses.
- Optimize ETL jobs for performance, scalability, and reliability.
- Conduct unit testing, integration testing, and support UAT activities.
- Troubleshoot ETL failures, data quality issues, and performance bottlenecks.
- Collaborate with Business Analysts, Data Architects, and Data Engineers to ensure successful project delivery.
- Develop and maintain technical documentation, ETL standards, and best practices.
- Support production deployments and provide post-production support.

Required Skills




- 4+ years of hands-on experience with Informatica PowerCenter and/or Informatica IICS.
- Strong understanding of ETL concepts, Data Integration, and Data Warehousing methodologies.
- Experience with relational databases such as Oracle, SQL Server, PostgreSQL, Snowflake, or Teradata.
- Advanced SQL and query optimization skills.
- Experience in handling large-volume data processing and performance tuning.
- Knowledge of data quality, data governance, and metadata management.
- Familiarity with Unix/Linux shell scripting.
- Experience with version control tools such as Git.
- Strong analytical and problem-solving skills.

Preferred Skills
- Experience with Snowflake, Azure Data Factory, AWS, or Google Cloud Platform.
- Knowledge of Informatica Cloud Data Integration (CDI), CAI, and Mass Ingestion.
- Exposure to Agile/Scrum methodology.
- Experience working in Banking, Insurance, Healthcare, Retail, or Manufacturing domains.
- Informatica certifications will be an added advantage.

Educational Qualification
- Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related field.

Nice-to-Have
- Informatica Cloud (IICS) Certification.
- Experience with Data Lake and Big Data ecosystems.
- Knowledge of Python or Spark for advanced data processing.
- Exposure to CI/CD pipelines and DevOps practices.

📌 Informatica Developer (India)
🏢 Philodesign Technologies
📍 India