Summary
Overview
Work History
Education
Skills
Timeline
Generic

HARIKA VOOTKURI

Hyderabad

Summary

  • Over 3 years of experience in Business Intelligence, including requirement analysis, data analysis, and application development. Proficient in requirement gathering, customization, maintenance, and testing of various business applications.
  • Extensive experience in ETL processes with data extraction, transformation, and loading from sources like Netezza, Oracle, SQL Server, and flat files.
  • Accountable for developing, implementing, administering, and supporting ETL processes for large-scale data warehouses using Informatica Cloud Services.
  • Strong expertise in Data Warehousing and ETL with Informatica Cloud.
  • Experienced in data modeling, including star and snowflake schemas, FACT and dimension tables, and both physical and logical modeling.
  • Proficient in data analysis, requirement analysis, and data mapping for ETL processes.
  • Hands-on experience in tuning mappings and resolving performance bottlenecks across sources, targets, mappings, and sessions.
  • Extensive experience in ETL design, development, and maintenance using Netezza, Oracle, SQL, and Informatica Intelligent Cloud Services (IICS).
  • Skilled in developing complex SQL queries, unions, and joins, with experience in working with views.
  • Proficient in UNIX shell scripting

Overview

5
5
years of professional experience

Work History

Associate Developer

Capgemini Technology Services India Limited
06.2021 - Current

Project Description:

The Volvo Group, a global leader in manufacturing trucks, buses, construction equipment, and marine and industrial engines, utilizes various on-premises platforms for its BI and Analytics applications. By modernizing its current landscape to the cloud, Volvo Group aims to enhance business performance, scalability, and cost efficiency, while supporting future business needs.

Roles and Responsibilities:

  • Analyzing business requirements and functional specifications.
  • Using various Informatica transformations such as Router, Aggregator, Joiner, Expression, Lookup, and Sequence Generator.
  • Parameterizing mappings to enhance reusability.
  • Monitoring and scheduling Informatica jobs in production, providing load status updates to stakeholders.
  • Resolving job failures and optimizing long-running processes.
  • Managing incidents with different priorities within specified timelines.
  • Collaborating with stakeholders to enhance existing designs based on new business requirements.
  • Supporting activities encompassing UNIX scripts, database objects (views, tables), and all Informatica transformations.
  • Documenting an end-to-end user guide for the scheduling process.

Junior Developer

KAJI INFOTECH PVT LTD.
09.2019 - 05.2020

Project Description:

TCR is an application designed to manage the Traffic Control Rental business. It continuously evolves by incorporating new features and solutions.

Roles and Responsibilities:

  • Developed, implemented, and enhanced products based on customer requirements.
  • Gathered and defined customer needs to create clear project specifications.
  • Analyzed user requirements and adapted database specifications accordingly.
  • Identified and resolved database issues.

Education

Pg Diploma - Data Analytics

C-DAC
Bengaluru, Karnataka, India
04.2021

B.Tech - EEE

Jawaharlal Nehru Technology University
Hyderabad, Telangana, India
04.2017

Skills

⮚ Informatica Intelligence Cloud Services (IICS)

⮚ Informatica Power Center -9x and 10x

⮚ Netezza

⮚ Oracle SQL

⮚ SSMS

⮚ UNIX Scripting-Cron Jobs

⮚ DVE TOOL

Timeline

Associate Developer

Capgemini Technology Services India Limited
06.2021 - Current

Junior Developer

KAJI INFOTECH PVT LTD.
09.2019 - 05.2020

Pg Diploma - Data Analytics

C-DAC

B.Tech - EEE

Jawaharlal Nehru Technology University
HARIKA VOOTKURI