Lokanadhareddy

PROFESSIONAL SUMMARY:

• 4.5 Years of total IT experience in Data warehousing with Informatica Power Center as ETL-Informatica Developer and ETL-Informatica Production support.
• Experience in Shift basis working, Night shifts and 24X7 ON Call ETL Informatica production support activities on ETL Production Job executions and resolving root causes.
• Experience in various kinds of sources and targets like Teradata, SAP BI, Oracle, DB2, Flat files.
• Extensively worked on Repository manager, Informatica Designer, and Workflow Manager and Workflow Monitor
• Used various transformations like Source qualifier, Aggregators, lookups, Filters, Sequence generators, Routers, Update Strategy, Expression, Sorter etc.
• Performing code migrations as part of Emergency/weekly/Monthly Change request releases.
• Proficient in Files FTP and RE-FTP one server to other servers using Putty, FileZilla.
• Proficient in Idle file concepts , timer, and Informatica Scheduler.
• Used workflow manager to create task and used workflow monitor to monitor and analyze the loading statistics.
• Analyze the requirements and accordingly plan, develop, design, test and implement the functionality and procedure.
• Prepared SQL Queries to validate the data in both source and target databases.
• Executed Workflows and Sessions using Workflow Manager and Workflow Monitor, provide production support for data warehouse jobs, running the jobs for ETL process.
• Interactions with DBA & Dev teams to resolve the issues. Experience in developing Test Plans, Test Strategies and Test Cases for Data Warehousing projects ensuring the data meets requirements.
• Designing, Implement and delivering data warehouse ETL and reporting applications.
• Maintain production log, analysis, abend history and Production Failure tracker.
• Providing technical support and troubleshooting issues for business users.
• Good knowledge in SQL and UNIX.
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
• Involved in knowledge sharing and knowledge transfer to the new members of the project & Preparation of knowledge transfer documents.

PROFSSIONAL EXPERIENCE:

Currently working as Informatica Developer from 2019 to till date.

KEY SKILLS

ETL Tool                                            :              Informatica Power center 10.X/9.X

Supporting Tools                             :              Motio, Putty, Winscp, FileZilla and Control-M. Data Bases          :            Teradata, Oracle9i/10g/11g, DB2

Operating Systems                          :              Windows , UNIX.

PROJECT PROFILE:

Project #1

Title                                                    :              EPDS (Enterprise providers Distributed system)

Client                                                 :              WELLPOINT (Anthem Inc.)

Environment                                     :      &