Fujitsu Informatica and ETL Lead Developer in Cambridge, Massachusetts

Title: Informatica and ETL Lead Developer

Location: MA-Cambridge

Job Number: FC0066660

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

Qualifications:

As Above

Job: Consulting