ODI Developer

Vue: 107

Jour de mise à jour: 06-05-2024

Localisation: Imphal Manipur

Catégorie: IT - Logiciel

Industrie: IT Services & Consulting

Niveau: Software Developer

Type d’emploi: Full Time, Permanent

Expérience: 4 - 6 years

Loading ...

le contenu du travail

Responsible for design, development, customizations, deployment and post-implementation support for ODI, and ETL solutions
Provide expertise in performing application development, configuration and unit testing of data integration (using ODI, PL/SQL, SQL), and Oracle Business Intelligence (OBIEE) applications.
Work closely with business stakeholders and database administrators to plan, design, develop and implement applications, scripts, procedures and metadata for relational databases.
Responsible for performing analysis, design, development, testing and performance improvements of complex queries based upon the specific needs of USP
Responsible for design development of mappings, process flows, and ETL scripts
Responsible for troubleshooting, debugging, optimizing and performance tuning of data warehouse and ETL(ODI) scripts.
Responsible to develop and maintain documentation for ongoing operational activities
Perform thorough ETL testing, debugging troubleshooting ETL mappings to resolve issues
Perform notifications (email etc) to alert on exceptions and error.
Ready to work in 2nd Shift also flexible hours when needed

Basic Qualifications

Bachelor s degree in computer science or relevant field
4-6 years of experience in design and development of ODI, ETL, and Data Warehouse solutions with data warehousing (ETL/ODI) experience and knowledge of data modeling and ETL design

Expected Skills (Required)

Should have good querying skills on MSSQL database with ability to understand debug PL/SQL procedure
SQL proficiency with experience in constructing/deconstructing complex reports and queries
Experience in performance tuning of mappings
Experience in error handling, testing, debugging, troubleshooting skills and migration of objects
Experience in managing Files, MSSQL DB, XMLs through ODI
Experience in developing Load Plans, Scheduling Jobs
Experience in integrating ODI with multiple Source / Target
Excellent verbal and written communication skills
Skilled problem-solver and detail oriented
Requires ability to work on assigned tasks independently with limited direction
Takes personal responsibility for the quality and timeliness of work and achieves results with minimal oversight
Must be a team player and work well in a deadline-driven environment with multiple priorities.
Data modeling experience using dimensional data modeling, star/snowflake schema, fact and dimension tables, physical and logical data modeling

Loading ...

Cliquez pour postuler pour un candidat gratuit

Loading ...

Loading ...

Loading ...