Job Description
Title: Oracle PL/SQL Developer (2 Positions) - (1 position in Plano and 1 in Charlotte, NC)
Location: Plano, TX /Charlotte ,NC/ Day -1 Onsite (Hybrid 3 days office 2 days remote)
Duration: 12 Months
Pay Rate: $68/hr. on W2 without Benefits
Job ID : Heads up
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.
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. (Must Have)
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