Senior Oracle Data Integrator, SQL, PLSQL

🔥 41 minutes ago

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New 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

🏥 Healthcare

⚖️ Legal

📣 Marketing

Healthcare • Legal • Marketing

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

• Design, develop, and maintain ETL/ELT workflows using Oracle Data Integrator (ODI) • Create, optimize, and troubleshoot PL/SQL packages, procedures, functions, triggers, and complex SQL queries • Develop and support data integration, data migration, and data transformation processes • Perform performance tuning of ODI interfaces, mappings, and Oracle database objects • Analyze business requirements and translate them into technical specifications and ETL designs • Monitor and resolve production issues, ensuring data accuracy and timely delivery • Implement data quality checks, validation rules, and error-handling mechanisms • Collaborate with business analysts, data architects, and stakeholders during project delivery • Participate in code reviews, testing, deployment, and documentation activities • Ensure adherence to data governance, security, and development standards

🎯 Requirements

• Strong hands-on experience with Oracle Data Integrator (ODI) 12c/14c • Expertise in Oracle Database, PL/SQL programming, and SQL performance tuning • Experience in designing and developing ETL/ELT solutions and data warehousing concepts • Good understanding of dimensional modelling, star/snowflake schemas, and data integration best practices • Experience with Unix/Linux shell scripting and job scheduling tools • Strong analytical, problem-solving, and troubleshooting skills • Ability to work independently and manage multiple priorities in a fast-paced environment • Excellent communication and stakeholder management skills • Knowledge of Agile/Scrum methodologies is an advantage

🏖️ Benefits

• Health insurance • Retirement plans • Paid time off • Flexible work arrangements • Professional development • Cutting-edge learning opportunities