SUMMARY

• Over 13+years of IT experience in Data warehousing and Data Migration projects, primarily as specialist in performing Analysis, Design, Development, Testing, Implementation, Migration, Deployment, Enhancement and Maintenance of Informatica ETL solutions in Production and Non - Production Environments.
• 13+ years of strong development experience working wif various Informatica (MDM, IDQ, PowerCenter, Metadata Manager, Address Doctor, etc), Database tools
• Strong experience in Developing/Administrating of Informatica (PowerCenter, IDQ, MDM, IDD, MM, DA, etc) various versions
• Extensive experience wif Informatica MDM,Power Center9.x,8.x,7.x,and6.x, Power Exchange hostedon UNIX, Linux,Solaris,AIX, etc platforms.
• Also installed HF, EBF & vendor provided product patches
• Configured Landing Tables, Staging, BO Tables, Look-ups, Cleanse Lists, Cleanse functions, Mappings, Audit trail/ Delta detection.
• Developed Mappings to move teh data loaded from Landing to Stage by using various cleanse functions.
• Worked closely wif teh Business in gathering teh Match rules and created teh Match rule document
• Configured Match & Merge Rules (Exact and Fuzzy) for consolidation process, Validation Rules and Trust scores respective of their BO tables.Working wif Hierarchy Manager to develop to Hierarchies as per teh business needs.
• Creating IDD application as per teh business needs by creating teh subject area and subject area groups.
• Implemented Data Quality Rules, and created Dashboard along wif PowerCenter & MDM
• Maintaining,supportingInformaticaenvironmentsforHighAvailability,LoadBalancing and DisasterRecovery(DR).
• PerformedInformaticaadministrativetasksusingInformaticaRepositorymanagerandAdmin console.
• AutomateInformaticaServicerecycleprocess,automate/replicatefilesystembackupandreplicateit toDR server
• Informatica PowerCenter Administration for Development, Test regions & Production Environment
• Experience in working on teh B2B Data Transformation using CM Console command
• Has good noledge setting up teh environment on teh Citrix servers
• Established process to streamline changes and approval mechanisms to ensure SOX compliance
• Providing solutions at teh Data Warehouse Architect level
• Defined, documented and implemented development standards, best practices, Configuration and change management mechanisms.
• Gathering functional specifications and business requirements and performing source system analysis, Data profiling.
• 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, and load) mappings, reusable components and performing power center administrative tasks.
• 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.
• 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 wif various source systems Oracle, Teradata, SQL Server, DB2 UDB/OS 390, Microsoft Access, Sales Force, Power Exchange for Main Frames and Flat Files in Informatica
• Expertise in trouble-shooting production issues by root cause analysis to identify teh problem, impact analysis to determine teh dependencies and providing teh resolution.
• Experience in identifying performance bottle necks and fine tuning Informatica jobs.
• Experience in writing Unix Shell scripting.
• Committed individual wif excellent interpersonal, analytical and communication skills
• Ability to work simultaneously on multiple projects, work independently as well as a team member and as a team lead.
• Involved in Review meetings during Design & Development to identify, reduce/mitigate risk at every stage.
• Educated Developers on teh use of Informatica’s ‘Best Practices’, which were employed across teh life cycle of teh project.
• Used Type 2 SCD Mapping to insert new Dimensions and update Dimensions in teh Target and maintain teh history.
• Worked on Performance Tuning of various mappings and sessions to identify and remove Bottle Necks.
• Documentation of mappings, sessions, sources and Targets involved in teh ETL process.
• Wrote UNIX and PL/SQL scripts for pre & post session processes and to automate daily loads.
• Experience in using third party tools like Toad, PL/SQL developer, Win SQL, Lotus notes, WinSCP.
• Experience in replicating data from different sources to different targets like AS/400, Oracle, SQL Server.

PROFESSIONAL EXPERIENCE

Confidential, Carrollton, TX

Sr. Informatica MDM/ETL Consultant

Responsibilities:

• Installed/Configured Informatica MDM Multidomain 10.x on Jboss Application server along wif cleanse adapters for IDQ & Cleanse/Process Servers, AddressDoctor
• Configured Landing, Staging, BaseObject Tables, Look-ups, Cleanse Lists, Cleanse functions, Mappings, Audit Trail/Delta Detection. Developed Mappings to move data from Landing to Stage by using various cleanse functions
• Worked closely wif Business in gathering Match rules & created Match Rule document. Configured Match & Merge Rules (Exact & Fuzzy) for consolidation process, Validation Rules, Trust scores respective for their BO tables
• Working wif Hierarchy Manager to develop to Hierarchies as per teh business needs. Creating IDD application as per teh business needs by creating teh subject area and subject area groups
• Developed Put and Get packages for both Hierarchy Manager and IDD Application. Created Batch jobs for Land, Stage and Load Process (Batch Process). Worked on SAM for Roles, Assign Users, setup LDAP
• Used Metadata Manager to Import/Export of Metadata & Promote Incremental changes between environments. Worked on platform engineering team to build Informatica environment on teh vCloud and created master templates
• GUI development based on Data Stewardship requirements. Coordinated wif functional users for User Acceptance Testing prior to releasing system changes in production. Worked on Shell Script, Troubleshoot teh app issues
• Expertise wif Install, upgrade, configure and maintain Informatica components including Power Center, web services, HA Grid, Metadata Manager, Data Quality on UNIX/Linux servers. Created IDD dashboard using HM & building IDQ rules/profiling

Confidential, Houston, TX

Sr. Informatica MDM Administrator/Developer

Responsibilities:

• Installed Informatica Multidomain 9.7 on teh WebSphere application, also setup Informatica Data Quality services for Profiling & Data Quality Rules to cleanse teh data. Configured cleanse servers along wif address doctor
• Troubleshoot application and environment related issues. Worked on Security Access Manager (SAM) for Roles, Assign Users and setup LDAP then grant tools access for Stewards, Developers, BA, etc.
• Used Metadata Manager tool to promote changes between environments. Worked wif platform engineering team to build Informatica environment stable & high available
• Setup third party application (Control-M) to schedule Informatica MDM Batch job process along wif error handling and restart batch job based on teh error code & setup notification for failures
• Built Data Quality rules and generated dashboard using services. Extensively used Informatica Developer tool to build rules and mappings. Work on PowerCenter mappings to load data into landing tables & data exchange hub
• Worked on Creating Landing, Staging and Base Object Tables, and define their Relationships along wif mappings for data load in to Stage tables. Define Match, Merge & Validation Rules, Batch Groups/jobs/schedules, etc
• Provided ETL design for error detection, reusable worklets to capture teh workflow run time and intimate teh user in case of any delay in teh run. Developed Shell script to monitor teh workflow/jobs & notify users
• Closely worked various teams in teh organization (infrastructure, database, application & system admins) to procure infrastructure for Master Data Management & PowerCenter/DataQuality/Metadata Manager

Confidential, Cambridge, MA

Sr. Informatica Consultant

Responsibilities:

• Main responsibilities to work on PoC’s for various Informatica products like Informatica PowerCenter9.5 upgrade, Implement Metadata Manager and Master Data Management
• Install & Configure various Informatica Products for PoC’s like Informatica PowerCenter, Metadata Manager for Oracle Security enabled databases & MDM Multidomain edition. Provide demo for various Informatica Product tools for business & project teams
• As part of MM implementation, create resources for various data models like Oracle, PowerCenter, Cognos, SQL Server & rules. Also worked on teh Informatica upgrade version from 9.5 to 9.6 and complete teh upgrade ontime
• Worked on teh Performance issues wif teh existing PowerCenter Production jobs in order to complete jobs wifin teh SLA period. Review existing Informatica environments and provide recommendation to meet SLA’s
• ETL design provided for error detection, reusable worklets to capture teh workflow run time and intimate teh user in case of any delay in teh run. Prepared multiple Unix shell scripts for monitoring, backup, kill hung process, etc.
• Documenting teh process for various Informatica tasks like recovering workflows, Informatica installation, review-checklist document, naming standards, migration document etc.
• Working closely wif teh application developers, infrastructure, team leads, and customers to ensure all data services work assignments are completed on time and wif teh highest level of quality
• Troubleshoot environment issues and application related issues. Good noledge analyzing on teh core trace files and working wif teams

Confidential, Birmingham, AL

Sr. Informatica/MDM Consultant/Admin

Responsibilities:

• Worked wif infrastructure & system admins on infrastructure for MDM95, PowerCenter, DataQuality, Metadata Manager, Control-M, WebSphere application & AddressDoctor
• Installed/Upgraded/Configured PowerCenter, IDQ, MDM Multidomain Hub Console on WebSphere application, Cleanse Match Server, Informatica Data Director in a clustered environment, etc.
• Prepared Punch List/Run Book/Naming Standards for MDM, PC/ETL & IDQ, documented all teh installations to use for higher environment installs and provide teh guidance to teh System operations team to continue installs in teh Prod environment
• Configure Load Balancer for MDM on a non-clustered environment through F5. Apply security certificates, Setup LDAP accounts for data users, data stewards, production support, etc.
• Experience in creating Landing, Staging and Base Object Tables and defining Foreign Key relationships, Lookups in teh Hub. Developed Mappings to move teh data loaded from Landing to Stage by using various cleanse function
• Define Match & Merge rules, Define Validation Rules, Define Batch Groups, etc. Running teh Stage Jobs, Load Jobs, Match and Merge Jobs using teh Batch Viewer and Automation Process (Control-M)
• Troubleshoot environment & application related issues, provide L2/L3 24X7 application support for various Informatica tools and available on call support for Production related issues
• Provide database sizing estimates for MDM, Provide file system sizing for application server. Generate ICR (Implementation checklist report) Report for MDM application

Confidential, Birmingham, AL

Sr. Informatica Administrator/Developer

Responsibilities:

• Played key role in teh Informatica9.x version upgrade, including creating Project/Test Plan for upgrade, gathering requirements & training internal teams also work wif System/DB admin for necessary HW/SW configuration to support GRID/HA/LB
• Worked on teh Informatica Installation, configuration, administration and provide 24X7 support. Worked on teh customer requirement to make Production Server 100% availability
• Disaster Recovery (DR) setup & replication, active participation in performing DR exercise half-yearly and documenting teh results. Same time work wif multiple teams to resolve/analyze/troubleshoot production incident
• Good in extracting stack trace out of Informatica generated core dump also good in troubleshooting teh core file. Understand teh business enhancements and implement in teh ETL design accordingly
• Development of new Informatica mappings using various transformations such as SourceQualifier, Aggregator, Lookup, UpdateStrategy, Webservice, etc. Ensure strategic initiatives, new technologies & tools are understood & integrated into daily work
• Provided ETL design for error detection, capture & notify long running workflows using various workflow tools like Worklet, Timer, Assignment, etc. Worked on reusable worklet for Real-time Webservice list generation based on teh input parameters
• Automate SOX password change compliance for Informatica User Ids (relational connection, database userid, etc.). Convert teh DTS jobs into Informatica, Convert teh AspenTech & SIRAM jobs to use Informatica Real-time web services
• Document teh process for various Informatica tasks like recovering workflow, installation, review-checklist document, naming standards document etc. Provide regular updates to teh customer and team lead on teh status of teh work plan, projects, etc.

Confidential, Minneapolis, MN

Sr. Informatica Administrator/Consultant

Responsibilities:

• Supported 85+ Applications involving different kinds of databases (Oracle, DB2, Teradata, Mainframes, Netezza), source-targets, transformations, file transfer protocols (ftp, sftp, mft) etc. Informatica PowerCenter Administration for Dev/Test/Prod
• Supporting & Maintain 30+ different Informatica & database servers which are running on multiple OS (AIX, Linux, Solaris, Windows). Handling environmental issues & resolve them by coordinating wif Informatica Support
• Maintaining 100% availability of Informatica environment for Project teams, Performed annually Disaster Recovery (DR) exercise. Implementing and Maintaining Security and User Access control. Migrating /Code as a part of teh Project Implementation
• Install/Upgrade & Configure Informatica Tools on Server & Client. Power Center 9.x, 8.x, 7.x on multiple OS (AIX, RedHat Linux, Solaris, Windows, etc.). Power Exchange for Mainframes, Salesforce, Lotus Notes
• SFDC Bulk API Connector for Salesforce. Debug Install patch for Informatica Product debug for any Prod issues. Install different vendor provided patches, HF, EBF, etc. Teradata provided drivers (Teradataâs, TDICU, TDODBC, etc.)
• Install & Configure multiple tools on teh Informatica Server for monitoring like OpsNet, SiteScope, MetaQuery, Tivoli Script/Monitoring tool, Informix Driver Install, MQ, PGP
• Working wif multiple vendor teams to resolve, troubleshoot ongoing issues, understand teh new patch & implement (Informatica, Teradata, Network, IBM vendors). Established process to streamline changes & approval mechanisms to ensure SOX compliance
• Working on new infrastructure for Informatica Rehost on teh Informatica 910 version on teh different Data Center. Co-ordinate, provide support to multiple teams wifin teh organization (like support, development, enhancement, maintenance)

Confidential

Sr. Informatica Administrator & Tech Lead

Responsibilities:

• Providing solutions at teh Data Warehouse Architect level. Involved in DWH/Data mart implementations including project scoping, requirements gathering, Modeling, Star & Snowflake Schema design
• Installed Informatica Power Center & configured for Development, Testing, Stage & Production Repositories. Implementation of Informatica Grid Architecture on Veritas Clustered Shared Servers (VCS)
• Configured Integration service on Grid & setup HA 7 successfully tested HA on multi node. Reviewed existing configuration parameters of teh PowerCenter Server and provided recommendations for improving teh ETL processes
• Implemented folder structure at teh domain level and in teh repository. Installing Oracle and creating database instance. Automating export, import, oracle monitoring, and space monitoring using sell scripts
• Assisted development team in performance tuning, trained on teh PowerCenter 8.1 & Metadata Manager version. Created Standard migration promotional checklist template
• Understanding existing Business rules & dataflow to populate teh Decision-Making Information into new era EDW. Supervised teh Offshore development activities
• Created migration strategies & change control for Informatica Repositories and database objects across multiple environments. Developed & implemented performance tuning strategies for mappings and sessions across all developed Informatica Components
• Developed templates used for teh documentation of overall ETL architecture and development strategies. Participated in teh design and implementation efforts for teh creation of near real-time data feeds to some of teh Applications in TFS

Confidential, Columbus, OH

ETL Informatica Developer & Tech Lead

Responsibilities:

• Created teh Informatica mappings to extract teh data from Oracle and load into Target OLAP database
• Developed various Mappings, Mapplets, and Transformations for data marts and Data warehouse
• Performed extensive Unit Testing on teh developed Mappings and was also involved in teh documentation of Test Plans and testing wif teh users (UAT)
• Provided application support & maintenance for various Informatica applications
• Responsible for validating teh Informatica mappings against teh pre-defined ETL design standards
• Provided Knowledge Transfer to teh end users and created extensive documentation on teh design, development, implementation, daily loads and process flow of teh mappings
• Managed Change control implementation and coordinating daily, monthly releases and reruns
• Involved in Performance Tuning of teh Informatica mappings using various components like Parameter files and Variables

Confidential 

ETL Informatica Developer

Responsibilities:

• Worked on Data warehouse for Risk Information Store (RIS) application development using Informatica PowerCenter tool
• Created Complex mappings using Connected and Unconnected Lookups, Aggregate, Update Strategy, Stored Procedure and Router transformations for populating target table in efficient manner
• Involved in Performance Tuning of teh Informatica mappings using various components like Parameter files and Variables
• Performed Tuning by identifying and eliminating teh bottlenecks occurred for increasing teh performance
• Extensively used almost all of teh transformations of Informatica including lookups, expression, update strategy, source qualifier, router, filter and others
• Troubleshoot teh Informatica mappings using Informatica Debugger tool and resolving teh all teh performance issues
• Responsible for validating teh Informatica mappings against teh pre-defined ETL design standards
• Performed Informatica mapping/session/workflow code review process for other team members wifin teh projects