Data Engineer, ODI Skills - DB Developer

🕒 May 8

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

EY

WebsiteLinkedInAll Job Openings

10,000+ employees

Founded 1989

💸 Finance

Finance • Consulting • Technology

EY is a global professional services firm, widely recognized for providing audit, tax, consulting, and advisory services. It focuses on helping its clients solve complex problems and transform their businesses using data and technology. EY is committed to building a better working world by enhancing trust in financial markets and economies globally. Its services include corporate finance advisory, transaction strategy, technology consulting, and more, catering to sectors such as health, energy, finance, government, and more. EY also emphasizes sustainability and innovation in its solutions.

📋 Description

• Develop ETL processes: ETL control tables, error logging, auditing, data quality controls, etc. • Implement solutions: reuse, parameterization, and workflow design with expertise in the Oracle ODI toolset and Oracle PL/SQL. • Work on data modeling and ETL design. • Configure topology, create objects in Designer, and monitor jobs in Operator. • Work with different types of Knowledge Modules (KM), agents, and related components. • Package components and database operations (aggregate, pivot, union) using ODI mappings. • Implement error handling and automation using ODI. • Develop Load Plans and perform object migrations. • Design and develop complex mappings, process flows, and ETL scripts. • Hands-on experience using and customizing Knowledge Modules (KM). • Perform performance tuning of mappings. • Design unit test cases for ETL and debug mappings. • Expertise in developing Load Plans and scheduling jobs. • Ability to design data quality and reconciliation frameworks using ODI. • Integrate ODI with multiple source systems and targets. • Perform error reprocessing/management using ODI and PL/SQL. • Database development (SQL/PLSQL) for PL/SQL-based applications: creation of packages, procedures, functions, triggers, views, materialized views, and exception handling. • Perform data migration using SQL*Loader and import/export utilities.

🎯 Requirements

• Bachelor's degree in Information Systems, Computer Science, Data Engineering, or a related field. • Advanced/Fluent English - C2. • Experience in ETL development and leading ETL initiatives. • Strong practical experience specifically with Oracle Data Integrator (ODI). • Experience in end-to-end Data Warehouse (DWH) implementations. • Expertise in the Oracle ODI toolset, including customization and use of Knowledge Modules (KM). • Strong Oracle PL/SQL skills and SQL tuning for performance optimization. • Solid knowledge of ETL/ELT concepts, design, coding, debugging, and unit testing. • Experience with ETL scripting, workflow design, and automation within the ODI environment. • Familiarity with Oracle database tools and SQL analysis/tuning tools. • Good verbal and written communication skills in English. • Strong interpersonal, analytical, and problem-solving skills. • Proven ability to work independently and communicate effectively with stakeholders.

🏖️ Benefits

• Meal allowance (Vale Alimentação) • Meal voucher (Vale Refeição) • Transportation allowance (Vale Transporte) • Health insurance • Dental care • Corporate University (training and development) • Wellhub (employee wellness program) • Profit sharing (PLR) • Other educational benefits