Lalitha L.

Lalitha L.

Having 5.2 years experience on Informatica, UNIX, SQL, DWH concepts

Hyderabad , India

Experience: 5 Years

Lalitha

Hyderabad , India

Having 5.2 years experience on Informatica, UNIX, SQL, DWH concepts

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 5.2years of experience in Data warehousing, Reporting and Informatica ETL development.

...

Show More

Portfolio Projects

Total One Stop Reporting for Healthcare

{{totalColleagues-3 > 0 ?'+':''}}{{totalColleagues-3 > 0 ?+ totalColleagues-3 :''}}

Dantuluri G

Company

Total One Stop Reporting for Healthcare

Role

Backend Developer

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

Accounts & Payable Data ware House (Buy to Pay)

Company

Accounts & Payable Data ware House (Buy to Pay)

Role

Backend Developer

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

Business Objects

Company

Business Objects

Role

Backend Developer

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
Share:

Verifications

  • Profile Verified

  • Phone Verified

Preferred Language

  • English - Fluent

  • Hindi - Fluent

Available Timezones

  • Eastern Daylight [UTC -4]

  • Pacific Daylight [UTC -7]

  • Australian EDT [UTC +11]

  • Australian CDT [UTC +10:30]

  • Greenwich Mean [UTC ±0]

  • Mountain Daylight [UTC -6]

  • Central Daylight [UTC -5]

  • Eastern European [UTC +2]

  • Eastern EST [UTC +3]

  • Further EET [UTC +3]

  • Dubai [UTC +4]

  • New Delhi [UTC +5]

  • China (West) [UTC +6]

  • Singapore [UTC +7]

  • Hong Kong (East China) [UTC +8]