KAMALAKAR REDDY

ETL Developer
Mob: +91 9030428832 Email: Kamalw3softech@gmail.com Address: Thane, Maharashtra

Profile Summary
 4 years of total IT professional experience in ETL development. Currently working at Tata Technologies as an ETL
Developer for Tata Motors Client in Mumbai from January 2023.
 Having goods hands on Experience in Development of ETL tool like Informatica and database like Oracle database and
Data warehousing concepts to create ETL jobs.
 ETL Development & Support in data flows from various source systems to target database.
 Design, Develop and Supports ETL process and tools. Handling the Analytics Team.
 Knowledge of Informatica various components like Repository Manager, Power center Designer, Workflow Manager,
Workflow Monitor and its transformations.
 Skilled in design, development of mappings from various transformation logic using filter, expression, rank, router,
aggregator, joiner, lookup, sequence generator, and update strategy.
 Good understanding of the SDLC with proficiency in mapping business requirements, technical documentation,
application design, development.
 Involved in requirement analysis, Source system data analysis, ETL Design, Development, data flow verification by
testing of Informatica Mappings and Workflows.
 Involved in preparing project related docs, Technical Design docs & Technical Specification etc.
 Good understanding of Data warehousing, ETL concepts and Dimensional modeling (Star schema and Snowflake
schema)
 Comfortable in interacting with people across hierarchical levels for smooth project execution. Experience in
implementing SCD’s, CDC, MD5 and performance tuning.

Technical Skills
ETL Tools : Informatica Power Center 9.6.1/10.2/10.4/10.4.1
RDBMS : Oracle 11g, pgAdmin, Oracle 18c, Oracle 19c
Operating Systems : Windows, UNIX, WinSCP
Scheduling Tools : CONTROL-M, DAC

Project Details
ASSIGNMENT #1 Thane
Company Name: Tata Technologies Jan’ 23 – Till date
Project name: AD Analytics
Domain: Automobile
Client: Tata Motors
Role: Solution Developer
Environment: Informatica 10.4.1, PgAdmin, Oracle 19c, DAC, Flat File, UNIX, Winscp.

Project Description:
An international Indian corporation that manufactures automobiles is called Tata Motors Limited. Originally established in
1945 as a locomotive maker, the company was once known as Tata Engineering and Locomotive Company (TELCO). Tata
Motors operates car factories and production facilities throughout the world. In this project we constructed a Data
Warehouse to stage the Sales, presales, service and Inventory related data for the industrial products of the company.
Informatica was used for Extracting data from source system to target systems. The extracted data was displayed in
ORACLE BI under various dashboards created. There were numerous sources of data coming into the warehouse including
Oracle and flat files. We had to extract the data from the various sources and display it in ORACLE BI dashboards
Responsibilities:
• Design, Develop and Supports ETL process and tools. Handling the Analytics AD Team.
• Handling Oracle BI admin activities granting access, data discrepancy.
• Worked on SQL building according to Business requirement.
• Worked on Database cleaning activity.
• Applied slowly changing dimension 1 & 2 effectively for loading the data implementing the change identified and
approved by business and promoting to higher environments in respective time lines.
• Created tables and Informatica mappings to pull data from source system and load into target DWH.
• Performing end to end unit testing after development and sharing the test results with the business.
• Preparing Mapping sheet between source & target tables.
• Test execution/validation of Source with Target.
• Used Timer, Event Raise, Event Wait, Decisions, and Email tasks in Informatica Workflow Manager
• Monitoring activities for all the Production related jobs and resolving the issues on adhoc Basis.
• Unit testing for validating the data to meet business requirements.
• Interacting with the clients on a regular basis to discuss Issues and matters.
• Identifies, researches, and resolves root cause of ETL production issues
• Worked on Informatica Performance Tuning and Database Tuning..
• Developed and optimized backend SQL queries to support Tableau visualizations, effectively handling large datasets
exceeding several crores.
• Designed and implemented an automated mapping that monitors the status of live ETL jobs, generating hourly
status reports in CSV format.
• Configured email distribution of workflows to the ETL team to proactively address job failures and ensure
continuity, effectively minimizing escalations from stakeholders.

ASSIGNMENT #2 Hyderabad
Company Name: Hitachi Consulting Jan’ 21 – Dec’ 22
Project name: LCA/RMO (Phase 1) Domain: Healthcare
Client: Optum
Role: ETL Developer
Environment: Informatica 10.2/10.4, Oracle 19c, Control-M, Flat File and UNIX.

Project Description:
Low Cost Alternative (LCA) provides low cost alternative drug to customer. LCA Opportunity of an alternative to a
consumer’ current medication with potentially lower cost that we encourage the member to switch to LCA delivers an
integrated view of Claims information across sources and subject areas by extending the Business
Data Warehouse that currently includes Membership, Customer, and Policy information. The ETL process flow will be
setup for different streams that Informatica Power Center will be reading or writing the data warehouse.
Responsibilities:
• Responsible for analysis the data and develop/understand the ETL specifications.
• Extracting of data from different sources like oracle tables and flat files.
• Good at working with transformations like Source Qualifier, Expression, Filter, Joiner, Router, Lookup and Aggregator.
• Involved in creating the sessions, command-tasks, workflows using the workflow designer.
• Scheduling and automate the process of Workflows.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different
transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter,
Source Qualifier.
• Used Mapplet, Reusable Transformations wherever applicable in mappings.
• Responsible for creating mappings as per technical design documents.
• Implemented slowly changing dimensions Type1 & 2 also implemented CDC & MD5 technique.
• Unit testing for validating the data to meet business requirements.
• Used mapping Parameters, Variables and Tasks.
• Worked on Informatica Performance Tuning.
• Monitoring the Informatica workflow jobs that transfer data between multiple systems & Maintaining Status of it.
• Identifies, researches, and resolves root cause of ETL production issues
• Monitoring the overnight batch consisting of 200+ jobs through Control-M.
• Interacting with the clients on a regular basis to discuss day-to-day Issues and matters.
• Suggest modification in existing graph to reduce complexity.

Education Details
Annamacharya Institute of Technology and Science Rajampet
B.Tech in Mechanical Engineering, 64% 2020
Narayana Junior College Kadapa
Intermediate(MPC), 95% 2015
Sri Saraswathi High School Jammalamadugu
SSC, 93% 2013

Declaration
I hereby declare that the above are accurate as per my knowledge and I will be responsible for any misrepresentation.
(Kamalakar Reddy)