Understanding of relational database management system (RDBMS) principles and ability to analyze the data using Structured query languages. Ability to extract and analyze the data using SQL.
- Oracle, PL/SQL, Informatica, Basic Python programming for automation.
- Working knowledge & Experience in developing solutions and maintaining the system using above skills.
- Development, Enhancement, Testing, Release & Deployment, Monitoring and Troubleshooting.
- Experience in Oracle with working knowledge of writing stored procedures, views etc.
- Experience in Informatica PowerCenter with working knowledge of creating workflows, debugging and deployment.
- Working experience with Data warehousing projects development including Database Design, Data Modelling, Database Development & Maintenance.
- Strong fundamentals in Data warehousing and BI concepts, good knowledge of Dimensional Modelling Concepts