SUMMARY:

• Around 8+ years of IT experience with demonstrated expertise in analysis, design, development, implementation, testing, and maintenance of application systems used in Finance, Retail, Manufacturing Sectors
• Strong Data Warehousing ETL experience using Informatica 9.x/8.x PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Extensive knowledge with Informatica MDM 10.1/9.x, Power-Center 9.x, and 8.xhosted on UNIX, Linux
• Strong experience in Installing and Managing Informatica PowerCenter, Informatica MDM, Data Quality(IDQ), Metadata Manager(MM), Test Data Management(TDM)
• Experience in Informatica Administration includes Installation, Upgrades, and Applying Hot Fixes, Configuration, maintenance and troubleshooting.
• Expertise in Data Warehouse, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, ETL Design, development and production support
• Experience in installation and configuration of core Informatica MDM Hub components such as Hub console, Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter
• Performing requirement gathering analysis design development testing implementation support and maintenance phases of both MDM and Data Integration Projects
• Configured Landing Tables, Base Objects, Relationships, Staging Tables, Mappings, custom cleanse functions, Hierarchy Manager, Match and Merge settings, Trust and Validation Rule
• AutomateInformaticaServicerecycleprocess,automate/replicatefilesystembackupandreplicate ittoDR server
• Extensively worked on multiple Informatica versions & installed multiple versions on the sameservers (due to business requirement) without impacting performance, availability
• Proficient in converting business requirements to technical specifications and creating design documents and mapping documents.
• Strong experience in designing and developing complex ETL (extract, transform, load) mappings, reusable components and performing power center administrative tasks.
• Build Efficient ETL packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes
• Experience in defining testing strategies, creating test cases for unit, functional and integration testing, documenting test results.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes, schedule script to take backup different domain, repository
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using Erwin
• Expertise in defining and documenting ETL Process flow, job execution sequence, parameter file requirements, Job scheduling and alerting mechanisms using command line utilities.
• Proven experience working with various source systems Oracle, Netezza,SQLServer,MicrosoftAccess and Flat Files in Informatica
• Performing data standardization of addresses using Address Doctor, Trillium and Informatica Data Quality, data integration in real-time using SIF APIs.
• Gathering functional specifications and business requirements and performing source system analysis, Data profiling.
• Proficient inconverting business requirements to technical specifications and creating design documents and mapping documents.
• Extensive experience in implementing error handling, auditing and reconciliation and balancing mechanisms in ETL process
• Experience in defining testing strategies, creating test cases for unit, functional and integration testing, documenting test results.
• Extensively used Control-M, Tidal, Autosys for scheduling the UNIX shell scripts and Informatica workflows.
• Experience in using third party tools like Toad, PL/SQL developer, Win SQL, Lotus notes, Win-SCP

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, Carrollton, TX

Informatica Tech Lead

• Responsible for Business Analysis and Requirements Collection. Parsed high-level design specification to simple ETL coding and mapping standards
• Implemented incremental load logic using job control and dynamic parameter file creation to load data from source to staging area for EDW and MDM
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings
• Used Type 2 SCD Mapping to insert new dimensions and update dimensions in the target and maintain the history.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Worked oninstallation, upgrade, configure and maintenance ofInformatica components including Power Center, web services, Metadata Manager, Data Quality on UNIX/Linux servers.
• Developed various mappings including cleanse functions to fetch data from multiple POS to stage tables and the address doctor to standardize data.
• Installed and Configured Informatica Master Data Management (MDM) Hub along with Cleanse/Process servers
• 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.
• Prepared migration document to move the mappings from development to testing and then to production repository.
• Working on Creating Landing, Staging and Base Object Tables, and define Relationships, Match & Merge rules, Validation Rules, Batch Groups etc.
• 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
• 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
• Created Standard migration checklist & promotional checklist document template
• Educated Developers on the use of Informatica ‘Best Practices’, which were employed across the life cycle of the project
• Involved in Review meeting during Design & Development to identify, reduce/mitigate risk at every stage

Environment: Informatica 9.5.1 (PowerCenter, DQ), Master Data Management (MDM) 10.1, SIF, JBossUnix, Oracle 11g, Control-M, SQL Server, Netezza

Confidential,MI

Informatica Consultant

• 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.
• 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 function
• Develop 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
• 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.

Environment: Informatica Power Center 9.5.1, Informatica/Siperian Master Data Management (MDM)Multidomain,IDQ, Jboss, AddressDoctor, Oracle 11g, Tidal

Confidential,Fort Wayne,IN

Informatica Consultant

• KeyroleplayingintheInformatica9xupgrade,includingprovidingrequirementsandtrainingtheteam
• CreatedprojectplanforInformatica9xupgrade,createdTestPlanandcasesforthesame.
• Participate/InitiateInformatica91upgradeplan,workingwithSystem/Databaseadminfornecessary hardware/softwareconfigurationtosupportInformatica9xversionwithGRID&HA/LoadBalancing
• WorkingontheInformaticaInstallation,configuration,administrationandproviding24X7support
• WorkingonthecustomerrequirementtomakeProductionServeravailability100%,Improvementofthe performance.
• DisasterRecovery(DR)setup&replication,activeparticipationinperformingDRexercisehalf-yearlyand documentingtheresults.
• UnderstandthebusinessenhancementsandimplementintheETLdesign
• ETLdesignprovidedforerrordetection,createreusableworkletslikeWorkletTimertocapturetheworkflow runtimeandintimatetheuserincaseofanydelayintheload
• CreateareusableworkletforReal-timewebservicecreatelistbasedontheinputparameters
• Implementworkflowrestartabilitywithinthereusableworklet
• AutomatetheyearlyInformaticabaselinemetadataobjectsbackup
• AutomatepasswordchangecomplianceforInformaticaUserIds(relationalconnection,databaseuserid, etc)
• ExtensivelyusedvarioustypesoftransformationssuchasExpression,Aggregator,Filter,Joiner,Update strategy,Lookup(ConnectedandUnconnected)inmappingstoloadthedata.
• ApplyInformatica8.6.0HotFix10onallthenodesandperformhealthcheckfortheservers
• DocumentingtheprocessforvariousInformaticataskslikerecoveringworkflows,Informaticainstallation, review-checklistdocument,namingstandardsdocumentetc.
• Workingcloselywiththeapplicationdevelopers,infrastructure,teamleads,andcustomerstoensurealldata servicesworkassignmentsarecompletedontimeandwiththehighestlevelofquality.
• Provideregularupdatestothecustomerandteamleadonthestatusoftheworkplan,projects,etc
• Ensureprocessesandappropriatedocumentationisinplacearounddatabasedesign,implementation,testing andqualityassurance.
• Deliver business value and satisfy customers.Directlysupporta24/7real-time operation

Environment: InformaticaPowerCenter,MasterDataManagement(MDM),Oracle10/11g,Flat files, Unix, SQLServer,InformaticaAdminConsole, MM,Autosys

Confidential,AL

Developer - Graduate Assistant

• Involved in DBA and IDEAS Development System using PL/SQL, and SQL working an average of 20 hours per week while maintaining a 3.67 GPA.
• Involved in data modeling and implementation of CHOICE application using Microsoft Relational Database Management System (RDBMS).
• Worked on integration of various modules in .NET applications and deployed to Microsoft Internet Information Service (IIS).
• Worked on establishment of connection between Microsoft SQL Server 2008 and IIS to access over the web

Confidential

Informatica Developer

• Upgraded to InformaticaPowerCenter 8.6.1 from version 8.1.1. Installed Hot fixes, utilities, and patches released from Informatica Corporation.
• Installed and configured Metadata Manager Service, Data Analyzer and Web Service Hub.
• Extensively worked on Informatica Mappings/Session/Workflows to load data from Oracle to TD and vice versa.
• Extensively worked on Informatica Performance tuning to find potential bottlenecks in the Source, Informatica and Target systems.
• Extensively worked on UNIX shell scripts on automation (Auto restart of servers, Disk space utilization, Informatica Server monitoring and UNIX file system maintenance and cleanup, and infacmd and pmrep operations).
• Worked on Informatica Mapping Architect for Visio to automate Mappings, Sessions and Workflow generation.
• Extensively worked on UNIX Shell scripts to launch jobs and to execute Job Control Table Process.
• Worked on UNIX shell scripts to handle Job Control Process.
• Worked on SQL queries to query the Repository DB to find the deviations from Company’s ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.
• Developed standard and reusable mappings and mapplets using various transformations like Expression, Aggregator, Joiner, Router, Lookup (Connected and Unconnected) and Filter.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.

Environment: Informatica Power Center 8.6.1/8.5.1, Oracle 10g, Flatfiles, UNIX, Control-M, MetaData Manager, Informatica Admin Console