SUMMARY

• Seven years of extensive professional experience in Information Technology Software Development Life Cycle dat includes Analysis, Design, Development, Testing and Implementing Data Mart and Data Warehouse Applications.
• Solid experience as an Informatica Developer in Data Integration, Migration and ETL process using Informatica Power Center 9.x/8.x/7.x/6.x/5.x.
• Well acquainted wif Informatica client tools - Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager and Workflow Monitor.
• Extensive database experience and highly skilled in SQL Server, Oracle, DB2, Teradata, XML Files, Flat Files, XSD, MS Access.
• Good Knowledge in Relational and Dimensional Modeling techniques like Star, Snowflake Schema, Fact and Dimensional Tables and Physical and Logical Data Modeling using ERWIN 4.5/4.0
• Extensive experience in designing and developing complex Mappings using transformations like Source qualifier, Aggregator, Expression, Connected &Unconnected lookup, Filter, Joiner, Sequence generator, Sorter, Router, Normalizer and Update Strategy.
• Extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Proficient in using Informatica workflow manager, workflow monitor, server manager, PMCMD (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.
• Worked on Slowly Changing Dimensions (SCD's) and implemented Type1, Type 2 to keep track of historical data.
• Knowledge in Data Analyzer tools like Informatica Power Exchange (Power Connect), Informatica Data Quality (IDQ), Informatica Data Explorer (IDE), Profiling, Metadata.
• Experienced in Installation, Configuration, Administration, & Support of Informatica Power Center on Client or Server environment.
• Experience in ETL performance tuning of sources, transformations, targets, mappings, worklets, workflows, and sessions.
• Optimized the Solution by using the performance tuning methods in the Oracle SQL queries like Indexing techniques, Hints, Partitioning and Parallel execution process.
• Extensively used Debugger in Informatica Designer tool to test the data and fix errors in the mapping.
• Implemented complex business rules in Informatica by creating Reusable transformations to reduce the development time and complexity of mappings.
• Extensive Knowledge in Teradata SQL Assistant, load/unload utilities like BTEQ, Fast Load, MultiLoad, Fast Export, Query Man and Tpump.
• Experience in writing Unix Shell Scripts in UNIX environment for pre processing data and scheduling Workflows.
• Has worked on scheduling tools like Autosys.
• Experience wif Confidential SSIS and converting SSIS to Informatica packages.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Excellent skills in retrieving/manipulating data by writing simple/ complex SQL Queries using PL/SQL, TOAD, SQL Developer, SQL*PLUS.
• Experience in creating Universes, various types of Reports and Charts for Decision Support Systems (DSS) using Business Objects.
• Worked on Onsite - Offshore model carried out the different phases of the projects TEMPeffectively by excellent co-ordination and communication.
• Worked on Data warehouse projects in Financials, Pharmaceuticals, and Insurance and has acquired comprehensive ETL experience and skills.
• Excellent analytical, problem solving skills and a motivated team player wif excellent inter-personal skills and excellent presentation skills.

TECHNICAL SKILLS

Environment: Windows XP/2000/98/95, Windows NT 4.0, Windows Server, UNIX, LINUX

ETL Tools: Informatica Power Center 9.x/8.x/7.x/6.x, Informatica Power Exchange 8.1,Power Connect, Power Mart, Power Analyzer

Data Modeling: Physical and Logical Data Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow flake Schema, Fact, Dimensions), Erwin 4.5/4.0

Databases: Oracle 11g/10g/9i/8i,MS SQL Server 2008/2005/2000/7.0, Teradata, MS Access

Languages: C,C++,SQL, PL/SQL, UNIX Shell Scripting, HTML, Java Script, XML

Tools: SQL*Plus, SQL*Loader, TERADATA SQL Assistant, TOAD, PL/SQL Developer, Autosys, Business Objects XIR3/6.5

PROFESSIONAL EXPERIENCE

Confidential, WA

Informatica Developer

Responsibilities:

• Used Data vault model and maintained ETL (Data Extraction, Transformation and Loading) mappings accordingly as per the user requirements.
• Created a huge number of complex mappings to implement ETL throughout from Source (SQL Databases and Flat files) to Staging (HUB’s, SAT’s, LINK’s, LINKSAT’s) and tan to Data Mart (Dimensions and Facts).
• Created mappings using Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter, Rank and Router transformations, Union transformation, Stored procedure transformation.
• Used debugger to test the data flow and fixed the mappings.
• Implemented slowly changing Dimensions Type-1 and Type-2.
• Maintained version control to keep track of the changes in the Dev.
• Written SQL, T-SQL queries as source query overrides and wrote SQL scripts to update the source queries in the database.
• Performed Unit testing and validated. Also involved in Integration testing and Patch drops (Resolved issues in bits to UAT).
• Performed code migration of mappings and workflows from Development to Test.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Extensively involved in resolving bugs using Visual Studio team Foundation (VSTF 2010 Premium) wherein the bugs are logged and managed.
• Responsible for Unit testing and integration testing.
• Responsible for migration of code from Informatica 9.0.1 to Informatica 9.1.0.
• Involved in development of MSRA Reports ( Confidential Reporting Analytics), which is Confidential Cloud BI reporting solution.

Environment: Informatica Power Center 9.1.0, SQL Server, Flat Files, PL/SQL, SQL LOADER, Windows 7

Confidential, New York, NY

Informatica Developer

Responsibilities:

• Involved in the full life cycle development of the project including Analysis, design, development, and testing.
• Worked closely wif Business Analyst and the end users in writing the functional specifications based on the business requirement needs.
• Interacted actively wif Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets.
• Prepared high-level design document for extracting data from complex relational database tables, data conversions, transformation and loading into specific formats.
• Involved in Dimensional Modeling using Star schema and Snow Flake schema for faster, TEMPeffective query processing and Business Analysis Requirements.
• Loaded data from OLTP Tables (which are in MS SQL Server) to Staging table (ORACLE database) and Staging table to OLAP Tables (ORACLE tables).
• Experience wif high volume datasets from various sources like Oracle, Flat Files, MS SQL Server and XML.
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Extensively used transformations like router, aggregator, lookup, source qualifier, joiner, expression, aggregator and sequence generator transformations in extracting data in compliance wif the business logic developed.
• Worked wif Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Developed SQL overrides in Source Qualifier/Lookup according to business requirements.
• Used SQL tools like TOAD to run SQL queries and validate the data in warehouse.
• Extended logic for some of the existing mappings in the system to meet enhancement procedures.
• Implemented Slowly Changing Dimensions - Type II in various mappings.
• Applied partitioning at session level for the mappings which involved loading data to target using target lookup to avoid duplicates records.
• Used Debugger wifin the Mapping Designer to test thedata flowbetweensource and targetand to troubleshoot the invalid mappings.
• Involved in Performance Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential, Parallel, Initial and Incremental Load.
• Extensively used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files.
• Developed pre-session and post session scripts using UNIX.
• Performed Unit testing and Integrated testing for the mappings created.
• Extensively used Autosys for scheduling the UNIX shell scripts.
• Involved in designing and building of Universe, Classes and Objects using Business Objects.
• Created reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's etc.
• Used various performance enhancement techniques to enhance the performance of the sessions and workflows.
• Copied/Exported/Imported the mappings/sessions/ worklets /workflows from development to Test Repository and promoted to Production.
• Provided Production support by monitoring the process running daily.
• Involved in the production support for issue fixes and halping out from the system failures.

Environment: Informatica Power Center 9.0/8.6.0 (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Transformation Developer, Source Analyzer, Mapplet Designer, Mapping Designer),Oracle 11g, SQL Server, TOAD, XML, Flat files, Windows XP, Autosys, UNIX, Business objects.

Confidential, Deerfield - IL

Informatica Developer

Responsibilities:

• Analyzed the requirements to identify the necessary tables dat need to be populated in to the staging database.
• Developed ETL mappings, Transformations and Loading using Informatica Power Center 7.1.2.
• Developed mappings and workflows as per business logic, quality and coding standards prescribed for the module using Informatica Power Center 8.1.0.
• Used heterogeneous files from Oracle, Flat Files, Sybase, XML, XSD, SQL server as source and imported stored procedures from oracle for transformations.
• Handled XML technologies (XSD) and worked wif XML sources and targets. Performance tuning and bottleneck resolution.
• Created mappings using transformations like Source Qualifier, Aggregator, Expression, lookup, Router, Filter, Update Strategy, Joiner, Union, and Stored procedure, and XML transformations.
• Worked on Informatica Power Center tools - Source Analyzer, Warehouse Designer, Mapping & Mapplet Designer, and Transformation Developer.
• Converted existing PL/SQL Packages to ETL Mappings using Informatica Power Center.
• Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.
• Wrote UNIX Shell scripts to automate workflows.
• Schedule and Run Extraction and Load process, monitor task and workflow using the Workflow Manager and Workflow monitor.
• Used Workflow Manager for creating workflows, work lets, email and command tasks.
• Implemented Type I, II changes in slowly changing dimension tables.
• Involved in Performance Tuning at various levels including Target, Source, Mapping, and Session for large data files.
• Use of Agile methods wifin my team for improving the documentation
• Worked on Migration Strategies between Development, Test and Production Repositories.
• Developed mapping document indicating the source tables, columns, data types, transformation required, bulk loading routines, business rules, target tables, columns and data types.
• Resolved issues and bugs raised by QA team.
• Developed Star Schema and Snow Schema for multi dimensional data modeling.

Environment: Informatica Power 8.1.0/7.x, TERADATA, Oracle 10g, TOAD, SOLARIS UNIX, and SQL Server 2005.

Confidential, Reston, VA

Informatica Developer

Responsibilities:

• Analyzed business requirements, performed source system analysis, prepared technical design document and source to target data mapping document
• Developed complex mappings using Transformations like Lookup (Connected and Unconnected), Joiner, Sorter, Rank, Source Qualifier, Router, Union, Aggregator, Filter, and Expression in the Power Center Designer.
• Involved in troubleshooting performance issues in the mappings and Optimized performance by tuning the Informatica mappings as well as SQL.
• Worked closely wif QA team during the testing phase and fixed bugs dat were reported.
• Extensively worked wif various re-usable components like tasks, workflows, Worklets, Mapplets, and transformations.
• Developed Informatica workflows and sessions associated wif the mappings using Workflow Manager.
• Worked wif session logs, Informatica Debugger, and Performance logs for error handling to fix workflows and session failures.
• Created UNIX Shell Scripts for batch scheduling and loading process.

Environment: Informatica Power Center 6.2, Oracle 9i, SQL Server, PL/SQL, SQL *Plus, TOAD, SQL*Loader, Autosys, and, Windows Server 2003.

Confidential

ETL Developer

Responsibilities:

• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica.
• Worked extensively wif complex mappings using expressions, aggregators, filters, joiner, lookup, rank, sequence generator and procedures to develop and feed Data warehouse.
• Extensively used Informatica Functions LTRIM, RTRIM, DECODE, ISNULL, IIF, INSTR and date functions in Transformations.
• Implemented Mapping Variables and Parameters in Transformations to calculate billing data.
• Utilized all Informatica tasks such as: Session, Command, Timer, Email, Event-Raise, and Event-Wait.
• Setting up automated scheduling of sessions at high loads at the regular intervals.
• Responsible for performance tuning of Informatica mappings.
• Made adaptive changes to the Data warehouse environment due to changes in the source system, Business Requirements, Enhancements and Product Upgrades.
• Designed relational data models using ERWIN for the data staging area to facilitate smooth data loads from multiple sources.
• Raised change requests, analyzed and coordinated resolution of program flaws and hot fixed them in the QA and Pre-Production environments, during the subsequent runs.
• Documented the mapping process and methodology used to facilitate future development.

Environment: Informatica Power Center 6.2, Designer, Server Manager, Informatica Repository Manager, PL/SQL, Oracle 9i, Windows NT, ERWIN 4.1, UNIX Shell Scripts.

Confidentia

Oracle Developer

Responsibilities:

• Involved in the installation and configuration of Oracle 8.1.6 server and creation of databases.
• Performed database and SQL tuning to improve performance of loads.
• Developing PL/SQL programs for data manipulation.
• Installation of Oracle client tools and establishing connectivity to databases.
• Creating table spaces, tables, indexes, users, etc.
• Implemented table partitioning to improve performance and data management.
• Assisted in logical and physical database design.
• Developed UNIX shell and SQL scripts for database monitoring and backups.
• Data loading using SQL*Loader to assist Data Warehouse developers.
• Implemented changes in the database design and modified stored procedures if necessary.
• Providing assistance in physical data modeling.
• Managed and monitored the use of disk space, database space, CPU, memory, cache, and user connections and processes.
• Implemented procedures for backup and recovery of production servers.
• Managing database security.
• Creating and assigning appropriate roles and privileges to users depending on the user activity.

Environment: Oracle 8.1, Windows 2000, PL/SQL, SQL* Loader.