Job
Description
- 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. - 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.
