Oracle Fusion Consultant

Key Responsibilities: Collaborate with business users and analysts to gather and document reporting and analytics requirements. Analyze Oracle ERP modules (e.g., Financials, Supply Chain, HCM) to identify data sources relevant to the reporting needs. Provide Data Warehouse teams with detailed metadata: table names, column names, joins, and relationships. Support dimensional modeling efforts by mapping ERP source data to fact and dimension structures. Work closely with data architects and modelers to ensure business logic and reporting needs are accurately reflected in the data warehouse design. Participate in data validation and testing to ensure data accuracy and integrity. Maintain up-to-date documentation on data mappings and functional specifications. Act as the subject matter expert (SME) for Oracle ERP modules within the data integration project. Assist in data quality improvement and governance initiatives. Required Qualifications: Bachelor's degree in Information Technology, Business, Accounting, or related field. 5+ years of experience as an Oracle Functional Consultant, preferably with exposure to Oracle E-Business Suite or Oracle Fusion. In-depth knowledge of Oracle ERP modules (e.g., GL, AP, AR, PO, INV, OM). Strong understanding of Oracle ERP data structures and ability to extract metadata (tables, columns, joins). Experience working with Data Warehousing projects, especially dimensional modeling (Star/Snowflake schemas). Familiarity with reporting and BI tools such as Oracle BI, Tableau, Power BI, or similar. Strong analytical and documentation skills. Excellent communication and interpersonal skills to work across technical and business teams. Preferred Skills Experience with Oracle SQL or TOAD for querying ERP tables. Exposure to ETL tools Understanding of data governance, master data management, and data quality principles. Previous involvement in Agile/Scrum project environments.