Line of Service Advisory Industry Sector Not Applicable Specialism Data Analytics AI Management Level Senior Associate Summary At PwC our people in data and analytics focus on leveraging data to drive insights and make informed business decisions They utilise advanced analytics techniques to help clients optimise their operations and achieve their strategic goals In business intelligence at PwC you will focus on leveraging data and analytics to provide strategic insights and drive informed decision-making for clients You will develop and implement creative solutions to optimise business performance and enhance competitive advantage Why PWC At PwC you will be part of a vibrant community of solvers that leads with trust and creates distinctive outcomes for our clients and communities This purpose-led and values-driven work powered by technology in an environment that drives innovation will enable you to make a tangible impact in the real world We reward your contributions support your wellbeing and offer inclusive benefits flexibility programmes and mentorship that will help you thrive in work and life Together we grow learn care collaborate and create a future of infinite experiences for each other Learn more At PwC we believe in providing equal employment opportunities without any discrimination on the grounds of gender ethnic background age disability marital status sexual orientation pregnancy gender identity or expression religion or other beliefs perceived differences and status protected by law We strive to create an environment where each one of our people can bring their true selves and contribute to their personal growth and the firm s growth To enable this we have zero tolerance for any discrimination and harassment based on the above considerations OAC OBIEE - A SA Experience - 4 to 8 years with at least 2 project lifecycles BE BTech MTech - Development experience on OAS OAC DVCS and BICS OBIA or FAW knowledge will be added advantage - Experience on lift shift of OBIEE to OAC - Should have excellent debugging and troubleshooting skills - Should have experience in Metadata management RPD and Analytics - Should have good knowledge on OAC OBIEE security - Experience in customization and configuration of OBIA preferably with Fusion Saas Cloud OBIEE Dashboards Administration - Experience in interacting with the Business Users to analyze the business process and gathering requirements - Experience in sourcing data from Oracle EBS - Experience in basic admin activities of OAC and OAS in Unix and Windows environments like server restarting etc - Experience in Configuration Troubleshooting Tuning of OAC reports Skills and Quals - Metadata management RPD design and OBIEE Admin experience including deployment of RPD Catalog manager Security - Experience in OBIEE Dashboard and Reports Designer and Developer - Experience in basic admin activities in Unix and Windows environments like server restarting etc - Experience in Configuration Troubleshooting Tuning of OBIEE 12C Responsibilities Design develop and maintain data integration processes using Oracle Data Integrator ODI Create and manage ODI mappings packages and scenarios to meet business requirements Perform data extraction transformation and loading ETL processes to ensure data accuracy and consistency Collaborate with cross-functional teams to gather and understand business requirements and translate them into technical specifications Optimize and tune ODI processes for performance and scalability Implement data quality checks and error handling mechanisms in ODI Develop and maintain data warehouse DWH solutions including data modeling schema design and ETL processes Implement and manage multiple data load strategies e g incremental loads full loads based on business requirements and data volumes Write and optimize complex SQL queries for data extraction transformation and reporting Provide technical support and troubleshooting for ODI processes and data warehouse solutions Stay updated with the latest industry trends and best practices in data integration SQL and data warehousing Qualifications - A SA Experience - 4 to 8 years with at least 2 project lifecycles BE BTech MTech Proven experience in designing and developing data integration processes using Oracle Data Integrator ODI Strong knowledge of SQL and experience in writing and optimizing complex SQL queries Experience with data modeling schema design and data warehousing concepts Experience with multiple data load strategies e g incremental loads full loads Experience with scheduling tools and processes for data integration workflows Familiarity with data warehousing best practices and ETL processes Excellent problem-solving and analytical skills JD Scala Object Oriented programming Level Senior Associate preferably Experience of 4 to 7 years who has adequate knowledge Scala s object-oriented programming Requirement Scala code written in the backend is the basis of the finance module reports which are accessed via QuickSight To assess scala code written for Finance module reports figure out the issues and fix the same Preferred skill sets DWH ETL Processes Years of experience required 4 - 7 yrs Education qualification B tech MBA MCA Education if blank degree and or field of study not specified Degrees Field of Study required Bachelor of Technology Master of Business Administration Degrees Field of Study preferred Certifications if blank certifications not specified Required Skills Oracle Data Integrator ODI Structured Query Language SQL Optional Skills ETL Processing Desired Languages If blank desired languages not specified Travel Requirements Not Specified Available for Work Visa Sponsorship No Government Clearance Required No Job Posting End Date