Informatica Developer

Inviting applications for the role of Principal Consultant - Informatica

In this role, you will be working as Senior Informatica Developer and responsible for running end to end ETL projects.

Responsibilities

Engage with Client to participate in requirement gathering, Status update on deliverables, UAT and be the key stakeholder in the overall engagement.

Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications.

Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter

Write complex SQL queries with performance tuning and optimization.

Should be able to handle task independently and lead the team

Responsible for unit testing, integration testing and UAT as and when required

Good communication Skills.

Qualifications

Minimum qualifications

B.Tech, BE, MCA
Core Development experience in the stated technology stack

Preferred qualifications

Worked on Informatica, Oracle and Unix Senior Developer

Perform development role in Informatica, Oracle and Unix

DW/BI experience with implementation of ETL solutions using Informatica and Oracle

Proficient with creating Informatica mappings, sessions, workflows, mapplets and hands on Experience on designing CDC, SCD2 implementation.

Should have good knowledge on performance tuning in Informatica and Oracle

Worked with large data sets and proficient using of Analytical functions.

Experienced in running an end to end ETL project interacting with users globally.

Should be able to understand requirements analysis then, build and deliver the solution.

Experience in developing complex ETL solution

Must have experience in writing SQL in Oracle. Should be able to write and understand queries.

Knowledge in Data profiling

Experience in Autosys is preferable but not a must.

Basic Knowledge in Hadoop and DataLake