Expert (5 Years hands on experience) in Informatica v9.1 or higher
- Expert (5 Years hands on experience) in Oracle database development (SQL,PLSQL, Oracle tools)
- Minimum 3 years Quality Assurance experience
- Expert in Create Data mapping documents to support ETL process
- Extensive experience with database development tools (Oracle, Toad), ETL and integration technologies
- Converting functional specifications into ETL technical specifications and source to target mappings
- Proven hands-on experience in using Informatica components such as Designer, Workflow Manager, Workflow Monitor, Repository Manager, etc
- Hands on experience with database Performance tuning like Oracle, Teradata, MSSQL Server, MySQL, and strong database languages like SQL, PL/SQL, TSQL, Unix Shell,Python and Perl Scripting
- Good Experience in tuning of Informatica mappings and Database scripts and procedures.
- Experience in implementation of BI projects in a large scale enterprise data warehouse environment
- Implement and maintain the database design- Create database objects (tables, indexes, etc.)
- Write database PLSQL Packages, procedures, functions and triggers
- Assist team members (Developers/QA/devops) with database activities
- Tune database queries
- Monitor application related jobs and data replication activities
- Agile projects working Experience