Resume

Sign in

Informatica, SQL

Location:
Minneapolis, Minnesota, United States
Posted:
March 30, 2019

Contact this candidate

Resume:

Saritha Gande

ac8yfs@r.postjobfree.com

+1-862-***-****

Minneapolis, MN

Professional Summary:

* ***** ** ** ********** 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.

Technical Skills:

Operating Systems

Windows XP/7/10

Databases

SQL, Oracle, DB2

ETL Tools

Informatica Power Center 9.6

Reporting Tool

SQL Server, MS Office

Other Tools

HP Service Manager, Quality Center

Languages

SQL, C, Cobol, Mainframe

Educational Profile:

Course

Year

College/University

Aggregate

Master Of Pharmacy

2012

University college of pharmaceutical sciences, Kakatiya University

72.5%

Bachelor Of Pharmacy

2010

Vaagdevi institute of pharmaceutical sciences, Warangal

83.3%

Diploma in Pharmacy

2007

Govt. Polytechnic for Women, Warangal

84%

XII

2005

Gems junior college, Karimnagar

88.7%

X

2003

Jawahar Navodaya Vidyalaya, Choppadandi

80%

Project Details:

Project Name

DWH Reporting System

Client

Arvik Systems

Duration

Feb 2012 to Feb 2015

Role

Team Member

Project Specific Skills

Informatica 9.6, Oracle

Location

Hyderabad, India

Project Description:

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.



Contact this candidate