Database Developer

Require an experienced Developer to support the design and implementation of data load and transformation processes, workflow mappings, data analytics and / or end-user reporting, per project scope. Individual contributor role, working as part of Agile scrum team on a Pega BPM platform, with underlying Oracle database.

Develop mappings using needed transformation in informatica tool according to technical specifications.

Good hands-on experience in Transformations like joiner, aggregation, filter, lookup, expression, and update strategy.

Effectively use informatica parameter file for defining mapping variables and relational databases.

Develop Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.

Design mappings to load the data from one server to another server using informatica tool.

Skillset Details

Required Skills and Experience we are Looking For :

• 7 + years' experience with DB ETL Development tools like PL / SQL, Informatica, Data Warehouse. Hands on shell scripting experience. Unix / Linux experience.
• Strong analytical, troubleshooting, and problem-solving skills.
• Strong knowledge of data management concepts, including database structure, and proficiency with Oracle SQL and other standard database query tools.
• Experience in data analysis, data mapping techniques.
• Work experience with Business Intelligence (data architecture, entity relationship planning, dimensional modeling, ETL, OLAP, analytical reporting) preferred
• Solid background in ETL Informatica and database development (Oracle / SQL Server)
• Experience in Trading / Banking technology will be an added plus
• Experience in Compliance / Independent Testing area will be an added plus