Lead/Principal Engineer Software IT

Clean Harbors Inc. (www.cleanharbors.com) is a NYSE listed US based $6.5 billion company. Clean Harbors was founded in 1980 near Boston by Mr. Alan S. McKim. Everywhere industry meets environment, Clean Harbors is on-site, providing premier environmental, energy and industrial services. Clean Harbors employs a dedicated workforce of 25,000 employees and has over 750 service locations across the U.S., Canada and Mexico. Beyond addressing the environmental needs of its more than 300,000 customers, the Company has been on the front lines of addressing some of the largest emergency response events in North America of the past several decades including the BP Oil Spill in the Gulf of Mexico, the anthrax attacks in New York, the 2015 avian flu outbreak that devastated the poultry industry, Hurricanes Katrina, Rita and Sandy, and the oil pipeline breaks that affected the Yellowstone and Kalamazoo rivers, along with other major chemical releases into the environment.

Job Title: Oracle BI Analytics Lead/Principal Developer

Experience: 8-10 Years

Location: Hyderabad

Working Hours: 12:00pm to 9.00pm

We are seeking an experienced OAC & ODI Lead Developer with 8 to 12 years of experience in Oracle BI, Data Warehousing, Analytics, and ETL development. The ideal candidate will lead the design, development, implementation, and support of Oracle Analytics Cloud (OAC) and Oracle Data Integrator (ODI) solutions while collaborating with business stakeholders and technical teams to deliver scalable analytics and reporting solutions.

• Design, develop, and support ODI interfaces, mappings, packages, procedures, and load plans.
• Build and manage ETL/ELT processes for data warehouse solutions.
• Perform data extraction, transformation, and loading from multiple source systems.
• Monitor and optimize ODI jobs for performance and reliability.
• Handle data quality checks, reconciliation, and error handling processes.
• Design, develop, and maintain OAC dashboards, reports, analyses, and data visualizations.
• Create semantic models, datasets, data flows, and subject areas within OAC.
• Develop and optimize complex analytical reports and KPI dashboards.
• Implement data security, role-based access controls, and governance policies.
• Troubleshoot performance issues and optimize report execution.

• Hands-on experience in Oracle Data Integrator (ODI) 11g/12c/14c.
• Strong experience in Oracle Analytics Cloud (OAC).
• Oracle Autonomous Data Warehouse (ADW)Oracle Cloud Infrastructure (OCI)
• Good understanding of Oracle Database, SQL, and PL/SQL.
• Experience in Data Warehousing Concepts, Star Schema, and Dimensional Modelling. • Expertise in ETL/ELT development and optimization.
• Experience in performance tuning reports, dashboards, and ETL jobs.
• Knowledge of Oracle BI Applications, OBIEE, or OAS is an added advantage.
• OTBI and BI Publisher reporting
• Good to have Knowledge on BICC and ESS jobs scheduling reports
• Strong analytical and problem-solving skills.
• Excellent communication skills