sheba r

Datawarehouse Designer - 0 Years of Experience


Datawarehouse Designer

Education Level:


Will Relocate:



Around 8 years of experience in Information Technology with a strong background in Data Warehousing, Business Intelligence and ETL process using Informatica Power Center 9.1/8.x/7.x and Informatica Data Quality and Informatica Data Analyst tools and expertise skills in reporting using the Business Objects. * 2+ years' data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ). * Extensive work experience in the areas of Banking, Finance, Insurance and Manufacturing Industries. * Extensively used ETL methodology for supporting of Extract, Transform, and Load environment using Informatica Power Center 8.x/7.1 (Designer, Repository manager, Repository Server Administrator console, Server Manager, Work flow manager, workflow monitor). * Extensive experience in using various Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer, Schedulers and Warehouse/Target Designer. * Expertise in Extracting and Transforming data using DTS in SQL Server 2000, SSIS in SQL Server 2005, SQL Server Import Export, Bulk Insert and BCP. * Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator, Normalizer, Union, and XML Source Qualifier. * Highly experienced in developing, designing, reviewing and documenting Informatica work products like Mappings, Mapplets, Reusable transformations, Sessions, Workflows, Worklets, Schedulers and experienced in using Mapping parameters, Mapping variables, Session parameter files. * Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts, reusable transformations and Partitioning Sessions. * Analyzed and designed the database. Involved in database normalization process. * Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, transformations and sessions. * Proficiency in using Informatica Power Center tool to design data conversions from wide variety of sources * Experience in integration of various data sources like Oracle, SQL server and MS access and non-relational sources like flat files into staging area. * Extensively worked with SQL loader for bulk loading into the oracle database. * Strong in Data warehousing concepts, dimensional Star Schema and Snowflake Schema methodologies, fact and dimension tables and Dimensional modeling, OLAP and OLTP process. * Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers. * Experience with SQL Plus and TOAD as an interface to databases, to analyze, view and alter data. * Experienced in UNIX work environment, file transfers, job scheduling and error handling. * Highly adept at creation, execution, testing and debugging of Informatica mappings, mapplets, sessions, tasks, worklets and workflows in UNIX and Windows environment. * Excellent overall software Development life cycle (SDLC) experience, Conceptual and Logical thinking, Goal oriented, self-motivated and able to work independently and as a member of a team.


CollapseWork Experience





CollapseJob Skills