Boddu R.

Boddu R.

Expect ETL DEVELOPER WITH AWS

Hyderabad , India

Experience: 5 Years

Boddu

Hyderabad , India

Expect ETL DEVELOPER WITH AWS

12000 USD / Year

  • Notice Period: 90 Days

5 Years

Now you can Instantly Chat with Boddu!

About Me

A Data Warehouse professional with 4.7 Years of experience as a Team Member and involved in the life cycle i.e. Analysis, Design, Development, Implementation, Testing and Maintenance of various Data ma...

Expertise:

  • Solid work experience with Informatica ETL tool (Mapping Design, Development, unit Testing & Debugging).
  • Utilized some of the features like dynamic caching, update strategy and various other features of Informatica.
  • Responsible for overseeing the quality procedure related to project and checking whether all functionalities are Right or not.
  • Communicating with Onsite/ Offshore team effectively for execution of test plans and processes with them.
  • Good communication with good rapport with customers and commitment towards application success and support. Worked on Agile Process.
  • Good knowledge on full life cycle development of data warehousing.
  • Good knowledge on spark, Python and Hadoop concepts.

Show More

Portfolio Projects

MASS

Company

MASS

Description

Project 1:

Project        :    MASS 
(Marketing Agency Sales Summery)
Client                :    State Farm.
Operation systems        :    Windows, Linux.
Environment            :    DB2, Informatica 10.1s, Python.
Duration            :    Feb’2018 to till date.

Description:

State Farm is one of the largest insurance companies in US. This firm specialized in auto insurance for farmers, and later expanded its services into other types of insurance, such as homeowners and life insurance, and to banking, financial services and mutual funds.
Responsibilities with the team of 6:

•    To go through the documentation provided by System Operation team for system analysis.
•    To identify the tables and columns for the required to generate desired output, as per the source system along with the team.
•    Design and develop Informatica ETL Mappings/Transformations for extracting data, transformation, data cleansing, integration and loading into the target/staging area
•    Creating batch files to transfer data files from Informatica windows server to Active data warehouse UNIX server through WIN-SCP utility.
•    Creating load scripts to load data from data files on UNIX server onto tables in the database.
•    Creation, configuring, scheduling and running of Sessions, Work lets and Workflows.
•    Reviewing the work done.
 

Show More Show Less

Enterprise Data Warehouse (EDW)

Company

Enterprise Data Warehouse (EDW)

Description

Project 2:

Project            :    Enterprise Data Warehouse (EDW).
Client                :    Philips.
Operation systems        :    Windows, Linux.
Environment            :    Oracle10g, Informatica 9.6.
Duration            :    March’2016 to Jan’2018.


Description:
PHILIPS is a multinational conglomerate corporation headquartered in Amsterdam, one of the largest electronics companies in the world, currently focused in the area of healthcare and lighting. It was founded in 1891. It was once one of the largest electronic conglomerates in the world and currently employees around 74,000 people across 100 countries.
Responsibilities with the team of 5:
•    To go through the documentation provided by System Operation team for system analysis.
•    To identify the tables and columns for the required to generate desired output, as per the source system along with the team.
•    Design and develop Informatica ETL Mappings/Transformations for extracting data, transformation, data cleansing, integration and loading into the target/staging area
•    Creating batch files to transfer data files from Informatica windows server to Active data warehouse UNIX server through WIN-SCP utility.
•    Creating load scripts to load data from data files on UNIX server onto tables in the database.
•    Creation, configuring, scheduling and running of Sessions, Work lets and Workflows.
•    Creating procedures, functions, packages and triggers based on requirement and updating the existing procedures, triggers and packages.
•    Creating indexes to improve the performance in query retrieving process. 
•    Design and development of mapping and Database management.
•    Preparing the unit test cases and performs Unit testing and peer reviews at the end of each phase.
•    Reviewing the work done.
 

Show More Show Less

LIFE ASIA

Company

LIFE ASIA

Description

Project 3:

Project            :    LIFE ASIA.
Client                :    ICICI PRUDENTIAL.
Operation systems        :    Windows, UNIX.
Environment            :    Oracle10g, Informatica 9.5.
Duration            :    JUNE’2015 to Feb’2016.


Description:

ICICI is one of the largest insurance companies of India. ICICI aims to retain and develop our market position through our behavior, by striking a good balance between price and risk, and by offering dynamic, compassionate and innovative service to our customers, in claims situations. Our insurances include workers' compensation, motor, building, contents, transport, house, personal accident and health care.  It uses the product named LIFE ASIA for its IT implementation.
Responsibilities with the team of 7:

•    To go through the documentation provided by System Operation team for system analysis.
•    To identify the tables and columns for the required to generate desired output, as per the source system along with the team.
•    Design and develop Informatica ETL Mappings/Transformations for extracting data, transformation, data cleansing, integration and loading into the target/staging area
•    Creating batch files to transfer data files from Informatica windows server to Active data warehouse UNIX server through WIN-SCP utility.
•    Creating load scripts to load data from data files on UNIX server onto tables in the database.
•    Creation, configuring, scheduling and running of Sessions, Work lets and Workflows.
•    Creating procedures, functions, packages and triggers based on requirement and updating the existing procedures, triggers and packages.
•    Creating indexes to improve the performance in query retrieving process. 
•    Design and development of mapping and Database management.
•    Preparing the unit test cases and performs Unit testing and peer reviews at the end of each phase.
•    Reviewing the work done.
 

Show More Show Less