Informatica Developer

About Company

Papigen is a fast-growing global technology services company, delivering innovative digital solutions through deep industry experience and cutting-edge expertise. We specialize in technology transformation, enterprise modernization, and dynamic areas like Cloud, Big Data, Java, React, DevOps, and more. Our client-centric approach combines consulting, engineering, and data science to help businesses evolve and scale efficiently.

About The Role

We are seeking an experienced Informatica Developer to join our data integration and analytics team. The ideal candidate will have strong expertise in Informatica PowerCenter and Oracle PL / SQL , with hands-on experience designing, developing, and supporting complex ETL solutions. This role will play a key part in ensuring high-quality data processing, integration, and delivery across business systems.

Key Responsibilities

• Collaborate with business analysts to understand and translate requirements into robust ETL solutions.
• Design, develop, and optimize ETL mappings, mapplets, workflows, and sessions using Informatica PowerCenter (v10.5.3).
• Estimate development efforts and support project planning and documentation.
• Support system and user acceptance testing (UAT), troubleshooting issues, and implementing fixes.
• Develop Informatica-Oracle based data warehouse solutions with efficient data loading and transformation strategies.
• Ensure compliance with data warehousing standards and best practices, including error handling, recovery, and reconciliation.
• Write efficient Oracle PL / SQL scripts, stored procedures, and triggers to support ETL processes.
• Create and maintain technical documentation, including data flow diagrams and design specifications.
• Collaborate with cross-functional teams and participate in Agile / Scrum ceremonies where applicable.

Required Skills & Experience

Preferred Skills (Nice To Have)

Skills : pl / sql,shell scripting,sql developer,sql navigator,extract, transform, load (etl),unix,toad,oracle pl / sql,data warehousing,informatica powercenter,powercenter,sap data integration

Skills Required

Sql Navigator, Oracle Pl Sql, Toad, Data Warehousing, Informatica Powercenter, Unix Shell Scripting, Sql Developer, Etl