Odi Developer Job In Siera It Services Private Limited In Bengaluru / Bangalore

Title: ODI Developer Experience: 5 to 10 Notice period : Immediate to 15 Days Location: Bangalore Roles and Responsibilities 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 3-4 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 Exepcted 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, XML's 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 Able to work in 2nd Shift & also flexible hours when needed

Odi Developer With Five Years Of Experience

Siera It Services Private Limited is looking for Any Graduate / Post Graduate profile candidates.