As a Senior ETL Developer - Oracle, you will be part of a dynamic team dedicated to developing, optimizing, and maintaining ETL programs using Oracle Data Integrator (ODI). You will work on improving performance, troubleshooting issues, and ensuring seamless data integration across multiple environments. This role requires a deep understanding of data warehousing, ETL processes, and Oracle BI tools to support strategic business needs and enhance customer experience.
We are looking for a highly motivated professional who thrives in a collaborative and fast-paced environment. You will be joining a team of skilled individuals committed to innovation, problem-solving, and excellence in data engineering.
Key Responsibilities
- Design End-to-End Solutions. Develop and implement custom data warehouse solutions tailored to business needs using Oracle BI stack, ODI, and SQL.
- Data Warehousing Expertise. Apply best practices in dimensional modeling (Star/Snowflake schemas) and draft High-Level and Low-Level Data Warehouse (DWH) designs.
- Data Lineage & ETL Automation. Prepare data lineage sheets, automate ETL jobs, and implement failure notification mechanisms.
- Performance Optimization. Optimize ODI mappings and SQL queries to enhance performance and efficiency.
- Production Support. Monitor, troubleshoot, and resolve issues in daily ETL load processes across different environments.
- Multi-Database Expertise. Work with Oracle, SQL Server, and other databases, leveraging complex SQL queries for debugging and optimization.
- Business Analytics & Data Integration. Ensure seamless integration of data sources for accurate reporting and analytics.
- Collaboration & Training. Work closely with cross-functional teams, provide training on ETL and DWH concepts, and mentor team members on technical challenges.
Who You Are
- You take initiative and proactively identify areas for improvement.
- You thrive in fast-paced environments and can quickly adapt to new challenges.
- You are a team player who collaborates effectively with different stakeholders.
- You possess strong analytical and troubleshooting skills.
- You communicate complex technical concepts in a clear and concise manner.
Required Qualifications
- 8+ years of experience working with Oracle BI Applications (OBIA) and ODI in a BIAPPS environment.
- Strong understanding of data warehousing concepts, including SCDs, aggregation, hierarchy, partitioning, and materialized views.
- Proven expertise in performance tuning of SQL programs and ODI development.
- Experience in designing and optimizing DWH solutions for complex business needs.
- Ability to review existing ETL processes, suggest improvements, and implement optimizations.
- Excellent troubleshooting skills and experience in debugging SQL queries.
- Hands-on experience with ETL automation, monitoring, and failure recovery.
- Strong communication skills, both written and verbal, for effective collaboration with global teams.
Preferred Qualifications
- Bachelor’s degree in Computer Science, Information Systems, or a related technical field.
- Experience working with other ETL tools apart from ODI.
- Prior experience in business analytics, data governance, and data integration projects.
- Strong interpersonal skills and the ability to coordinate activities across multiple teams.
What Emerson Offers
- Work on cutting-edge data integration projects that drive business transformation.
- Receive competitive compensation and benefits, including comprehensive medical and insurance coverage.
- Be part of an inclusive, diverse, and collaborative work culture that fosters learning and development.
- Have access to ongoing professional development programs to enhance your skills and career growth.
- Enjoy a hybrid work environment, offering flexibility to balance work and personal life.
- Be part of a company that prioritizes employee well-being, innovation, and sustainability.
About Emerson
Emerson is a global leader in automation technology and software, serving critical industries such as life sciences, energy, power, renewables, and manufacturing. With a focus on digital transformation, we help businesses improve their efficiency, sustainability, and operational excellence.
We believe in a diverse and inclusive workplace where all employees have the opportunity to grow and thrive. If you’re passionate about making an impact through technology, we encourage you to join our team and be part of a global community that drives meaningful change.