
Odi - PLSQL Developer
1 week ago
Your key responsibilities:
- Overall having 3-15 years of ETL Lead / developer experience and a minimum of 2-3 Years experience in Oracle Data Integrator (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.
- Expertise in the Oracle ODI toolset 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 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
- 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.
- Strong 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
-
PLSQL Developer
1 week ago
Pune, Maharashtra, India Sightspectrum Full time ₹ 9,00,000 - ₹ 12,00,000 per yearMandatory Skills : ODI,Oracle PL/SQL,Oracle DB Administration,Dimensional Data Modeling,PL-SQL,QlikView,ANSI-SQLPrimary Skills: Oracle PLSQL Unix Shell scripting AWS RDS DMSSecondary Skills: Snowflake IBM DB2 for LUWLocation: PunePreferred candidate profileMust have 5 years of development experience in SQL Oracle PLSQL UNIX shell scriptingMust have Basic...
-
ODI Developer
3 weeks ago
Gurugram, India Angel and Genie Full timeJob Description :We are looking for a highly skilled ODI Developer with hands-on experience in designing, developing, and maintaining ETL processes using Oracle Data Integrator (ODI) 12c. The ideal candidate will have a strong background in data warehousing, ETL development, and PL/SQL programming, along with a proven track record of delivering...
-
ODI Developer/ Lead
2 weeks ago
Bengaluru, Karnataka, India Oracle Full time ₹ 20,00,000 - ₹ 25,00,000 per yearJob Description:Responsibilities:Minimum 4-5 years hands-on, 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...
-
ODI Developer
1 week ago
Pune, Maharashtra, India IDESLABS PRIVATE LIMITED Full time ₹ 8,00,000 - ₹ 15,00,000 per yearPlease initiate support on the ODI Developer demand :Experience : 5 to 8 yearsODI architecture and data ware housing understanding.Must to have PL SQL exposure Must have experience on customizing ODI IKMs Design, Build ODI complex package Excellent Analysis skills Experience in agile development would be added advantage Performance tuning of ODI jobs Groovy...
-
Odi Developer
3 weeks ago
Gurugram, Chennai, Bengaluru, India Erm Placement Services Full timeJob Description Responsibilities: - Design, develop, and maintain data integration processes using Oracle Data Integrator (ODI). - Create and manage ODI mappings, packages, and scenarios to meet business requirements. - Perform data extraction, transformation, and loading (ETL) processes to ensure data accuracy and consistency. - Collaborate with...
-
Odi Developer
1 week ago
Bengaluru, Chennai, Gurugram, India ERM Placement Services Full time ₹ 15,00,000 - ₹ 20,00,000 per yearExp: 4 - 7 yrsLocation: PAN INDIAResponsibilities:Design, develop, and maintain data integration processes using Oracle Data Integrator (ODI).Create and manage ODI mappings, packages, and scenarios to meet business requirements.Perform data extraction, transformation, and loading (ETL) processes to ensure data accuracy and consistency.Collaborate with...
-
Odi Developer
2 weeks ago
Bengaluru, Hyderabad, Pune, India Inumellas Consultancy Services Full time ₹ 1,04,000 - ₹ 1,30,878 per yearRole - ODI DeveloperExp - 6 to 10 YrsPosition - Permanent FTELoc - Hyderabad, Bangalore, PuneJob DescriptionWe are seeking an experienced and detail-oriented ODI Developer to join our dynamic team. The ideal candidate will have a strong background in Oracle Data Integration and ETL processes, possess excellent problem-solving skills, and demonstrate the...
-
ODI Developer
2 days ago
Bengaluru, Mumbai, Pune, India Oracle Full time ₹ 2,00,000 - ₹ 2,50,000 per yearWe are seeking a highly skilled Senior ODI Developer with strong hands-on experience in SQL, PL/SQL, and Oracle Data Integrator (ODI) projects, particularly on OCI (Oracle Cloud Infrastructure) PaaS or IaaS platforms. The ideal candidate will design, implement, and optimize ETL processes, leveraging cloud-based solutions to meet evolving business needs....
-
ODI Developer
7 days ago
Bengaluru, India Virtusa Full timeODI Developer - CREQ Description Experience in ETL/ELT Process. Experience in Data Integration Patterns. Experience on Oracle Data Integrator(ODI) Including Managing ODI Interfaces and packages. Experience in AWS Service such as Lambda, Step Functions, Amazon S3,,AWS GLUE, AWS Event bridge, IAM Development Experience in Python Development Experience...
-
ODI Developer
7 days ago
Bengaluru, India Virtusa Full timeODI Developer - CREQ Description Experience in ETL/ELT Process. Experience in Data Integration Patterns. Experience on Oracle Data Integrator(ODI) Including Managing ODI Interfaces and packages. Experience in AWS Service such as Lambda, Step Functions, Amazon S3,,AWS GLUE, AWS Event bridge, IAM Development Experience in Python Development Experience...