# Hajaran V

Hajaran V is a remote worker on Himalayas, Principal Consultant at Oracle, based in India.

Source: https://himalayas.app/@hajaranv

```text
Principal Consultant at Oracle validating HR data flows and ETL for reliable analytics.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | India |
| Authorized to work in | India |
| Job categories | ETL Developer, Data Warehouse Engineer, Business intelligence Engineer |
| Skills | Oracle Data Warehouse, ETL Testing, Data Integration, Oracle Data Integrator, Oracle Database, SQL, Pl SQL, Oracle OAC, OBIEE, Data Lineage, Dimensional Modeling, Star Schemas, Dimensional Modeling (Star And Snowflake Schemas) |

## About

```text
At Oracle (Oracle Global Services Center), I validate end-to-end business data flows and ETL processes for an internal HR project. I also analyze ODI workflows and investigate data discrepancies to safeguard data integrity.

I define ETL test strategies, prepare test plans and cases, and carry out source-to-target validation, reconciliation, and regression testing. When production data, ODI, or reporting issues arise, I work with functional teams, developers, and DBAs to resolve them.

At Birlasoft, I led ODI customization from estimation through migration, including redevelopment of mappings, packages, and projects during an ODI 11g-to-12c migration. I also configured data models, CDC processes, and deployment archives across QA and Production.

Earlier, at Tech Mahindra Ltd, I developed ETL processes for customer and billing data migration across BT Retail, Wholesale, and Global Services. I created ODI packages, interfaces, and Knowledge Modules to process flat files, mainframes, and other sources into One-Siebel and BAL platforms.
```

## Experience

### Principal Consultant (current)

[Oracle](https://himalayas.app/companies/oracle). Aug 2022 - Present

```text
Validated end-to-end business data flows, ETL processes, and data warehouse architectures. Executed ETL testing, root cause analysis, and production incident resolution.
```

Skills: ETL-Testing, Oracle-Data-Integrator, Oracle-OAC, SQL, Pl-SQL, Data-Lineage, Data-Quality, Root-Cause-Analysis, Production-Support

### Senior Software Engineer

[Larsen & Toubro Infotech Limited](https://himalayas.app/companies/ltimindtree). Jan 2022 - Jul 2022

```text
Monitored daily and scheduled ODI Load Plans and ETL batches in production. Analyzed ODI Operator logs to resolve production issues and ensure SLAs.
```

Skills: ODI-Load-Plan, ETL, Production-Support, SQL, Root-Cause-Analysis

### Senior Software Engineer

[Birlasoft](https://himalayas.app/companies/birlasoft). Nov 2020 - May 2021

```text
Led end-to-end ODI customization activities including migration from ODI 11g to 12c. Configured data models, CDC processes, and Topology architectures.
```

Skills: Oracle-Data-Integrator, ODI, Data-Modeling, CDC, LKM, IKM, CKM, SQL, Pl-SQL

### Data Visualization Engineer

[GE Aviation](https://himalayas.app/companies/ge-aerospace). Dec 2016 - Aug 2020

```text
Optimized SQL queries and ETL procedures for performance. Developed customized OBIEE reports and dashboards from Oracle ERP modules.
```

Skills: OBIEE, SQL, ETL, Oracle-ERP, Star-Schemas, Data-Warehouse, Performance-Optimization

### Senior Consultant

[Oracle Financial Services Software](https://himalayas.app/companies/oracle). Aug 2015 - Dec 2016

```text
Gathered client requirements and translated core banking needs into FLEXCUBE customizations. Customized PL/SQL and delivered full SDLC from design to deployment.
```

Skills: Flexcube, Pl-SQL, SDLC, Core-Banking, CASA, Term-Deposits, Loans, Utility-Payments

### Software Engineer

[Tech Mahindra](https://himalayas.app/companies/tech-mahindra). Jul 2010 - Aug 2015

```text
Developed ETL processes to migrate customer and billing data across BT Retail, Wholesale, and Global Services. Created ODI packages and Knowledge Modules for data integration.
```

Skills: Oracle-Data-Integrator, ETL, SQL, Pl-SQL, Data-Migration, Flat-Files, Mainframe, Performance-Optimization

## Education

### Visvesvaraya Technological University

Bachelor of Engineering, Computer Science

```text
Completed a Bachelor of Engineering in Computer Science in 2009.
```

### Oracle University

Oracle Certified Specialist - ODI 12c, Oracle Data Integrator

```text
Earned the Oracle Certified Specialist - ODI 12c certification.
```

### Oracle University

Oracle Certified Professional - OCI 2025 Generative AI, Oracle Cloud Infrastructure

```text
Earned the Oracle Certified Professional - OCI 2025 Generative AI certification.
```

### Oracle University

Oracle Certified Professional - Oracle AI Vector Search, Oracle AI Vector Search

```text
Earned the Oracle Certified Professional - Oracle AI Vector Search certification.
```

### Oracle University

Oracle Certified Foundations Associate - Fusion AI Agent Studio Foundations, Oracle Fusion AI Agent Studio

```text
Earned the Oracle Certified Foundations Associate - Fusion AI Agent Studio Foundations certification.
```

## Tech stack

- Jira
- Git
- SQL
- ServiceNow
- Oracle Data Integrator

To contact Hajaran, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [suba selvi](https://himalayas.app/@subaselvi): Senior Consultant, Oracle Financial Services Software Limited
- [Arul T](https://himalayas.app/@arult): Technical Specialist, Standard Chartered GBS
- [abhilasha sahu](https://himalayas.app/@abhilashasahu): Database Solution Architect, Deutsche Bank
- [Vidit Jain](https://himalayas.app/@viditjain): Senior Consultant, Deloitte Consulting India Pvt Ltd
- [Umesh R Gowda](https://himalayas.app/@umeshrgowda): Senior Specialist, Data Engineering, LTM
- [Ravi Parthasarathi](https://himalayas.app/@raviparthasarathi): Manager/Architect, Tech Mahindra Limited
- [Raghavendra H T](https://himalayas.app/@raghavendraht): Senior Database Programmer, Mango Sciences, Inc.
- [rakhi tiwari](https://himalayas.app/@rakhitiwari): Principal Data Engineer, Oracle India Pvt Ltd
- [K Balurajan](https://himalayas.app/@kbalurajan): Business Intelligence Consultant, Allstate India Private Limited
- [Kushal Kumar](https://himalayas.app/@kushalkumar4): Consultant, Infosys Ltd
