SUMMARY:

• 7+ yrs. of experience in Data Architecture, Server Migration, Data Integration, Data Warehousing using ETL tool INFORMATICA Power Center 9.X/8.6/8.1/7.1 (Source Analyzer, Warehouse Designer, Mapping/Mapplet Designer, Sessions/tasks, Worklets/Workflow Manager, Workflow monitor).
• Excellent overall software Development life cycle (SDLC) implementation from Requirement gathering, Analysis, Data modelling Design, Implementation, Testing, Pre implementation, Post implementation support and maintenance.
• Extensive knowledge in dimensional data modeling, star schema, snowflake schema, fact and dimension tables and process mapping using the top - down and bottom-up approach.
• Extensively worked in the Performance tuning of the TSQL and ETL processes.
• Experience in Designing and developing mappings from various transformation logics like, Source Qualifier, Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Union, Joiner, Transaction Control and Update Strategy.
• Proficient in implementing Complex business rules by creating re-usable transformations, workflows/worklets and Mappings/Mapplets.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, transformations and sessions
• Developed slowly changing dimension mappings of Type1, Type2 and Type3 (version, flag and time stamp).
• Worked with Informatica Mapping Variables, Mapping Parameters and Parameter Files
• Scheduling the sessions to extract, transform and load data into warehouse database depending on the business requirements.
• Wrote TSQL, PL/SQL, stored procedures for implementing business rules for adhoc data.
• Provided assistance during user testing (interaction with the users)
• Experience in Relational, Multi-Dimensional and OLAP Technologies leveraging DB systems such as Oracle, SQL Server, MS Access, Teradata.
• Well versed with various tools such as SQL server 2005/2008, TOAD for Oracle, WINSCP, FILEZILLA, PUTTY, SVN TORTOISE, and DEPLOYMENT MANAGER.
• Responsible for Unit testing of mappings and workflows.
• Extensively worked on Code Migration from Development, UAT, and Production.
• Experienced in designing and writing on-demand UNIX shell scripts.
• Reliable, proactive, adaptable, responsible, hardworking, ethical and good team player.
• Worked with Business users, Analysts, Development, and end users to correlate Business Logic and Specifications for ETL Development.
• Versatile team player with excellent analytical, communication and presentation skills to interact with team members and business users.
• Provided production support in an on-call rotation in 24x7.
• Quick learner and adaptive to new and challenging technological environments.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.1/8.6/8.1 (Workflow Manager, workflow Monitor, Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer), MSSQL-SSIS,IDQ,IDE,MDM

Programming Languages/ Scripting: C, SQL, PL/SQL,T-SQL, Shell programming, SSH Secure Shell, puttyTools: Toad, Erwin3.x, SQL Server Reporting Services(SSRS), MS Excel Word, Excel, SQL*PLUS, PowerPoint, Erwin, MS Visio, Tidal, Informatica Scheduler

Databases: ORACLE 11g/10G, MSSQL Server 2005, 2008, TERADATA and MS Access.

Reporting Tools: MS Excel, Crystal Reports, SSRS, Business Objects XI 3.1

Operating Systems: Windows/2008/2000/XP, Unix, Linux

PROFESSIONAL EXPERIENCE:

Confidential, SFO

Senior ETL Developer

Responsibilities:

• Used Informatica Power Center 9.1 for extraction, loading and transformation (ETL) of data in the data warehouse.
• Build efficient ETL Informatica packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Perform testing of code to meet business and technical specifications, including performance tuning during development lifecycle.
• Work with team leadership to understand scope, derive estimates, schedule, allocate work, manage tasks/projects, present status updates to IT and business leaders as required.
• Define and contribute to development of standards, guidelines, design patterns and common development frameworks & components.
• Worked effectively in a distributed global team environment across US, India.
• Worked with Functional Designers and IT Planners to meet Business level requirements and Standards.
• Conduct code walkthroughs and review peer code and documentation.
• Train and Manage developers, advising other groups in organization on Informatica development, data warehouse development and ETL development best practices.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules for adhoc data.
• Worked with SAP BI/BO Team for the business user adhoc reports.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Participated in the Project full life cycle from development to production and in gathering the required business documents for ETL development.
• Coordinated with Offshore on Project Deliverables including Development, QA and Deployment

Environment: Informatica 9.x, Oracle 10g, TERADATA, UNIX, Windows 2008, SAPBW

Confidential, TX

Programmer Consultant

Responsibilities:

• Design and develop ETL code, store procedures, configuration files, tables, views, and functions implement best practices to maintain optimal performance.
• Played a significant role in the design of scalable, reusable, and low maintenance ETL templates.
• Designed and developed ETL's using various transformations like Source Qualifier, Unconnected and Connected lookups on Tables, Unconnected lookup on Flat Files, Normalizer, Union, Router, Filter, Expression, Aggregator, Sorter, Joiner, Web Service Consumer Transformation, and Update Strategy.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Developed mappings & mapplets to load data from various sources using standard ETL transformations to store the data in the staging area and target tables.
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level.
• Reviewed data models using Erwin tool to find out data model dependencies.
• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.
• Provide on-call support to production system to resolve any issues.
• Gather requirements and design of data warehouse and data mart entities.
• Responsible for writing/documenting the Unit Test Cases with different testing scenarios to meet business rules implemented in ETL mappings.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.

Environment: Informatica 8.6.1, Oracle 10g, TSQL, PL/SQL, DAC, UNIX, Windows 2008

Confidential, TX

ETL Developer

Responsibilities:

• Involved in full project life cycle - from analysis to production implementation and support with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into Business intelligence database.
• Designed the ETL processes using Informatica tool to load data from Oracle into the target Oracle Database.
• Implemented Type I Slowly Changing Dimension methodology for applying the logic involving Insert else updates.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Developed Aggregation calculations through mapplets.
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level.
• Reviewed data models using Erwin tool to find out data model dependencies
• Documentation of ETL Mapping Specifications.
• Adhered to the quality code standards described by the client.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Written documentation to describe program development, logic, coding, testing, changes and corrections
• Monitored the status of the workflow time to time using Workflow Monitor

Environment: Informatica 8.6.1, Oracle 10g, SQL server 2005/2008, SQL developer, Erwin, Windows 2008, UNIX.

Confidential, New Jersey

Informatica/PL/SQL Developer

Responsibilities:

• Based on the requirements created Functional design documents and Technical design specification documents for ETL Process
• Assisted in designing Star Schema to design dimension and fact tables.
• Designed, developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Created complex mappings using Aggregator, Expression, Joiner transformations.
• Designed and developed process to handle high volumes of data and high volumes of data loading in a given load intervals.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Designed and developed table structures, stored procedures, and functions to implement business rules.
• Designed and developed process to handle high volumes of data and large volumes of data loading in a given load window.
• Extensively involved in migration of ETL environment, Informatica, Database objects.

Environment: Informatica Power Center 8.1.1, SQL Server, TSQL, PL/SQL

Confidential, OH

Informatica/Plsql Developer

Responsibilities:

• Requirements gathering and analysis.
• Assigned the ETL processes using Informatica tools to load data from file system and Oracle in to the target database.
• Extensive use of Informatica Power Center tools - Source Analyze, Warehouse Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Developed mappings/ sessions using Workflow manager for data loading with loaders such a Teradata utilities MLOAD, FLoad and Fast export.
• Developed mapping to load the data in slowly changing dimension.
• Created various transformations such as Lookup, Aggregate, Expression, Filter, SQL and Update strategy.
• Involved the performance tuning to meet the NFR requirements.
• Performed the testing as per unit test cases and SIT testing.
• Reviewed test cases and lead to project closure.
• Monitored the job run and update the statistics to Managers and Onsite Team.

Environment: Informatica Power Center 8.6, SQL Server, TSQL