Job Description :
Look for someone with experience in Jenkins/devops or have the motivation to work on devops .
1. Strong knowledge on Informatica Power center skill
2. Should be good in Complex mapping design, Mapplet design, workflow design & scheduling, Session management
3. Should have knowledge on various transformation used in Informatica like - Joiner, Normalizer, Lookup, Filter, Router, Custom transformation etc.
4. Should have hands-on knowledge to load data in Star Schema
5. Should have experience in performance improvement and partitioning concepts
6. Sound knowledge and experience in database (Oracle/SQL Server
7. Should have experience and knowledge of creating and updating different types of database objects like Index, views, functions, partitioning etc.
8. Candidate should have good knowledge of PL/SQL programing
9. Should have hands on knowledge of different type of Join used in SQL writing
10. Should have knowledge of Query optimization
11. Knowledge and hands on of Unix commands and Shell Scripting
12. Knowledge of relational and dimensional database structures,