We found 163 jobs matching to your search

Advance Search

Skills

Locations

Experience

Job Description

Education: B.E./B.Tech/M.C.A./M.Sc (CS) • 6+ years ETL Lead / developer experience and a minimum of 3-4 Years’ experience in Oracle Data Integrator (ODI) • Expertise in the Oracle ODI toolset and Oracle PL/SQL, ODI • Minimum 2-3 end to end DWH Implementation experience. • 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. • knowledge of ODI Master and work repository • Knowledge of data modelling and ETL design • Design and develop complex mappings, Process Flows and ETL scripts • Must be well versed and hands-on in using and customizing Knowledge Modules (KM) • Setting up topology, building objects in Designer, Monitoring Operator, different type of KM’s, 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 • Integrate ODI with multiple Source / Target • Experience in Data Migration using SQL loader, import/export Consulting Requirements • 6-10 years of relevant consulting, industry or technology experience • Proven experience assessing client’s workloads and technology landscape for Cloud suitability • Experience in defining new architectures and ability to drive project from architecture standpoint • Ability to quickly establish credibility and trustworthiness with key stakeholders in client organization. • Strong problem solving and troubleshooting skills • Strong communicator • Willingness to travel in case of project requirement Preferred • Experience in Oracle BI Apps • Exposure to one or more of the following: Python, R or UNIX shell scripting. • Expertise in database development (SQL/ PLSQL) for PL/SQL based applications. • Experience in designing and developing Oracle object such as Tables, Views, Indexes, Partitions, Stored Procedures & Functions in PL/SQL, Packages, Materialized Views and Analytical functions • Working knowledge of GIT or similar source code control system • Experience of creating PL/SQL packages, procedures, Functions, Triggers, views, and exception handling for retrieving, manipulating, checking and migrating complex datasets in oracle • Experience in SQL tuning and optimization using explain plan and SQL trace files • Partitioning and Indexing strategy for optimal performance • Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities. • Experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High- and Low-level design documents • Systematic problem-solving approach, coupled with strong communication skills • Ability to debug and optimize code and automate routine tasks. • Experience writing scripts in one or more languages such as Python, UNIX Scripting and/or similar. • Experience working with technical customers

Responsibilities

Education: B.E./B.Tech/M.C.A./M.Sc (CS) • 6+ years ETL Lead / developer experience and a minimum of 3-4 Years’ experience in Oracle Data Integrator (ODI) • Expertise in the Oracle ODI toolset and Oracle PL/SQL, ODI • Minimum 2-3 end to end DWH Implementation experience. • 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. • knowledge of ODI Master and work repository • Knowledge of data modelling and ETL design • Design and develop complex mappings, Process Flows and ETL scripts • Must be well versed and hands-on in using and customizing Knowledge Modules (KM) • Setting up topology, building objects in Designer, Monitoring Operator, different type of KM’s, 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 • Integrate ODI with multiple Source / Target • Experience in Data Migration using SQL loader, import/export Consulting Requirements • 6-10 years of relevant consulting, industry or technology experience • Proven experience assessing client’s workloads and technology landscape for Cloud suitability • Experience in defining new architectures and ability to drive project from architecture standpoint • Ability to quickly establish credibility and trustworthiness with key stakeholders in client organization. • Strong problem solving and troubleshooting skills • Strong communicator • Willingness to travel in case of project requirement Preferred • Experience in Oracle BI Apps • Exposure to one or more of the following: Python, R or UNIX shell scripting. • Expertise in database development (SQL/ PLSQL) for PL/SQL based applications. • Experience in designing and developing Oracle object such as Tables, Views, Indexes, Partitions, Stored Procedures & Functions in PL/SQL, Packages, Materialized Views and Analytical functions • Working knowledge of GIT or similar source code control system • Experience of creating PL/SQL packages, procedures, Functions, Triggers, views, and exception handling for retrieving, manipulating, checking and migrating complex datasets in oracle • Experience in SQL tuning and optimization using explain plan and SQL trace files • Partitioning and Indexing strategy for optimal performance • Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities. • Experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High- and Low-level design documents • Systematic problem-solving approach, coupled with strong communication skills • Ability to debug and optimize code and automate routine tasks. • Experience writing scripts in one or more languages such as Python, UNIX Scripting and/or similar. • Experience working with technical customers
  • Salary : As per industry standard.
  • Industry :IT-Software / Software Services
  • Functional Area : IT Software - Application Programming , Maintenance
  • Role Category :Programming & Design
  • Role :Oracle _ Data Integrator (ODI)