Sindhusha Informatica Developer

Phone: 716-***-****

: abo7ts@r.postjobfree.com

Resumes ID: 49085

Location:, New York

Posted: 04.30.2012

Resume Details:

PROFESSIONAL SUMMARY:

Over 8 years of experience with Data Warehousing, Informatica (ETL), Mapping, Data analysis.

Experience as ETL developer (Informatica Power Center 8.6.1/7.1), Reporting, scheduling of ETL workflows.

Experience in extracting data from various database sources like Oracle 10g/9i, DB2, flat files and SQL server.

Strong knowledge on Designer, Workflow Manager, Workflow Monitor and Repository in Informatica.

Proficient in implementing complex business rules through Informatica transformations, Workflows/Worklets and Mappings/Mapplets.

Experience in creating mappings using various Transformations like Lookup, Joiner, Aggregator, Expression, Filter, Router and Update Strategy.

Good experience in scheduling number of Sessions, Worklets in the Workflow Manager.

Experience in Slowly Changing Dimension methodology for accessing the full history of accounts and transaction information.

Involved in full SDLC.

Experience in Performance tuning.

Experience in Unit testing.

Experience in writing SQL queries and Unix commands.

Proficient in Data Warehouse concepts and principles involving Star schema, Snow flake modeling.

Knowledge with Informatica 9.

Hands on experience in Participating in discussions with Project Manager, Team members on technical and business requirements.

Excellent communication and presentation skills.

TECHNICAL SKILLS:

ETL tools

Informatica Power Centre 8.6.1, Autosys Scheduler

Operating System

Windows XP/Vista/2000

Data Warehousing

Data Marts, OLTP, OLAP, Normalization, Dimensional Modeling, Facts, Dimensions, Star schema, Snow Flake schema, SCD’s

Database

Oracle 10g/9i, SQL server, DB2, Teradata

Languages

SQL, PL/SQL, UNIX shell scripting, Perl

Reporting tools

Crystal Reports XI R2

Packages

MS Office 2007

Other tools

SQL*Plus, SQL Loader, TOAD

PROFESSIONAL EXPERIENCE:

Client: Pacific Pulmonary Services, Novato, CA. Jul 10 - Till date

Role: Informatica Developer.

Responsibilities:

Interacted with the business people and database administrators to identify the business requirements and data realties.

Responsible for creating and maintaining of aggregate data sources within the data warehouse.

Designed new database tables to meet business information needs.

Involved in gathering requirements for the logic to be implemented.

Prepared functional specifications and scope documents.

Involved in monitoring the delta loads on day-to-day basis and maintaining the history of records.

Prepared Mapping documents for loading the data from data warehouse to the respective targets.

Involved in creating High level and low level design of the ETL process.

Defined Target Load Order Plan for loading data into different Target Tables.

Designed and developed various kinds of mappings using transformations like Expression, Aggregator, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, and Update Strategy.

Used Debugger to test the mappings and fixed the bugs.

Prepared migration document to move the mappings from development to testing and then to production repositories.

Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage and ODS.

Automation of job processing, establish automatic email notification to the concerned persons.

Worked on database connections, SQL Joins, views in Database level.

Involved in writing Unit test case and performance testing.

Knowledge with Oracle 11g.

Responsible for communicating with users update and report schedules.

Environment: SQL server 2008, Windows Vista, MS Excel, Informatica Power Center 8.6.1, SQL, PL/SQL, XML, Unix, Oracle 10g.

Client: Adara Networks, San Jose, CA. Sep 09 – Jun 10

Role: Informatica Developer.

Responsibilities:

Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.

Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.

Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

Extensively imported data from different source system such as flat files to ODS, Data marts and Data warehouse.

Performed tuning of Informatica Mappings for optimum performance.

Standardized parameter files to define session parameters such as database connection for sources targets, last updated dates for Incremental loads and many default values of fact tables.

Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.

Used Type 1 SCD and Type 2 SCD mappings to update Slowly Changing Dimension Tables.

Monitor troubleshoots batches and sessions for weekly and Monthly extracts from various data sources across all platforms to the target database.

Given Production support to resolve the issues.

Involved in Performance tuning at source, target, mappings, sessions, and system levels.

Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.

Extensively used SQL* loader to load data from flat files to the database tables in Oracle.

Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.

Involved in Unit, Integration, system, and performance testing levels.

Environment: Informatica Power Center 8.1/7.1, Oracle 9i/10g, DB2, Unix, SQL* Loader, TOAD 7.0, Star Schema, Flat files, MS-Office, Windows XP IBM AIX.

Client: Lowes, Mooresville, NC.Jun 08 – Aug 09

Role: Informatica Developer.

Responsibilities:

Worked on Informatica Power Center tool - Source Analyzer, Warehouse Designer, Mapping Designer and Workflow Manager.

Extracted data from DB2 and oracle based Market soft sources and transformed those and loaded in to DB2 targets.

Involved in creating mappings and loading various dimensions as required to load the fact including the time dimension.

The data obtained has to be profiled and validated.

Loaded fact tables by the dimension ids and qualified interactions and successful lead counts.

Involved in discussions with the users to get the exact requirements on the reporting perspective and designed a mechanism in Informatica for commercial customer hierarchies.

Tested the data by writing SQL queries in command center for DB2 and for Oracle.

Used transformations like Source Qualifier, Unconnected Lookup, Router, Update, Expression, Aggregator and Sequence Generator.

Creating workflows where either the source or target might be XML’s.

Created reusable transformations in the shared folder and used the shortcuts in mappings.

Tested data extracts.

Tuned ETL mappings and SQL queries for better performance and efficiency.

Supported production jobs, data enhancements and code fixes.

Involved in performance tuning of targets, sources, mappings, and sessions.

Environment: Informatica Power Center 7.1.2, Oracle9i, SQL, Teradata, PL/SQL, Sun Solaris 7.0, Unix shell scripting and Autosys.

Client: CME Group, Chicago, Illinois.Dec 07 – May 08

Role: Informatica Developer.

Responsibilities:

Actively involved in gathering requirements and acquiring application knowledge from Business Managers & Application Owners.

Imported various Sources, Targets and Transformations using Informatics Power Center.

Responsible for tuning of Informatica Mappings for better performance.

Developed various Sessions, Batches for all Mappings for data loading from Source files, Tables to Target tables.

Created Mappings between Source and Target using Power Center Designer.

Developed different Transformations to load the data into target.

Improved workflow performance by shifting filters as close as possible to the source and selecting tables with fewer rows as the master during joins.

Tuned the mappings and sessions for better performance by eliminating various interacted performance bottlenecks.

Developed PL/SQL stored procedures to implement business logic.

Made extensive use of filters, conditions, calculations, etc.

Involved in tuning of SQL queries for better performance.

Environment: Informatica Power Center 7.0,Oracle 8i, UDB DB2, SQL, PL/SQL, UNIX, TOAD, SQL Server 2000, Windows 2000.

Company: Compassites Software Solutions Pvt Ltd., India. Oct 04 – Nov 07

Project #:1

Role: Informatica Developer.

Responsibilities:

Worked Extensively on Informatica tools–Repository Manager, Designer, Workflow Manager and Workflow Monitor.

Designed and developed various mappings and mapplets in Mapping designer and sessions and workflows in Workflow manager to extract data from SQL Server and load to Oracle database.

Developed Transformation logic and designed various complex Mappings in the Designer.

Extensively used transformations such as Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, LOOK UP (Target as well as Source), Update Strategy, Source Qualifier, Stored Procedure and Joiner.

Responsible for using Connected and Unconnected look up, Persistence lookup, Dynamic & Static lookup.

Created and ran Pre-existing and debug sessions in the Debugger to monitor and test the sessions prior to their normal run in the Workflow Manager.

Used Workflow monitor to monitor tasks, workflows and also to monitor performance.

Developed Informatica Mappings, Re-usable Transformations, re-usable mappings and Mapplets for data load to data warehouse and database (oracle).

Worked with Variables and Parameters in the mappings to pass the values between sessions.

Extensively worked in the performance tuning of the programs, ETL Procedures and processes.

Extensive use of SQL commands with TOAD environment to create Target tables.

Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.

Environment: Informatica Power Center 7.1/6.1, Oracle 9i, TOAD, ERWIN, Windows 2000.

Project #2:

Role: Informatica Developer.

Responsibilities:

Interacted with the Business Personnel to analyze the business requirements and transform the business requirements into the technical requirements.

Extracted the data from Oracle, Flat files and load into Data warehouse.

Responsible for preparing technical specifications for the development of Informatica (ETL) mappings to load data into various target tables.

Responsible for the design and development of logical and physical model of the STAR schema using ERWIN and developed the relevant fact and dimension tables.

Extensively worked with Informatica Power Center tools – Repository Manager, Designer, Workflow Manager and Workflow Monitor.

Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/ Unconnected, and filter.

Worked on cache filing of informatica like static, dynamic, Persistent cache which used to reduce session processing time.

Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance (finding bottleneck).

Involved in performance tuning by dropping indexes, truncating stage tables, rebuilding the indexes, and analyzing the tables during the process.

Used the Informatica command line utilities like pmcmd to control workflows in non-windows environments.

Involved in Unit testing, User Acceptance testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.

Environment: Informatica Power center 6.1, Oracle 9i, XML, Flat Files and Windows.

Education: Bachelor’s from India.

Reference: Will be provided upon request.

Contact this candidate