Ranganathan - Drawer - Chennai, TN, India

Krishnaveni Ranganathan

Chennai, TN, India



  • Full time
  • Part time
  • One time
  • Contract
  • Temp

Work History

ETL Developer

BI Software Solutions

From June 2013

ETL Tools: Informatica Power Center 9.0.1, Talend Open Studio 5.5.1.

ETL Developer

Third Party

June 2013 - August 2013

Environment: Talend Open Studio 5.5.1, MySQL Workbench 6.1, Linux.
Project Description:
The project includes the conversion of data from various source system into a common format and loading into data warehouse. This helps to evaluate the current business process with the existing business process, so that they can move forward with the competitors as well as to sustain their business in the market.

• Mainly involved in ETL development.
• Analyzed the sources, transformed the data and loaded the data into target database using Talend Open Studio tool.
• Connecting to the ftp location and downloading the necessary files from ftp location and moving those files into the corresponding directory location.
• Created the Stage job, Dimension job, Incremental job, Fact job, Master job.

• Created the stage job, extracted the data from multiple sources like Flat files, MySQL databases, PostgreSQL, json structure, xml files and loaded into the staging database.

• Created the Fact job, extracted the common format data from the staging and after applying some necessary transformations, further data has been loaded into the Target as per the client requirement.
• Created the Incremental job, loading into target tables such that new or updated data from the source only will load into the target.
• Used stored procedure in the master job to update the log entries in the Load Log.
• Automated the master job to execute automatically using cron tool.

• Validating the data both in the source and the target database.

Project 2

Revenue and Transactions Management


From September 2013

Environment: Informatica 9.0.1, Oracle 11g and Windows 7.
Project Description:
This project has been developed for LEEYO software. This includes the conversion of data from various source system into a common format and loading into data warehouse. Since business users can quickly access critical data from a number of sources, it can improve the way they conduct business. This helps to evaluate the existing revenue cycle processes, accounting techniques, operational practices and information flows.

• Mainly involved in ETL development.
• Extracted the data from multiple sources like Flat files, Oracle into staging database.
• Used Informatica Power Center 9.0.1 for extraction, transformation and loading (ETL) of data into DWH.
• Extensively worked on Informatica tools such as Source Analyzer, Target Designer, Transformation Designer, Mapping Designer, Mapplets.
• Created ETL mappings using the transformations such as the Source qualifier, Expression, Lookup, Router, Joiner and Sequence Generator.
• Involved in designing the mapping with multiple flat files using indirect loading.
• Resolving, if any issues in transformations and mappings.
• Incremental loading is implemented in Source Qualifier.
• Used Informatica Power Center, Workflow Manager to create Sessions and Workflows.
• Involved in basic level Mapping Performance tuning.
• Prepared SQL queries to validate the data in both source and target databases.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.

• Being a best performer in BI Software Solutions, I received best performance achiever award in 2014.

I hereby declare that the above written particulars are true to the best of my knowledge.

Date: Signature
Place: Chennai.

Qualifications & Certifications


Avinashilingam University

Avinashilingam Deemed University - Faculty of Engineering

Skillpages has been acquired by Bark.com!

Bark.com is pioneering the way people find local services. Skillpages is the world’s premier directory of service providers.

Find out more

Are you sure that you want to leave?