Informatica and ETL Lead Developer

Fujitsu   •  

Cambridge, MA

Industry: Professional, Scientific & Technical Services


5 - 7 years

Posted 59 days ago

This job is no longer available.


Informatica and ETL Lead Developer
1. Strong data analysis skills with ability to dive into difficult technical issues
2. 6+ years’ experience designing and develop data integration solutions using Informatica PowerCenter
3. Strong experience working with Oracle (11g/12c) RDBMS as DWH database
4. Strong in Oracle SQL and PLSQL
5. Understanding of business data and methodologies, such as SQL, normalized vs. de-normalized, slowly changing dimensions, databases, data optimization, aggregations, dimensional data modeling, big data, data lake
6. Experience with ETL from Oracle EBS or Peoplesoft is highly desired
7. Experience with handling ETL performance issues and buffer size settings for data load
Informatica Upgrade Experience should have a experience where candidate was actively involved in Informatica upgrade
2. Experience of DWH Database Upgrade (eg, 10g to 11g or 11g to 12c)
3. Good Oracle SQL, PLSQL knowledge for ETL
4. Hands on writing of Shell scripts for creating ETL Scripts
5. Should be comfortable with Source code control system like SVN, GIT and Informatica Source code control
6. Strong knowledge of INformatica Performance tuning,
7. Good DWH concepts mapping, designs etc.
8. Good Database concepts knowledge