* ***** ** ** ********** in different Software applications.
* ***** ** **** ********** with Informatica Power Center and SQL Queries.
Involved in all phases of Data warehousing projects including Requirement Analysis, Development, Unit testing and Implementation for end-to-end IT solution offerings.
Experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
Good understanding of Data warehousing concepts.
Proficiency in Data Analysis, handling complex Query building and performance tuning.
Expertise in extracting and analysing data from existing data stores using Power Center and performing ad-hoc queries against warehouse
Using mapplet, reusable transformation and mapping parameter extensively in the mappings.
Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
Experience in Performance Tuning by using Row Transformations, Block and Unblock Transformations.
Creating different types of mappings by using different types of transformations in Informatica.
Have excellent analytical, problem solving, communications, and interpersonal skills with ability to interact with individuals at all levels and ability to lead and take challenges.
To utilize my skills and knowledge to enhance the organization growth as well as my professional growth, this will yield success individually and as a team, to work in a quality driven environment
Believe in Teamwork, Sincerity, Hard work, eager to accept challenging Assignments and ability to work in a fast-paced, collaborative environment.
SQL, Oracle, DB2
Informatica Power Center 9.6
SQL Server, MS Office
HP Service Manager, Quality Center
SQL, C, Cobol, Mainframe
Master Of Pharmacy
University college of pharmaceutical sciences, Kakatiya University
Bachelor Of Pharmacy
Vaagdevi institute of pharmaceutical sciences, Warangal
Diploma in Pharmacy
Govt. Polytechnic for Women, Warangal
Gems junior college, Karimnagar
Jawahar Navodaya Vidyalaya, Choppadandi
DWH Reporting System
Feb 2012 to Feb 2015
Project Specific Skills
Informatica 9.6, Oracle
DWH Reporting System is the storage house of all types of data in Arvik Systems. The data warehouse keeps all the information about the different department. The warehouse system involved with both full loading and incremental loading.
Role and Responsibilities:
Involved in loading data into data warehouse system.
Data Loaded from tables and flat files into target database and cleaned data using appropriate business rules.
Worked on Informatica power center tool-source analyzer, target ware house designer, Mapping designer and workflow manager.
Implemented joiner, expression, aggregator, sorter, rank, lookup and update strategy etc to create different types mappings
Implemented mapping variables and parameters in mappings.
Generated reusable transformations, mapplets and used them extensively in mappings.
Bottleneck handling, unit testing also done.
Use of target load order and constraint base load ordering in this project, created parallel, sequential processing and control flow of data.
Environment: Informatica 9.6, Oracle, SQL server, HP Service Manager, Quality Center and Microsoft Office.