Oracle Consultant

Role - Project Techno-FunctionalExperience Required: 6 - 10 yearsRole Name: Data Analyst / Data Engineer with data migration Oracle R12 to Oracle Fusion cloud experience.Job SummaryWe are looking for a Project Techno-Functional consultant with hands-on experience migrating Project Accounting (PPM) data from Oracle EBS R12 to Oracle Fusion Cloud. The role requires a blend of Project Accounting functional knowledge and technical data migration expertise to support the ERP transformation.Key ResponsibilitiesAnalyze and map Project Accounting (PPM) data from Oracle EBS R12 to Oracle Fusion Cloud.Design and build data extraction, transformation, and load (ETL) processes for Project Accounting data.Prepare and validate FBDI templates for loading converted Project Accounting data into Oracle Fusion.Write and optimize SQL/PL-SQL scripts for data extraction, cleansing, and validation.Perform data reconciliation and error resolution across migration cycles (mock loads, UAT, cutover).Work with functional and technical teams to resolve data mapping issues and gaps.Document data mapping specifications, transformation rules, and migration status.Functional KnowledgeOracle EBS and Oracle Fusion ERP - Project Accounting (PPM) expertiseTechnical SkillsData MigrationSQL/PL-SQL scriptingData transformationData Mapping and FBDI data loadingQualifications6-10 years of experience in Oracle EBS/Fusion Project Accounting (PPM) and data migration projects.Prior experience on at least one full-cycle Oracle EBS R12 to Oracle Fusion Cloud migration is preferred.Strong analytical and problem-solving skills with attention to data accuracy.