Lalitha Sai Raja

5.6 Years of Datawarehousing(DWH) experience using Informatica Power Center 9.X/10.x & Informatica

Intelligent Cloud Services(IICS).

• Informatica Certified Cloud Associate and Migration Specialist.

• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope,

Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design,Development, System

Testing, Implementation and Production Support.

• Expertise in working with IICS tool effectively using it for Data Integration and Data Migration from multiple

source systems.

• Expertise in working with IICS concepts relating to Data integration, Monitor, Administrator, Deployments,

Permissions & Schedules.

• Worked with various transformations like Normalizer, Expression, Rank, Filter, Aggregator, Lookups, Joiner,

Sequence generator, Sorter, SQLT,Update strategy, Source Qualifier, Transaction Control, Union etc.

• Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts,

reusable transformations and Partitioning Sessions.

• Experience in Performance Tuning of sources, targets, mappings, transformations and sessions.

• Experience in Installation, Configuration of Informatica Power center 10.x/9.x Client, Server in UNIX.

• Experience in Performance Tuning and Debugging of existing ETL processes.

• Experience in Integration of various data sources like Oracle, Teradata, SQL Server, DB2 and Flat Files in

various formats like fixed width, CSV and excel.

• Good Knowledge on Data Warehousing Concepts.

• Extensively used Informatica client tools – Source Analyzer, Target designer, Mapping designer,

Mapplet Designer, Informatica Repository Manager, Informatica Workflow Manager & Informatica

Workflow Monitor.

• Worked on Autosys Scheduling Tool. Able to create JIL Files, Environment Files as per

project requirement.

• Suceessfully Migrated the Informatica Powercenter code to IICS tool manually and by

using PC-IICS service.

• Experience in creating test case document based on functional specification and

logging defects.

• Good at doing rigorous unit testing and maintain zero fallouts in UAT and production for

ETLcode developed.

• Debugging production issues whenever required.

• Handling Offshore-Onsite Client Communication on daily basis and managed a team of 4-5 developers from

offshore.

• Good team player seeking an opportunity to work in challenging projects and aiming to become ahigh

caliber IT Professional.

• Good communication skills, ability to work under pressure, with standing long working hours

and ready to accept any challenging assignments.

• Experience in understanding client requirements and delivery of Quality work within

timeframes.

• Good at analytical and problem-solving skills.