SUMMARY:

• 7+ years of experience in Information Technology with a strong background in Database development and Data warehousing.
• Good experience in designing, Implementation of Data warehousing and Business Intelligence using ETL tools likeInformaticaPower Center (designer, workflow manager, workflow monitor and repository manager).
• Created mappings in mapping Designer to load data from various sources using transformations like Transaction Control, Lookup (Connected and Un - connected), Router, Filter, Expression, Aggregator, Joiner and Update Strategy, SQL, Stored Procedure and more.
• Excellent Knowledge on Slowly Changing Dimensions (SCD Type1, SCD Type 2, SCD Type 3), Change Data Capture, Dimensional Data Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data Marts, OLAP and FACT and Dimensions tables, Physical and Logical data modeling.
• Experience in developing Transformations, Mapplets and Mappings inInformaticaDesigner and creating tasks using Workflow Manager to move data from multiple sources to target.
• Worked onInformaticaData Quality 9.1(IDQ) tool kit and performed data profiling, cleansing and matching and also imported data quality files as tables.
• Worked in different phases of the projects involving Requirements Gathering, Design, Development, Deployment, Testing and Maintaining.
• Good Knowledge on Database architecture of OLTP and OLAP applications, Data Analysis.
• Experience in E-R modeling, developing Database Schemas like Star schema, Snowflake schema used in relational, dimensional and multidimensional modeling.
• Worked with wide variety of sources like Relational Databases, Flat Files, Mainframes, XML files and Scheduling tools like Control-M, Auto sys andInformaticaScheduler.
• Strong experience working with different RDBMS like Oracle 10g, 11g Sybase, MS SQL Server 2008 Teradata, SQL, PL/SQL, SQL* PLUS, SQL* Loader, TOAD, Stored Procedures, Triggers.
• Very Strong skills and clear understanding of requisites and solutions to various issues in implementation throughout the Software Development life cycle (SDLC).
• Hands on experience in PL/SQL (Stored Procedures, Functions, Packages, Triggers, Cursors, Indexes) and UNIX Shell scripting.
• Good knowledge on data quality measurement using IDQ and IDE.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for DevelopedInformaticaMappings.
• Proficient in integration of CRM data source such as Salesforce and SAP using Power Exchange.
• Hands on experience working in LINUX, UNIX and Windows environments.
• Experience in working Production Support and migrated the code from DEV to QA to Production.
• Experience creating different documentations like RTM, BRD, HLD, TDD, Unit Test Cases, Deployment Plans and Production Turnover documents.
• Excellent Verbal and Written Communication Skills. Have proven to be highly effective in interfacing across business and technical groups.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x, 8.x

Databases: Oracle 10.x,11.x MS SQL Server 2008

Data Modeling: Erwin

Tools: Autosys 3.5.1, TWS Maestro 8.5.1, HP Service Manager 9.33, HP Quality Center 11

Languages: SQL, PL/SQL

Operating Systems: Windows, UNIX (Solaris 11.x)

Utilities: Toad, SQL Developer

PROFESSIONAL EXPERIENCE:

ETL/Informatica Developer

Confidential - Hopkins, MN

Responsibilities:

• Understanding the Business and Technical migration rules for data mapping from Source to Target.
• Involved in this project in all phases and ETL environments setup from scratch.
• Designed, Developed and tested the Informatica Mappings which are designed as per best practices for the development team to make the development phase more efficient and also serves as a medium to introduce the development standards that developer need to follow.
• Developed Mapping templates for diff subject areas (Employee, Finance, Staffing, Work hours).
• Experience in maintenance, enhancements, performance tuning of ETL code with. Persistent lookups and Informatica portioning.
• Extensively worked on the different transformations such as the Java, Normalizer, Source Qualifier, Expression, Aggregator with sorted input, Connected & unconnected lookups (Active/passive), Filter, Router, Sequence Generator
• Assisted change management reviews and impact analysis with the Business team.
• Identify the stake holders, priorities the task items which could be delivered in the next cycle as per part of engagement.

Environment: Informatica 9.6.1, Oracle, Toad, SQL developer, Unix-AIX, Putty and WinSCP (), Autosys

Informatica Developer

Confidential - Boston, MA

Responsibilities:

• Creating the design and technical specifications for the ETL process of the project.
• Scheduling meeting with the business users to gather the business analysis reporting requirements.
• Involved in designing and creating mappings and mapplets using Informatica source, warehouse, and transform and mapplet designers.
• Developed complex mappings using Informatica Power Center Designer to transform and load data.
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Aggregator, Filter, and Lookup.
• Developed several Mappings and Mapplets using corresponding Sources, Targets and Transformations.
• Enhancing the data mart as per business needs.
• Implemented complex mappings such as Slowly Changing Dimensions.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Creating trigger file to create indicator files for continues workflows using command task.
• Used all transformations such as Expression, Filter, Router, Update, Union, Lookup, Rank, Connected Stored Procedures, Aggregator, and Sequence Generator. Sorter, Joiner Transformation.
• Created sessions and workflows to run with the logic embedded in the mappings using Power Center Designer.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Maintain Development, Test and Production mapping migration Using Repository Manager.

Environment: Informatica Power Center 9.5.1, Oracle 10g, PL/SQL Developer 9.0, SQL*Plus 9.2, Flat files, UNIX shell scripting, Windows.

Informatica Developer

Confidential - East Hanover, NJ

Responsibilities:

• Extracted data from different data sources such as Flat files, XML, Excel, oracle and SQL Server2008
• Used various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, MappletDesigner, Informatica Repository Manager and Informatica Workflow Manager
• Used the transformations like Union, Filter, Joiner, Expression, Aggregator, Router and Rank.
• Used Parameter files to define values for parameters and variables used in mappings, sessions, worklet or workflow.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Oracle, DB2, SQL Server 2008 and Flat files into the target EDW.
• Created and scheduled Workflows using Informatica workflow manager.
• Coordinated tasks and issues with team lead and project manager on daily basis
• Prepared Unit test documents, which captures the test conditions and scripts, expected/actual results and data cross - section and volume for Individual interfaces components
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment.

Environment: Informatica Power Center 9.0.1, ETL, Business Objects, Oracle 10g/9i/8i, HP - Unix, PL/SQL.

Informatica Developer

Confidential

Responsibilities:

• Involved in OLTP system analysis
• Backup & Restore Oracle Table space containing Informatica data
• Extracted data from different sources and cleansed the data, validated the data before loading into the Data warehouse.
• Extensively used Informatica to load data into Centralized Data Warehouse
• Extensively used Informatica client tools Source Analyzer, Target designer, Mapping designer and Mapplet Designer.
• Worked on Informatica tool - Source Analyzer, Target Designer, Power Center Designer, Mapping Designer, Mapplet Designer and Transformations
• Created sessions and batches to run the mappings and set the session parameters to improve the load performance Developed Mapplets, reusable transformations and creation of shortcuts
• Created Informatica mappings to build business rules to load data Most of the transformations were used like the Source qualifier, Aggregators, lookups, Filters & Sequence Generators
• Involved in Unit Testing and tuning process for better performance

Environment: Informatica Power Center 8.6.1, Oracle 9i, PL/SQL Developer, SQL*Plus, UNIX Shell Script