21 Aug
|
Important Company of the Sector
|
Bengaluru
21 Aug
Important Company of the Sector
Bengaluru
We are searching for a resourceful ODI Developer to join our amazing team at Oracle in Bangalore.
Growing your career as a Full Time ODI Developer is an amazing opportunity to develop relevant skills.
If you are strong in persuasion, teamwork and have the right experience for the job, then apply for the position of ODI Developer at Oracle today!
Analyze, design develop, troubleshoot and debug software programs for commercial or end user applications. Writes code, completes programming and performs testing and debugging of applications.
As a member of the software engineering division, you will perform detailed design based on provided high level design specifications. Assist in system planning, scheduling and implementation. Build enhancements (including new product features) and resolve bugs. Build and execute unit test and unit test plans. Review integration and regression test plans created by QA. Interact with QA and porting engineering about problems in the code.
Duties and tasks are standard with some variation displays understanding of roles, processes and procedures. Performs moderately complex problem solving with assistance and guidance in understanding and applying company policies and processes. BS degree or equivalent experience relevant to functional area. 1 year of software engineering or related experience.
Responsibilities displayed in the job posting
- Minimum 4-5 years hands on with end to end DWH Implementation experience using ODI.
- Should have experience in developing ETL processes - ETL control tables, error logging, auditing, data quality, etc.
Should be able to implement reusability, parameterization, workflow design, etc.
- Expertise in the Oracle ODI tool set and Oracle PL/SQL,ODI
- knowledge of ODI Master and work repository
- Knowledge of data modelling and ETL design
- Setting up topology, building objects in Designer, Monitoring Operator, different type of KMs, Agents etc
- Packaging components, database operations like Aggregate pivot, union etc.
- using ODI mappings, error handling, automation using ODI, Load plans, Migration of Objects
- Design and develop complex mappings, Process Flows and ETL scripts
- Must be well versed and hands-on in using and customizing Knowledge Modules (KM)
- Experience of performance tuning of mappings
- Ability to design ETL unit test cases and debug ETL Mappings
- Expertise in developing Load Plans, Scheduling Jobs
- Ability to design data quality and reconciliation framework using ODI
- Integrate ODI with multiple Source / Target
- Experience on Error recycling / management using ODI,PL/SQL
- Expertise in database development (SQL/ PLSQL) for PL/SQL based applications.
- Experience of creating PL/SQL packages, procedures, Functions , Triggers, views, Mat Views and exception handling for retrieving, manipulating,
checking and migrating complex datasets in oracle
- Experience in Data Migration using Sql loader, import/export
- Experience in SQL tuning and optimization using explain plan and Sql trace files.
- Solid knowledge of ELT/ETL concepts, design and coding
- Partitioning and Indexing strategy for optimal performance
- Must have Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities.
- Should have experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High and Low level design documents.
- Experience in understanding complex source system data structures preferably in Financial services (preferred) Industry
- Ability to work with minimal guidance or supervision in a time critical environment.
- Work with Oracle's world class technology to develop, implement, and support Oracle's global infrastructure.
- As a member of the IT organization, assist with the design, development, modifications, debugging, and evaluation of programs for use in internal systems within a specific function area.
- Duties and tasks are standard with some variation. Completes own role largely independently within defined policies and procedures. BS or equivalent experience in programming on enterprise or department servers or systems.
Benefits of working as a ODI Developer in Bangalore:
● Excellent benefits
● Opportunities to grow
● Competitive salary
📌 ODI Developer - Urgent Position (Bengaluru)
🏢 Important Company of the Sector
📍 Bengaluru