Oracle Advanced Engineering-ODI PLSQL-Senior

As an EY-Consulting ODI Staff or Senior, you will be responsible for utilizing your expertise in Data warehousing, Data Integration using ETL tool Oracle Data Integrator (ODI), Oracle SQL, and PL/SQL to help clients bridge the gap between their current state and desired outcome. Your problem-solving skills and ability to diagnose unique client needs will be instrumental in creating blueprints to guide clients towards success. **Key Responsibilities:** - Overall possessing 3-15 years of ETL Lead/developer experience with a minimum of 2-3 years in Oracle Data Integrator (ODI). - Demonstrating a minimum of 2-3 end-to-end DWH implementation experience. - Developing ETL processes including ETL control tables, error logging, auditing, and data quality enhancements with a focus on reusability, parameterization, and workflow design. - Proficiency in the Oracle ODI toolset, Oracle PL/SQL, ODI Master, and work repository. - Expertise in data modeling, ETL design, setting up topology, building objects in Designer, and monitoring Operator. - Designing and developing complex mappings, Process Flows, and ETL scripts, including performance tuning and designing ETL unit test cases. - Hands-on experience with load plans, scheduling jobs, data quality, reconciliation framework, and integrating ODI with multiple Source/Target systems. - Knowledge of SQL/PLSQL database development for PL/SQL based applications, data migration using SQL loader, and SQL tuning and optimization. - Strong understanding of ELT/ETL concepts, partitioning, indexing strategy, and ability to work independently in time-critical environments. - Excellent verbal and written communication skills in English, with strong analytical and problem-solving abilities. - Interacting with customers to understand business requirements, translating them into ETL specifications, and creating high- and low-level design documents. - Experience in Financial services industry preferred. **Qualifications Required:** - BTech/MTech/MCA/MBA Join EY in building a better working world, where data and technology empower diverse teams across 150+ countries to provide trust, assurance, and transformative solutions to complex global challenges.,