Lalitha L.

Lalitha L.

Software Engineer

Hyderabad , India

Experience: 5 Years

Lalitha

Hyderabad , India

Software Engineer

14400 USD / Year

  • Start Date / Notice Period end date: 2019-12-01

5 Years

Now you can Instantly Chat with Lalitha!

About Me

Currently working as software Engineer at Tech Mahindra with 4.8 years of experience in Data warehousing, Reporting and Informatica ETL development. Hands on technical and analytical skill understanding of ETL design and project architecture alongsid...

Show More

Portfolio Projects

Description

The Project loads data from different source systems and populates data into the B2P data warehouse for B2P metrics calculation. As per the requirement from the user, the ETL logic is developed to load data to B2P DWH for to cater data for different B2P metrics calculation.

  • Responsible for development of ETL code like mappings, sessions and workflows and performing unit testing, code reviews.
  • Responsible for Developing UNIX Shell Scripts for file validations, executing jobs using pmcmd command and archival of files.
  • Understand Technical specification, mapping document.
  • Used Informatica Power Center V9.1, 10.1.0, 10.1.1 for extraction, transformation and load (ETL) of data in the data warehouse.
  • Extensively worked on Transformations like Router, Aggregator, Joiner, Lookup, Update strategy, Sequence generator, Filter, Expression etc.
  • Worked on Informatica Mappings, sessions and other tasks like Command tasks, Event Wait, Event Raise, Timer and workflows on business requirements.
  • Worked on mapplets, worklets and also parameterized the mappings for increasing the re-usability
  • Involved in ETL job automation and scheduling using UNIX scripts/pmcmd.
  • Report and resolve critical bugs analytically.
  • Worked on Documentation , reporting in confluence

Show More Show Less

Description

TORCH is a critical application used by GE Corporate, for reporting and decision making on Insurance Domain. Basically Healthcare Project that deals with Claims ,Contributions, JEs and Invoices details of GE employees under various businesses under Dental, Vision and Medical. We replicate the data from OLTP to data warehouse through Informatica and support the users to create the reports through BO.

  • Responsible for development of ETL code like mappings, sessions and workflows and performing unit testing, code reviews.
  • Responsible for Developing UNIX Shell Scripts for file validations, executing jobs using pmcmd command and archival of files.
  • Understand Technical specification, mapping document.
  • Used Informatica Power Center V9.1, 10.1.0, 10.1.1 for extraction, transformation and load (ETL) of data in the data warehouse.
  • Extensively worked on Transformations like Router, Aggregator, Joiner, Lookup, Update strategy, Sequence generator, Filter, Expression etc.
  • Worked on Informatica Mappings, sessions and other tasks like Command tasks, Event Wait, Event Raise, Timer and workflows on business requirements.
  • Worked on mapplets, worklets and also parameterized the mappings for increasing the re-usability.
  • Involved in ETL job automation and scheduling using UNIX scripts/pmcmd.
  • Report and resolve critical bugs analytically.
  • Worked on Documentation , reporting in confluence

Show More Show Less

Description

TORCH is a critical application used by GE Corporate, for reporting and decision making on Insurance Domain. Basically Healthcare Project that deals with Claims ,Contributions, JEs and Invoices details of GE employees under various businesses under Dental, Vision and Medical. We replicate the data from OLTP to data warehouse through Informatica and support the users to create the reports through BODS.

Show More Show Less

Description

Business Objects deals with Creating Universes, Reports based on the requirements provided by the user with less complexity, which contains 23 applications.

Show More Show Less