Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic

Abhilash Paluru

Hyderabad

Summary

Dedicated and efficient ETL Lead with 12+ years of phenomenal technical experience in Data Integration. Successfully working with IICS, Informatica PowerCenter, Oracle, Snowflake, Google BigQuery and Power BI. My career marked by a consistent record of developing innovative strategies that streamline data processing and enhance system efficiencies.

Overview

14
14
years of professional experience

Work History

ETL Lead Developer

HCLTech
Hyderabad
03.2022 - Current
  • Understanding business requirements, studying the existing application landscape and identifying redundant/ineffective systems
  • Designed and developed Informatica mappings and transformation rules to support the data warehouse architecture model
  • Identified and fixed bottlenecks to tune the complex Informatica mappings for better performance
  • Creating complex SQL queries and good at SQL query performance tuning
  • Effectively used Informatica parameter files for defining mappings and workflows
  • Experience in driving a complete project from scratch to production, leading a team of size 10+ working closely with the stakeholders regularly on the status and risks (if any) in the project implementation and delivery
  • Collaborate with multiple teams to address the issues of inbound and outbound streams

Assistant Consultant

Tata Consultancy Services
Hyderabad
05.2016 - 03.2022
  • Strategically design, develop and migrate Informatica workflows and Oracle packages
  • Adapted quickly to changing project priorities and job specifications through Informatica PowerCenter
  • Developed complex mappings using Informatica PowerCenter Designer to transform and load data & fine tunings to process millions of input records with better throughput
  • Implemented Full Informatica Pushdown Optimization (PDO) (Source & Target) for better load performance
  • Effectively used Informatica parameter files for defining mappings and workflows
  • Proficient in using workflow tasks like Session, Control, Email tasks, Command tasks, Decision tasks & Event wait
  • Collaborate with cross-functional teams to design solutions

Associate

Cognizant Technology Solutions
Chennai
03.2014 - 05.2016
  • Maximized productivity by keeping detailed records of daily progress and identifying and rectifying areas for improvement
  • Responsible for In-bounds & out-bounds of the project and ensuring timely delivery to respective vendors
  • Worked with business users to get the requirement and to be involved in the complete SDLC of the project
  • Extracted & transformed data from high volume data sets of delimited files and relational sources
  • Designed and developed transformation rules (business logic) to consolidate (fact/summary) data using Informatica PowerCenter
  • Created various Oracle database objects like Indexes, Materialized views & synonyms
  • Involved in end-to-end unit testing, performance and regression testing and data validations.

Senior Software Engineer

HCL
Chennai
07.2010 - 03.2014
  • Analyzed, designed, developed, implemented and maintained moderate to complex mappings and workflows to provide data for Data Warehouse
  • Worked with both flat files and relational tables to extract the data from it and load it into Oracle tables after manipulating the data based on business logic
  • Identified and fixed bottlenecks to tune the complex Informatica mappings for better performance
  • Analyzed the existing mapping logic to determine the reusability of the code
  • Populate the business rules using mapping into the target tables
  • Created the Detailed Technical design documents which have the ETL technical specifications for the given functionality
  • Done extensive unit testing at various levels of ETL and wrote queries in SQL to ensure loading of the data
  • Implemented slowly changing Dimensions Type-1 and Type-2 approach for loading into the target tables.

Education

Bachelor of Technology - Instrumentation

ANDHRA UNIVERSITY
Visakhapatnam, Andhra Pradesh
03.2010

Skills

  • IICS
  • Informatica PowerCenter
  • Ascend IO
  • Oracle Database
  • Google BigQuery
  • Snowflake
  • Power BI
  • Collibra
  • IBM Workload scheduler
  • Unix
  • Data Warehousing
  • Agile Methodologies
  • Requirement Analysis

Websites

Timeline

ETL Lead Developer

HCLTech
03.2022 - Current

Assistant Consultant

Tata Consultancy Services
05.2016 - 03.2022

Associate

Cognizant Technology Solutions
03.2014 - 05.2016

Senior Software Engineer

HCL
07.2010 - 03.2014

Bachelor of Technology - Instrumentation

ANDHRA UNIVERSITY

Similar Profiles

CREATE PROFILE
Abhilash Paluru