SUMMARY

• Over 8 years of professional experience in Design, Implementation & Maintenance of OLTP & Data Warehouse systems, Data & Technical Architecture, ETL processes, Business Intelligence and Enterprise Application Integration.
• Extensively worked on various versions of Informatica ETL, Power Center (Source Analyzer, Mapping Designer, Mapplet Designer, Transformations Designer, Warehouse Designer, Repository Manager, and Workflow Manager/Server Manager).
• Implementation of full lifecycle in Data warehouses and Business Data marts with Star Schemas, Snowflake Schemas, SCD & Dimensional Modeling.
• Experience in various stages of System Development Life Cycle(SDLC) and its approaches like Waterfall, Spiral, Agile, and Prototyping Model.
• Extensively worked with different data sources, non - relational databases such as Flat files, XML files, and other relational sources such as Oracle, Teradata, Sql Server, DB2, SalesForce.com and SAP R/3.
• Well experienced in planning, building, and managing successful large-scale Data Warehouse and decision support systems.
• Experience in data warehousing techniques for Data Analysis, Data Profiling, Data Cleansing, Transformation, Consolidation, Integration, Data Import, Data Export using various source (Oracle, MS SQL Server, DB2, Teradata, XML and Flat files) and target.
• Comfortable in both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.
• Expertise in creating mappings, mapplets and reusable Transformations using Informatica Power Center Designer.
• Vast experience in Designing and developing complex Informatica Power Center mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Well acquainted with Performance Tuning of sources, targets, mapping and sessions to overcome the bottlenecks in mappings.
• Implementing Change Data Capture (CDC) Techniques like slowly changing target (type1, type2, and type3), slowly growing targets, and Simple pass through mapping using Power Center.
• Well experienced using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport, Tpump, Visual Explain, Query man, WinDDI).
• Hands on experience with Teradata Utility scripts like FastLoad, MultiLoad to load data from various source systems to Teradata.
• Extensive experience with database languages such as SQL and PL/SQL which includes writing triggers, Stored Procedures, Functions, Views and Cursors.
• Hands on experience in creating Indexes and partitioning tables for performance.
• Significant experience in Dimensional and Relational Data Modeling and Business Intelligence experience in Star Schema/Snowflake modeling, FACT & Dimensions tables, Cubes, Dash Boards, Physical & logical data modeling using ERWIN.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Power Center Mappings.
• Experience in writing UNIX shell scripting and Parameter Files.
• Good knowledge on Hadoop Distributed File System and MapReduce.
• Excellent Analytical, Communication skills, working in a team and ability to communicate effectively at all levels of the development process.

TECHNICAL SKILLS

Languages: HTML, SQL, T-SQL, PL/SQL, Unix Shell Script, PERL

ETL: Informatica 9.1x/8.6x/7.x(Power Center/Power Mart) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Exchange, Power Connect, Power Exchange,B2B DTS 8.6/9.1), Informatica Data Quality(IDQ), Informatica Cloud Services

Databases: Oracle 9i/10g/11g, Sql Server 2008/2005, Teradata, Sybase 11.5, DB2.

OLAP: Business objects XIR3/XIR2, BI Publisher, XML Publisher

Operating Systems: Windows 2000/ NT/ XP/ Vista/98/ 95, LINUX, UNIX, DOS, Windows 2003 server.

Tools: SQL Loader, SQL*Plus, TOAD, SQL Developer, Erwin

Reporting Tools: OBIEE 11g, Business Objects XI 3.1 SP5, SAP BI BIBO 4.0

Scheduling tools: Autosys, Control M, UC4 and Tidal

PROFESSIONAL EXPERIENCE

Confidential, OH

Sr. Informatica Developer

Responsibilities:

• Analyzed the Source and Target data and designed the Source to Target Data Mapping document.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from SQL Server to Target system Sales Force and vice versa.
• Created Informatica Power Center mappings and loaded data from SQL Server 2012 to Target system Sales Force and vice versa using Informatica Cloud Services.
• Worked extensively with complex mappings in Informatica Power Center Designer using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Java transformation.
• Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center.
• Designed and developed Data Profiling in Informatica Designer to profile the Source data to meet business requirements.
• Created Data Profiles in Profile Manager using Auto Profile and Custom Profile options to validated documented business rules.
• Guided team members on the evaluation of data using the Informatica Data Quality (IDQ) toolkit. Applied data analysis, data cleansing, data matching, exception handling, and reporting and monitoring capabilities of IDQ.
• Used Informatica Data Explorer (IDE) to identify data duplication, understand the quality of data and report generation.
• Implemented performance tuning logic on Targets, sources, mappings and sessions to provide maximum efficiency and performance.
• Developed Unit tests and separate User Acceptance test cases (UAT) to validate data against test scenarios.
• Used Teradata utilities like MultiLoad, Tpump, and Fast Load to load data into Teradata data warehouse from Oracle and MS SQL Server databases.
• Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
• Developed processes on both Teradata and Oracle using shell scripting and RDBMS utilities such as Multi Load, Fast Load, Fast Export, BTEQ (Teradata) and SQL*Plus, SQL*Loader (Oracle).
• Scheduled Informatica jobs using Autosys job scheduler.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.

Environment: Informatica Power Center 9.5/9.1, Informatica Cloud Services, Oracle 11g, SQL Server 20012, Teradata, Autosys, Toad, SAP Business Objects, SalesForce.com.

Confidential, Rhode Island

Sr. Informatica Developer

Responsibilities:

• Worked on Informatica Power Center Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Repository Server Administration Console.
• Analyzed business requirements, performed source system analysis, prepared technical design document and source to target data mapping documents.
• Involved in building the MDM Hub console for Customer, Property and Product departments.
• Created ETL mappings using Informatica Power center to extract the data from multiple sources like Flat files, Oracle, csv, Delimited files transformed based on business requirements and loaded to target system Teradata database.
• Worked with Informatica Data Quality (IDQ) Developer/Analyst Tools to remove the noises of data using different transformations like Standardization, Merge and Match, Case Conversion, Consolidation, Parser, Labeler, Address Validation, Key Generator, Lookup, Decision etc.
• Building custom cleanse functions using IDQ and import them in MDM to take Hub cleansing to the next level.
• Developed number of complex Informatica mappings, Mapplets, reusable transformations to implement the business logic and to load the data incrementally.
• Implemented Type 1 and Type 2 Slowly Changing Dimension(SCD) mappings to update SCD tables using Power Exchange Change Data Capture (CDC).
• Loaded the data into the Teradata database from Oracle and DB2 databases using Load utilities like MultiLoad, Tpump, and Fast Load to load data into Teradata data warehouse.
• Lead definition, execution, and communication of ETL strategy, design and processes to support the EDW environment.
• Mentored the 4 offshore developer and 2 onsite resources on daily activities.
• Part of IDQ team which was involved in checking the data quality of CDW and EDW data which is being loaded on daily and monthly basis.
• Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
• Participate in deployment, system testing, UAT.
• Engage in peer reviews during design, coding and testing.
• Provide leadership and guidance to project team to ensure that all aspects of ETL design and implementation align with The Company's reference model.
• Designed and configured ETL mappings using Informatics tool from the Siebel application.
• Involved heavily in writing complex SQL queries to pull the required information from Database using Teradata SQL Assistance.
• Set strategy and oversee design and development of EDW staging areas and target tables.
• Involved in developing and enhancing meta-data using Siebel Analytics Administration tool.
• Address and resolve technical design issues as they are appropriately escalated.
• Prepare implementation plans when moving a code to production.
• Perform system testing and monitoring.
• Optimize ETL design and tools to gain efficiency and functionality.
• Helped Production Support team during monthly runs and crisis.
• Created UNIX shell scripts to invoke the SQL scripts which are run daily.

Environment: Informatica Power Center 9.1/8.6, Oracle 11g, DB2, Teradata, ControlM, SQL, PL/SQL, Windows NT, Unix, Shell Scripting, OBIEE, BI/XML Publisher, Hyperion Essbase,Oracle BI Apps 7.9.6 & Siebel Analytics (7.8), Siebel CRM, Oracle EBS 11.5.10.

Confidential, Texas

Sr. Informatica Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment.
• Involved closely with the team implementing logical and physical data modeling with STAR schema techniques using Erwin in Data warehouse as well as in Data Mart.
• Involved in the Administration and maintenance of the Informatica Repository.
• Followed the SDLC Agile methodology.
• Working with the Business Analysts and the QA team for validation and verification of the development
• Worked extensively on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.
• Extracted data from flat files, SQL Server 05, XML Files data using Informatica Power Connect and performed massive data cleansing applying all the business rules prior to loading them into Oracle staging tables.
• Extensively used Informatica Power Center to load data from MS SQL Server, SAP- R/3 and DB2, into the target Oracle.
• Implemented data load from different type of source like Flat File, Relational Database, Oracle Logs using Informatica Power Exchange.
• Performed Data Profiling and created User Defined Functions (UDF) /process to handle null fields with default values for string, date and number.
• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Used PMCMD, PMREP and UNIX shell scripts for workflow automation and repository administration.
• Created Data Breakpoints & Error Breakpoints for debugging the mappings using Debugger.
• Implemented Slowly Change Dimension Type I & II to capture history and created process flow chart for insert/update using effective end date while loading data into the data marts.
• Developed shell scripts, PL/SQL scripts, T-SQL scripts, Stored Procedures for regular Maintenance and Production Support to load the warehouse in regular intervals and to perform Pre/Post Actions.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Developed BI Publisher reports as per the User requirements.
• Familiar with batch scheduling using Autosys.
• Played major role in Bug fixing & Production Support.

Environment: Informatica Power Center 8.1/8.5/8.6, Informatica Power Exchange 8.1, Informatica Power Connect, Oracle 10g, MS SQL Server 2005/2008, SSIS, SQL Server 05, Autosys, Toad 9.0.1, Erwin 4.2, Unix, Siebel CRM, SQL Developer, SQL, T-SQL, PL/SQL.

Confidential

Informatica/SQL Developer

Responsibilities:

• Extensively involved in Gathering requirements by holding meetings with users.
• Constructed context diagrams and data-flow diagrams based on a description of a business process. Analyzing the data model and identification of heterogeneous data sources.
• Constructed an extended entity relationship diagram based on a narrative description of a business scenario.
• Created the Source and Target Definitions using Informatica Power Center Designer.
• Used Informatica Power center to load the data into data warehouse.
• Development of Informatica mappings and Mapplets and also tuned them for Optimum performance and dependencies.
• Created reusable Transformations for modifying data before loading into target tables.
• Created mapplets in the Informatica Designer which are generalized and useful to any number of mappings for ETL jobs.
• Created Transformations using the SQL script to modify the data before loading into tables.
• Created and used mapping parameters, mapping variables using Informatica mapping designer to simplify the mappings.
• Used the Business objects features Slice and Dice and Drill Down for multi dimensional analysis.
• Scheduled various daily and monthly ETL loads using Control-M.
• Inserted Objects, Conditions, classes, subclasses and user objects according to client’s requirement.
• Prepared SQL Queries to validate the data in both source and target databases.
• Managed the database objects Indexes, Triggers, procedures, functions, packages, cursors.
• Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Worked in Monitoring & Production Support Activities.

Environment: Informatica Power Center 8.1/8.6, Oracle 10g, Sql Server, TOAD, Control M, Windows NT and UNIX.