Sign in

Informatica, SQL

Minneapolis, MN
March 30, 2019

Contact this candidate


Saritha Gande


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


SQL, Oracle, DB2

ETL Tools

Informatica Power Center 9.6

Reporting Tool

SQL Server, MS Office

Other Tools

HP Service Manager, Quality Center


SQL, C, Cobol, Mainframe

Educational Profile:





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


Project Details:

Project Name

DWH Reporting System


Arvik Systems


Feb 2012 to Feb 2015


Team Member

Project Specific Skills

Informatica 9.6, Oracle


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