2.0 - 5.0 years

3 - 12 Lacs

Hyderabad, Telangana, India

On-site

Write and administer ETL jobs to extract data from multiple data sources and load into datamarts. Integrate data from different data sources: databases, csv files, xml files, queues Integrate data for batch, near real-time, real-time latencies. Organize data at different aggregation levels, hierarchies Write complex data transformation logic. Proactively monitor the performance of data jobs and tune the jobs as needed. Make the data integration jobs fault tolerant and scalable. Perform Data quality, data modeling and database tasks as required.

Posted 1 day ago

Apply

ODI Developer Kaygen Consulting

8.0 - 13.0 years

5 - 8 Lacs

Hyderabad, Telangana, India

On-site

EXPERIENCE SUMMARY: * Over 8+ years of work experience in IT in analysis, architecture, designing, developing, implementation, testing. support of Data Warehousing and Business Intelligence using ODI. Good experience in gathering the business requirements and developing jobs/mappings using ODI tool to fetch data from heterogeneous source system like MYSQL DB, ORACLE DB, TEXT files, CSV files, XML files. Experience in creating ODI jobs specially file related jobs (bxt, csv, xml) with complete automation LS starting from file receive to sending success/failure alert Extensive DW knowledge using ODI during setting up master & work repository, data server, physical & logical schema, model, source, target, mapping, package, knowledge module, scenario, variable, sequence, procedure, mapping components (set, split, distinct, join, filter, lookup, expression, aggregate), package tool components, metadata soe table, load plan, exception handling. Good understanding on knowledge modules. Loaded multiple targets using a single mapping in ODI 11g version without split option. Implemented SCD Type 1, SCD Type 2 and CDC. Knowledge in creating source, target, look, expression, aggregate, package tool components. *Development and support of entire ODI landscape.

Posted 3 days ago

Apply

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.