Harish Bethapudi
San Diego,CA
Summary
Results-driven Data Engineering and MDM Professional with 8+ years of experience building scalable data solutions and integrating complex enterprise systems. Proven expertise in Master Data Management, Oracle EBS, and Informatica 360 to deliver trusted data for Finance, HR, and Supply Chain domains. Skilled at bridging business and technical teams, defining requirements, and delivering high-quality, governed master data solutions. Adept at data pipeline engineering, cloud integration, and process optimization, with a strong background in AWS, Snowflake, Databricks, and Oracle ERP.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Data Engineer / MDM Specialist
Peraton
06.2019 - Current
- Led end-to-end implementation of Informatica 360 MDM for Customer, Product, and Supplier domains, delivering centralized golden records to improve enterprise-wide data consistency and reporting accuracy.
- Designed and executed match and merge rules, survivorship logic, and hierarchy management for de-duplication and standardized master data relationships.
- Built bi-directional integrations between Oracle EBS 12.2.10 and Informatica 360 using AWS Glue pipelines, REST APIs, and Databricks workflows to enable near real-time synchronization of master data.
- Migrated legacy data pipelines from Oracle Data Integrator (ODI) and Informatica IDMC into a modern, cloud-native data architecture using AWS Glue and Databricks Delta tables, reducing maintenance costs by 40%.
- Developed real-time data ingestion frameworks for high-volume master data streams using AWS Kinesis, improving update latency and ensuring accurate downstream reporting.
- Implemented data quality checks, validation rules, and stewardship workflows, resulting in a 30% increase in data accuracy and a 25% reduction in duplicate customer records.
- Collaborated with finance, supply chain, and compliance teams to design governance workflows for supplier onboarding, product enrichment, and cost center approvals.
- Partnered with business teams to define data governance policies and approval workflows, improving compliance audit readiness and reducing manual reconciliation by 40%.
- Developed data lineage documentation, BRDs, and FRDs to track master data flow from source systems through MDM and downstream analytics tools.
- Conducted UAT sessions and designed comprehensive test plans to validate MDM rules, workflows, and dashboards with business users.
- Collaborated with network security and cloud teams to implement role-based access controls (RBAC) and ensure regulatory compliance with PII handling and audit trail requirements.
- Streamlined data stewardship processes, improving operational efficiency and enabling faster master data change approvals by 35%.
- Technologies and Tools: AWS-S3, Lambda, EMR, Glue, Redshift, Athena, AWS Managed Airflow (Apache Airflow), Spark
ETL DEVELOPER
Parkview health
09.2018 - 05.2019
- Interact with Business Users and gather report specifications as well as business process to deliver better robust reporting solutions on a day-to-day basis
- Provide End-End Support, Starting with Data Extraction from Source(PeopleSoft/ EBS/Kronos through ODI) schedulers for daily loads, Data loading to Analytical tables in OBAW (Oracle Business Analytics Warehouse) & Reports build on top of tables in OBAW(OBIEE).
- Develop ODI Interfaces to implement Business Logic with ODI Graphical (Designer, Topology Manager, Operator, and Security Manager) & Knowledge modules (Reverse-engineering, Journalizing, Loading, Check, Integration and Service).
- Customize Oracle Data Integrator (ODI) mappings at the senior level carrying out a wide variety of the most advanced duties involving extracting, transforming, loading.
- Data analysis for creating ETL Mappings and associated artifacts using ODI.
- Optimized existing ETL jobs with improved performance by using appropriate transformations like Lookup, Joiners, Aggregator.
- Optimize ETL processes for performance and scalability, including tuning SQL queries, optimizing data loading strategies, and implementing parallel processing techniques.
- Collaborate with cross-functional teams including data architects, database administrators, and software developers to support data integration initiatives and resolve dependencies.
- Develop PL/SQL Procedures to implement an alternative approach for soft deletes in data warehouse.
- Technologies and Tools: Oracle BI Applications 11.1.1.10.2(Financial analytics, HR analytics), Oracle Data Integrator 11.1.1.9.0, 12C, Oracle Database 12c Enterprise Edition Release 12.1.0.2.0, PL/SQL, SQL Developer, EBSR12.1.3, PSFT 9.2, REH Linux 7
ORACLE REPORT DEVELOPER
Diligent Soft Tech India Pvt Ltd
07.2014 - 08.2015
- Interacted with Business Analysts, and Data Modelers to understand the Analytics report requirements.
- Created Reports using different Analytics Views (Pivot Table, Chart, and Table) like Drill Down, and Pivot Reports using Column Filters and Prompts to filter the request in Answers.
- Developed various custom reports/Ad-hoc Reports for querying and Filters and prompts.
- Configured the Dashboard and Saved requests in Answers for drill-down features.
- Worked with the Security settings in Oracle Business Administration Tool to set up users, groups, access privileges.
- Developed filters, calculations, prompts, and conditions, for various reports.
- Extensively used Dashboard, Pages, Sections, Add Column, Dashboard Prompts including View Selector, Column Selector, Pivot Tables, Charts, Presentation Variables, Permissions on Shared Folders via Catalog Manager etc.
- Participated in weekly team meetings and reviews meetings.
- Co-ordinates with QA team to test and validate the reporting system and its data
- Technologies and Tools: OBIEE 11.1.1.5, BI Publisher, Informatica 7.x/8.6x, Oracle 11g, SQL Developer
Education
Master of Science (M.S.) - Information Technology & Management
Campbellsville University
Campbellsville, KY05.2018
Bachelor of Science (B.S.) - Mechanical Engineering
Vignan University
INDIA06.2014
Skills
- Master Data Management (MDM) – Customer 360, Product 360, Supplier 360
- Oracle EBS (12210) – Customer, Product, Supplier Master Data
- Data Pipeline Development (AWS Glue, PySpark, Databricks)
- Cloud Data Warehousing (Snowflake, Redshift)
- Integration: APIs, ETL/ELT, Real-Time & Batch Data Flows
- Agile Methodology – User Stories, Sprints, UAT
- SQL, Python, Terraform, Airflow Automation
- Data Quality, Matching & Merging, Hierarchies
Certification
Oracle Data Integrator 12c Certified Implementation Specialist
Timeline
Data Engineer / MDM Specialist
Peraton
06.2019 - Current
ETL DEVELOPER
Parkview health
09.2018 - 05.2019
ORACLE REPORT DEVELOPER
Diligent Soft Tech India Pvt Ltd
07.2014 - 08.2015
Master of Science (M.S.) - Information Technology & Management
Campbellsville University
Bachelor of Science (B.S.) - Mechanical Engineering
Vignan University
Similar Profiles
KEVIN EGGERTKEVIN EGGERT
Knowledge Management Lead Associate at PeratonKnowledge Management Lead Associate at Peraton
Thomas PetersonThomas Peterson
Lead Business Systems Analyst at PeratonLead Business Systems Analyst at Peraton
Akeem LawrenceAkeem Lawrence
Background Investigator at PeratonBackground Investigator at Peraton
Nobert OromaNobert Oroma
Operations Assistant at Uptown Community ServiceOperations Assistant at Uptown Community Service
Anthony LandinghamAnthony Landingham
Director, Internal Controls and SOX at CibusDirector, Internal Controls and SOX at Cibus