Job Description :
Knowledge and Skills Required for the position:
1. Data warehouse/data marts using Kimball & Inmon methodologies
2. Informatica PowerCenter V10.1
3. SAP Business Objects universe and report design/development - V 4.1
4. Crystal Reports
5. Infoburst
6. Oracle, DB2 and SQL Server
7. Complex SQL development
8. Dimensional Data Modeling - Star Schemas
9. Slowly Changing Dimensions
10. Requirements gathering and documentation
11. Test plan development and testing execution
12. Project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, support
13. Excellent written and oral communications
14. Independent worker
Knowledge and experience using Informatica Data Validation Option (DVO) and Informatica Test Data Management (Data Masking) is a plus
Required Must Have DW & BI Knowledge areas:
Informatica PowerCenter - ETL (8+ years’ experience):
Data warehouse design
Data warehouse development
SAP Business Objects (8+ years’ experience):
SAP Business Objects Universe design and development
SAP Business Objects report design and development
Database Knowledge (8+ years’ experience):
DB2
ORACLE
SQL Server
Complex SQL statements