- Proven experience in SQL development and database management.
- Hands-on experience with Oracle Business Intelligence Publisher (BIP).
- Hands on expertise on SaaS reporting including BI/OTBI, BICC, FRS, Smart View and HCM extracts.
- Fusion knowledge required on at least one of SCM, HCM, Finance.
- Experience in working with large datasets and optimizing query performance.
- Write, optimize, and maintain complex SQL queries, stored procedures, and functions.
- Perform data extraction, transformation, and loading (ETL) processes.
- Troubleshoot and resolve SQL-related issues in a timely manner.
- Design, develop, and maintain BIP reports to meet business needs.
- Customize and enhance existing BIP reports to improve functionality and user experience.
- Integrate BIP reports with other systems and applications as required.
- Ensure reports are optimized for performance and scalability.
- Conduct thorough testing of SQL scripts and BIP reports to ensure accuracy and reliability.
Career Level - IC3