Job Description :
Hi ,
Hope you are doing well.
Job Category: ORACLE
Location:Malden,Massachusetts
Duration: 6 Month(s)
Interview Mode:Telephonic, Skype
End Client: State govt. project
Visa Status:EAD, GC, US Citizen
Description:
Job Role: Oracle Data Integration (ODI) Developer
Qualifications:
Minimum of 4 years Oracle ODI experience.
8+ years overall experience in Data Integration, Data Architecture, Data Modeling, and implementation.
Minimum of 5 years of full lifecycle data warehousing experience.
Implementation of ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets including, Relational Database Management servers (including Oracle RDBMS, flat files (including CSV, Excel, & XML file formats), and web services (SOAP, WS-I Security
Experience with Set up, configuring and administration of ODI according to requirements.
BI knowledge a requirement – 5 years in BI from ETL perspective.
Design experience of the detailed ETL architecture, including agents, scenarios, packages, data mapping, data extractions, transformations and validations. This ETL design and implementation should include stand-alone and Java EE agents, ODI data services, ODI Console, ODI studio, and other appropriate development tools.
Ability to observe steps and ascertain success of step or failure and root cause of step(s
Experience in Master Data Management and Meta Data Management.
Experience in Dimensional Modeling.
Demonstrated ability to communicate the overall customer data architecture to both technical and business constituencies.
Creating Interfaces in order to move data from source to target.
Assist infrastructure personnel in implementing the ODI migration process to migrate the ODI configuration through various development, test, and production environments.
Develop system /integration test plans and scenarios for data loads and extracts.
Manage and monitor production and non-production ETL sessions.
Mentor and transfer ODI technical knowledge and processes to other team and department personnel, as requested.
Desired Experience
Good knowledge of applicable data privacy practices and laws (FERPA
Experience in an education environment a plus.
Experience with Oracle Exadata is a plus.