Description:
Require a Senior Developer to support the design and implementation of data load processes, data models, 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.
Role Overview
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.
Additional Comments
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
As an equal opportunity employer, ICONMA prides itself on creating an employment environment that supports and encourages the abilities of all persons regardless of race, color, gender, age, sexual orientation, citizenship, or disability.