Job Title: Informatica Powercenter developer

Department: Tribe Core Capabilities (IT Corporate)

About Business line/Function: BNP Paribas Cardif

Position Purpose
The candidate will participate in implementing projects needs and usages on the french ETL Platform based on Informatica Powercenter.

Clients are 99% French speakers only. Requirements should be provided in French but could be translated obviously.

We are seeking a detail-oriented PowerCenter Developer to design, develop, and maintain high-performance ETL processes.

Ability to handle administration tasks and support (but Development skills are the first requirements on that position)

Responsibilities
Direct Responsibilities
- ETL Development: Design and implement complex mappings (using Aggregator, Joiner, Lookup, and Rank transformations) and workflows.
- Performance Optimization:Identifybottlenecks in mappings and tune SQL queries, session partitions, and buffer memory formaximumthroughput.
- Database Management: Write and refine DDL/DML scripts and stored procedures; manage indexing and constraints.




- Production Support: Troubleshoot workflow failures, perform root-cause analysis (RCA), and implement fixesin a timely manner.
- Documentation:Maintaincomprehensive mapping documents and data lineage trackers
- Collaborationwiththe squadtoidentifyand prioritize project requirements
- Participationin agileritualsof the team

Contributing Responsibilities
- N/A

Technical & Behavioral Competencies
- Expertise: 3+ years of experience with Informatica PowerCenter (v10.x preferred).
- SQL Mastery: Advancedproficiencyin SQL (joins, subqueries, analytical functions).
- Unix/Linux: Ability to write shell scripts for file handling and task automation(optional)
- Control/M:knowledge only (no development on Control/M)
- Data Modeling: Solid understanding
- Rigorous
- French,English

Specific Qualifications
- N/A

Technical Skills
Skills Referential (Required knowledge, skills and abilities)
- See above

Behavior

📌 Informatica developer (Tamil Nadu)
🏢 BNP Paribas
📍 Tamil Nadu