Job Description :
The work is on the integration layer with multiple connection points it gives great exposure to modular architecture, as the industry is trending towards this architecture. Also its Agile so the work will be well planned and the resource will have good work life balance.

FUTURE DUTIES AND RESPONSIBILITIES
Responsibilities:
- Over 5-10 years IT experience in Design ETL solutions and data conversion strategy and solutions for multiple disparate systems using Oracle and Informatica
- Create end-to-end solution for ETL transformational jobs that involve writing Informatica workflows and mappings, and creating database Packages, procedures and functions
- Develop, maintain, and enhance Informatica Mappings, Work-flows, and processes
- Support proper functioning and performance tuning of Informatica platform
- Develop stored procedures and triggers using DB2 database to support ETL jobs
- Work effectively with the DBA teams to ensure that all approved development and deployment procedures are followed
- Provide production support from development teams for existing systems, troubleshoot data and/or system issues
- Identify root causes and resolve data related issues
- Review and optimize query performance
- Writing Test Strategies, Test Plans, Test Cases, and Test Closure document

REQUIRED QUALIFICATIONS TO BE SUCCESSFUL IN THIS ROLE
- 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)
- Expert in Create Data mapping documents to support ETL process
- Extensive experience with database development tools (Oracle, Toad), ETL and integration technologies, Agile projects working experience