SUMMARY

• Around 8+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial, Telecom and Manufacturing Sectors.
• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse, ETL, OLAP, BI, Client/Server applications.
• Strong Data Warehousing ETL experience of using Informatica 9.x/8.x Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Strong experience in Installing and ManagingInformaticaPower Center, Data Quality(IDQ), Metadata Manager(MM), Test Data Management(TDM).
• Extensive knowledgewithInformaticaMDM 10.1/9.x,Power-Center9.x,and 8.x hostedonUNIX, Linux.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Extensive testing ETL experience using Informatica 9.x/8.x/7.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.
• Extensive knowledge on installation of Power Center on vApps and creating master template.
• Experiencein installation andconfigurationof coreInformaticaMDM Hub components suchas Hub console, Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ERwin and ER-Studio.
• Expertise in working with relational databases such as Oracle 11g/10g/9i, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Netezza.
• In Depth understanding and usage of TERADATA OLAP functions. Proficient in TERADATA SQL, Stored Procedures, Macros, Views, Indexes Primary, Secondary, PPI, Join indexes etc.
• Have good understanding of Teradata MPP architecture such as Partitioning, Primary Indexes, Shared Nothing, Nodes, AMPs, BYNET, etc.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Working knowledge onInformaticaMDM (Siperian), IDD,SIF.
• Performing data standardization of addresses using Address Doctor, Trillium andInformaticaData Quality, data integration in real-time using SIF APIs.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Experience in using Automation Scheduling tools like Autosys and Control-M.
• Worked extensively with slowly changing dimensions.
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x (Designer, Workflow Manager, Workflow Monitor,Repository Manager and Informatica Server), SSIS

Informatica Tools: MDM 10.x, 9.x, MM, TDM, IDQ

Databases: Oracle 11g/10g, Netezza, MS SQL Server 2005/ 2008/2008 R2

Operating Systems: UNIX, Windows 2008/2007

Languages: Unix Shell Script, Power Shell, SQL, PL/SQL, T- SQL, C

Scheduling Tools: Control- M 6/7/8, Auto-sys, Tidal

Reporting Tools: Cognos, Tableau

Other Tools: Management studio, SQL Developer, TOAD, SQL Loader, ERWIN, HP-Console, TFS

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Sr Informatica MDM & IDQ Developer

Responsibilities:

• Building data quality rules & data profiling on the Customer, Product, Store data
• Implemented incremental load logic using job control and dynamic parameter file creation to load data from source to staging area for EDW and MDM.
• Implemented best standards/guidelines/Best practices and naming standards for IDQ/Powercenter/MDM environments.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings
• Worked with platform engineering team to build Informatica environment on the vCloud and created master templates
• Worked on installation, upgrade, configure and maintenance of Informatica components including Power Center, web services, Metadata Manager, Data Quality on UNIX/Linux servers.
• Installed and Configured Informatica Master Data Management (MDM) Hub along with Cleanse/Process servers
• Developed various mappings including cleanse functions to fetch data from multiple POS to stage tables and the address doctor to standardize data.
• Configure and deploy Informatica IDD application for data steward to modify and update MDM golden records as per business requirement.
• Installed and Configured Informatica Test Data Manager (TDM) for Data Subset, Data Masking and Data Generation
• Developed UNIX shell Scripts and PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Creating user groups, privileges and roles for the users using Security Access Manager (SAM) to maintain users on theMDMHub
• Prepared migration document to move the mappings from development to testing and then to production repository.
• Working on CreatingLanding,StagingandBaseObject Tables, anddefine Relationships, Match & Merge rules, Validation Rules, Batch Groups etc.
• Developed BTEQ scripts to load data from Teradata Staging area to Teradata data mart.
• Performance tuning for TERADATA SQL statements using huge volume of data.
• Setup LDAP accounts for data users, data stewards, production support etc.
• Perform various operations like clean, truncate, validate and execute batch process in SOAP UI through SIF Framework
• Used Hierarchy Manager to define Entities, Hierarchies, Relationship Base Objects, Packages, and validated the profile.
• Worked with platform engineer team in configuring, execution and scheduling of workflows/session in Control-M
• Optimized job schedules, analyze job failures, manage alerts on job failure and send email notification of failure session using Control-M.
• Experienced in creating IDQ mappings using Consolidation, Key Generator, Match, Merge, Exceptional, Labeler, Standardizer, Address Validator transformations with Informatica Developer and migrated to Informatica Power Center.
• Developed shell script and scheduled to take Informatica repository, Domain backup, poll source table and trigger Informatica jobs based on status
• Participate in the code migration (for MDM, PC) from lower environment to higher environment
• Worked on fine tuning Informatica long running mappings/sessions to meet the SLA
• Developed and scheduled shell scripts to take backup of Informatica Domain and Repository
• CreatedStandardmigrationchecklist&promotionalchecklistdocumenttemplate
• EducatedDevelopersontheuseofInformatica‘BestPractices’,whichwereemployedacrossthelifecycleofthe project
• InvolvedinReviewmeetingduringDesign&Developmenttoidentify,reduce/mitigateriskateverystage.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Provided 24/7-production support for Tableau users.

Environment: Informatica 9.5.1 (PowerCenter, DQ), Master Data Management (MDM) 10.1, SIF, JBoss, Unix,Oracle 11g, Teradata Utilities Multiload, FastLoad, FastExport,Control-M, SQL Server, Netezza, Tableau

Confidential, Corrollton, TX

Informatica MDM & IDQ Developer

Responsibilities:

• Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle.
• Closely worked with infrastructure & system admins to procure infrastructure for Master Data Management and PowerCenter.
• Extensively used Informatica Power Center to load data from heterogeneous sources like flat files, Oracle tables and SQL Server Tables.
• Designed and developed several Mapplets and Worklets for reusability.
• Performed batch operations for loading data into the Landing tables, Staging table and finally into the Base Object table. Used the existing IDQ cleansing rules by plug-in the same into MDM batch jobs.
• Enhancements Informatica mappings using various transformations such as Source Qualifier, Aggregator, Lookup (connected and unconnected), Update Strategy.
• Experience in creating Landing, Staging and Base Object Tables and defining Foreign Key relationships, Lookups in the Hub.
• Developed Mappings to move the data loaded from Landing to Stage by using various cleanse functionDevelop Hierarchies using Hierarchy Manager in the Hub.
• Apply security certificates, Setup LDAP accounts for data users, data stewards, production support, etc.Running the Stage Jobs, Load jobs, Match and Merge Jobs using the Batch Viewer and Automation Process (Tidal)
• Monitor daily sessions, check throughput, performance and provide necessary suggestions to improve performance of sessions/workflow.
• ETL design provided for error detection, reusable worklets to capture the workflow run time and intimate the user in case of any delay in the run.
• Documenting the process for various Informatica tasks like recovering workflows, Informatica installation, review-checklist document, naming standards, migration document etc.
• Working closely with the application developers, infrastructure, team leads, and customers to ensure all data services work assignments are completed on time and with the highest level of quality.
• Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
• Worked extensively on PL/SQL as part of the process to develop several scripts to handle different scenarios.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Prepared the error handling document to maintain the error handling process.
• Data governance application for Informatica MDM Hub that enables business users to effectively create, manage, consume, and monitor master data using IDD (Informatica Data Director).
• Automated the Informatica jobs using UNIX shell scripting.
• Closely worked with the reporting team to ensure that correct data is presented in the reports.
• Interaction with the offshore team on a daily basis on the development activities.
• Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Derived Column, and Data Conversion Transformations.

Environment: InformaticaPowerCenter9.5.1,Informatica/SiperianMasterDataManagement(MDM) Multidomain, IDQ,Jboss,AddressDoctor,Oracle11g, Tidal, UNIX, Sql Server Management Studio.

Confidential, Fort Wayne, IN

Informatica Consultant

Responsibilities:

• Key role playing in the Informatica9x upgrade, including providing requirements and training the team
• Created project plan for Informatica9x upgrade, created Test Plan and cases for the same.
• Participate/Initiate Informatica91 upgrade plan, working with System/Database admin for necessary hardware/software configuration to support Informatica9x version with GRID & HA/Load Balancing
• Working on the Informatica Installation, configuration, administration and providing 24X7 support
• Working on the customer requirement to make Production Server availability 100%, Improvement of the performance.
• Disaster Recovery (DR) setup & replication, active participation in performing DR exercise half-yearly and documenting the results.
• Understand the business enhancements and implement in the ETL design
• ETL design provided for error detection, create reusable worklets like Worklet Timer to capture the workflow run time and intimate the user in case of any delay in the load
• Create a reusable worklet for Real-time webservice create list based on the input parameters
• Implement workflow restart ability with in the reusable worklet
• Automate the yearly Informatica baseline metadata objects backup
• Automate password change compliance for Informatica User Ids (relational connection, database userid, etc)
• Extensively used various types of transformations such as Expression, Aggregator, Filter, Joiner, Update strategy, Lookup (Connected and Unconnected) in mappings to load the data.
• Apply Informatica 8.6.0 HotFix10 on all the nodes and perform health check for the servers
• Documenting the process for various Informatica tasks like recovering workflows, Informatica installation, review-checklist document, naming standards document etc.
• Working closely with the application developers, infrastructure, team leads, and customers to ensure all data services work assignments are completed on time and with the highest level of quality.
• Provide regular updates to the customer and team lead on the status of the work plan, projects, etc
• Ensure processes and appropriate documentation is in place around database design, implementation, testing and quality assurance.
• Deliver business value and satisfy customers. Directly support a 24/7 real-time operation

Environment: Informatica Power Center, Oracle 10/11g, Flat files, Unix, SQL Server, Informatica Admin Console, MM, Autosys

Confidential

Informatica Consultant

Responsibilities:

• Designed and developed the data transformations for source system data extraction; data staging, movement and aggregation; information and analytics delivery; and data quality handling, system testing, performance tuning.
• Member of warehouse design team assisted in creating fact and dimension tables based on specifications provided by managers.
• Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Aggregator, Expression, Joiner, Connected and Unconnected lookups, Filters and Sequence, External Procedure, Router and Update strategy.
• Designed and created complex source to target mappings using various transformations inclusive of but not limited to Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations.
• Extensively worked on Mapping Variables, Mapping Parameters and Session Parameters. Created post-session and pre-session shell scripts and mail-notifications
• Implemented effective date range mapping (Slowly Changing dimension type2) methodology for accessing the full history of accounts and transaction information.
• Design complex mappings involving constraint based loading, target load order.
• Use debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations and Create mapplets that provides reusability in mappings.
• Involve in enhancements and maintenance activities of the data warehouse including performance tuning, rewriting of stored procedures for code enhancements.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.

Environment: Informatica Workflow Manager, Designer, Monitor, Oracle 10g, MS-SQL Server, PL/SQL Developer, Unix, SQL Developer

Confidential

Informatica Developer

Responsibilities:

• Interacted with business analysts and translate business requirements into technical specifications.
• Using Informatica Designer, developed mappings, which populated the data into the target.
• Used Source Analyzer and Warehouse Designer to import the source and target database schemas and the mapping designer to map the sources to the targets.
• Responsibilities included designing and developing complex informatica mappings including Type-II slowly changing dimensions.
• Worked extensively on Workflow Manager, Workflow Monitor and Worklet Designer to create, edit and run workflows, tasks, shell scripts.
• Developed complex mappings/sessions using Informatica Power Center for data loading.
• Enhanced performance for Informatica session using large data files by using partitions, increasing block size, data cache size and target based commit interval.
• Extensively used aggregators, lookup, update strategy, router and joiner transformations.
• Developed the control files to load various sales data into the system via SQL*Loader.
• Extensively used TOAD to analyze data and fix errors and develop.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion

Environment: Informatica Power Center, Oracle 9i, PL/SQL, TOAD, Unix, Control-M.