Search Jobs
Search by job, company or skills
Search by job, company or skills
IT/Computers - Hardware & Networking
Intermediate consulting position operating independently with some assistance and guidance to provide quality work products to a project team or customer that comply with Oracle methodologies and practices. Performs standard duties and tasks with some variation to implement Oracle products and technology to meet customer specifications.
3 - 6 years of ETL development experience with minimum 3+ years using Oracle Data Integrator (ODI) for batches implementation.
.Strong understanding of SDLC, OLAP, OLTP, data warehouse, datamart development, fact and dimensional design methodology.
.Experience in database design, relational and dimensional data modelling.
.Should have experience of interacting with customers in understanding business requirements, translating them into ETL specifications and high/low level design documents.
.Strong knowledge of ELT/ETL concepts with hands-on experience working with latest ODI version with various transformations.
.Ability to design and develop ODI mappings, packages, load plans, user functions, variables and sequences.
.Experience working with multiple source/target systems such as Oracle, XML files, flat files, MS SQL Server, etc.
.Experience in invoking web services through ODI, error handling, data migration using ODI.
.Exposure to CDC/Journalizing implementations and customizing knowledge modules as per the requirement.
.Experience of creating PL/SQL packages, procedures, functions, triggers, views, MVs and exception handling for retrieving, manipulating, checking and migrating complex datasets.
.Should be able to tune existing ODI mappings and optmize SQL queries using best suitable technique.
.Experience with shell scripting is mandatory.
.Exposure to scheduling tools like ControlM, Autosys will be an advantage.
.Must have good verbal and written communication skills, strong interpersonal, analytical and problem-solving abilities.
.Ability to work with minimal guidance or supervision in a time critical environment.
.Preferred candidate from a financial industry.
Career Level - IC2
Date Posted: 22/11/2024
Job ID: 101114231
Oracle Corporation is an American multinational computer technology corporation headquartered in Austin, Texas.In 2020, Oracle was the second-largest software company in the world by revenue and market capitalization.The company sells database software and technology (particularly its own brands), cloud engineered systems, and enterprise software products, such as enterprise resource planning (ERP) software, human capital management (HCM) software, customer relationship management (CRM) software (also known as customer experience), enterprise performance management (EPM) software, and supply chain management (SCM) software.
