SUMMARY

• A certified Informatica & Teradata Professional with a strong background in BI domain and 9+ years of core IT experience in Software Engineering, process & methodologies and management specializing in
• Strong Informatica Architect/Administration skills in installation, Upgradation and managing Informatica environments.
• Expert in setting up Informatica MDM Hub Console, Hub server, Cleanse/Process Server, JBOSS.
• Strong experience in Match & Merge rules, Landing/Stage/Base Loads, Hierarchy Manager, IDD, SAM.
• Expert in setting up Informatica Data Quality (IDQ) environment, building Profiles/Scorecards, mapping/rules, workflows, used transformations like Address Validator, KeyGen, Match, Consolidators etc.
• Hands - on experience in Informatica Metadata Manager (IMM), B2B Exchange.
• Expert in PowerCenter ETL code development (batch and real-time jobs) and Shell scripting. Well versed with Informatica Velocity Methodology
• Expertise in Informatica Cloud iPaaS, Building DSS, DRS, MCS, Templates for integration of various On-Premise & Cloud applications like SAP, SFDC, AWS S3, Twitter API, REST/SOAP API.
• Expert in setting up Complex event processing tool Proactive Monitoring for Power center (PMPC) 2.6 & 3.0 environment and creating complex rules to support business.
• Expert in setting up alert Monitoring, Failover mechanism, GRID, High Availability, preparing Disaster Recovery (DR) Design Plan for Informatica Power Center environments.
• Worked on integration with Flat files, XML, JSON, relational databases (like oracle, SQL Server, DB2, Sybase, Teradata) and POWER EXCHANGE for DB2, SAP, SFDC, Teradata and IBM WebSphere MQ.
• Experienced with setup for PowerExchange for SAP for ALE-IDOCS, SAP-R3 through ABAP, BAPI-RFC function and Power Exchange for CDC on RAC & Non-RAC Oracle Database and for LDAP, Greenplum.
• Implemented Code-Migration Automation or Object Deployment Automation (CMA) for Powercenter.
• Developed Operational Data warehouse for day - to-day reports for users and for Platform auditors.
• Experience in upgrading Power Center environments from 8.6 to 9.1 and 9.1 to 9.6.
• Well-experienced on L3 as well as L2 activities through Change Management process on IT ServiceNow.
• Expert in Informatica Data Services, Web Services-Real time, Batch service, Web service Hub.
• Experience in setting up native and AD authentication. Setting up user lock mechanism and creating weekly user audit report as a part of work.
• Experience in setup Third party scheduler like Appworx and Autosys for Informatica jobs.
• Expert in designing ETL & development solutions Architecture with lowest possible cost without compromising performance.
• Expert in performance analysis, memory analysis and Informatica code tuning.
• Good SQL knowledge on various versions of Teradata V2R5, R6, TD-12 and Oracle 9i, 11g.
• Experience in different Loaders Utilities like Teradata Fastload, Mload, Fastexport, Tpump, TPT, BTEQ, Oracle SQL *Loader, Greenplum gpload
• Worked with different BI tools like DELL BOOMI, Erwin, and Cognos Reports Studio, Tableau, IQ Insight
• Acquired experience in Data Migration projects.
• Conceptually strong in Data warehousing, Data Modeling and basic knowledge on Big Data concept and Operating System concept.

TECHNICAL SKILLS

Operating System: Windows NT, Windows 7,Unix, Linux

Databases: Oracle8i,9i,10g,11g, Teradata V2R5,R6,TD 12,MS SQL Server 2000,MS Access

Languages: C,C++,SQL,PL/SQL, Shell Scripting

ETL Tool: Informatica 8.x,9.x

CDC/Data Replication: CDC,HVR

BI Reporting Tool: Cognos Report Studio

Data Quality Tool: IQ Insight, Data Quality Inspector

3rd Party Tools/Packages: Toad, SQL Developer, SQL Assistant, PgAdmin, Putty, MS Office

PROFESSIONAL EXPERIENCE

Confendential - Cincinnati, OH

Informatica Architect

Responsibilities:

• Handling 5 Live environments with 15 repositories and 3 Proactive Monitoring environments.
• Leading a team of 14 (6 Onsite & 8 Offshore)
• Ensuring 24x5 production supports and reporting various production issues encountered by customer on daily basis.
• Perform Audit access; perform CPU & Memory analysis, Performance tuning at server level as well application level. Installed Hotfixes, Patches, Plug-ins.
• Participated in DR Drills and worked on scope of improvements.
• Preparing/Modifying ETL standards, Conducted Training sessions for Leadership team and Developers.
• Working with Informatica Vendor & Platform Leadership team for preparing future Road Map.
• Deployed Proactive Monitoring and set all required rules with Rulepoint to automate Code Review.
• Develop & Implement CMA (Code - Migration Automation) which saves nearly 15000 manual hours of effort and reduces Migration SLA to 1 hr from 3 days.
• Worked on POC on DELL BOOMI.
• Upgraded Informatica Powercenter environment from 9.1HF4 to 9.6HF2.

Environment: Informatica 9.6HF2, Linux x86, Oracle 11g, Teradata 12, Greenplum, Windows 7

Confidential - Cincinnati, OH

MDM Developer - Project Manager

Responsibilities:

• Installed and Configured Informatica MDM Hub Console, Hub Store, Cleanse and Match Server, Address Doctor, Informatica Power Center applications.
• All facets of MDM implementations including Data Profiling, metadata acquisition, data migration validation, reject processing and pre landing processing
• Performed requirement gathering analysis design development testing implementation support and maintenance phases of both MDM and Data Integration Projects
• Created landing tables, Staging tables, Base Objects as per the data model and data sources
• Developed mappings using various cleanse functions and Address doctor functions to move data into Stage tables
• Defined Trust Score, Validation rules, Match rules and Merge settings as per business.
• Closely worked with other IT team members business partners data stewards stakeholders steering committee members and executive sponsors for all MDM data governance related activities
• Developed the IDD application building Hierarchies as per the business needs
• Worked with PowerCenter Designer Repository Manager Workflow Manager and Workflow Monitor
• Worked on Real Time Integration between MDM Hub and External Applications using Power Center and SIF API for JMS
• Created complex transformations and mappings, processed tasks scheduling, sessions importing/exporting repositories in power center.
• Experienced in creating workshops with data stewards and business owners on match rules, tuning IDD configurations and Trust scores and validations.

Environment: Informatica Multidomain MDM 9.7.0, JBoss 5.1, Oracle 11g R2, Address Doctor 5, IDD, SIF, Toad, SQL Developer, Windows 7

Confidential - Cincinnati, OH

IPaaS Architect

Responsibilities:

• Installation of Agent in Linux & Windows.
• Presented recommendation on implementation of IPaaS and benefits of using it.
• Migration of almost 200 PC mappings to ICS tasks.
• Lead integration between AWS and Salesforce.com.
• Built Mapplet / Template to be used within the ICS DSS Synchronization Tasks
• Developed Complex PowerCenter Web Services and Rest Api mappings for various Real Time
• ICS Task Flows and PowerCenter Workflows.
• Developed Real Time ICS DSS /DRS Tasks for Salesforce.com
• Installed and configured ICS Secure Agent.
• Administered the ICS code migration between the Non-Prod/Prod environments.
• Supported Commercial Billing System integration on IPaaS platform.
• Engaged in data injection into Commercial Data Lake from various sources which becomes the source for this analytics application.

Environment: Informatica 9.x, IPaaS, Linux x86, Oracle 11g, SFDC, AWS, Windows 7

Confidential

Informatica Architect

Responsibilities:

• Installed and Configured IDQ 9.5.1 environment.
• Created Profiles (Column Profiling, Rule Profiling) Data Objects prepared Scorecards for Data Stewards.
• Used Labeler, Standardizer, KeyGen, Match, Consolidation, Address Validator and Parser to develop various mappings.
• Converted IDQ mappings/workflows and deployed them to applications.
• Created UDT using parser for Excel to XML in Data Studio.

Environment: Informatica IDQ 9.1, Powercenter 9.1HF4, Linux x86, Oracle 11g, Greenplum, Teradata 12, Windows 7

Confidential

ETL Architect

Responsibilities:

• Leading a team of 9 persons (4 From Mexico, 1 from USA, 4 from India).
• Performance tuning of existing loads. It includes understanding of data flow, business & deep analysis of ETL code as well as Database code.
• Review of any new ETL code, developed for PGS.
• Discussion with users to gather adhoc requirement.
• Preparing TDD (Technical Design Document), BRD (Business Requirement Document), HLD & LLD.
• Involvement in Data Architect activities like maintaining map on source data for key users.
• Defined & Created support Central workflow to track End-to-End activity starting from requirement gathering to Report Sign-Off.
• Involved in POC activities on HVR project.
• Testing of 3000 Cognos reports upgradation from version 9.0 to 10.0 using LCM (Lifecycle Manager) tool.

Environment: Informatica 8.6, UNIX Sun Solaris, Teradata V2R6, TTU-8, Teradata SQL Assistant, Bteq, Fastload, Mload, Oracle 9i, 11g, SQL, PL/SQL.

Confidential

Solution Architect

Responsibilities:

• Involved in discussion with Plant engineers and Confidential IT persons to understand the simulation logic of converting CDF format.
• Written C code of 6,000 lines to prepare pre-Processor on UNIX to convert CDF format to readable format, prior to loading to EDW-Teradata maintaining data security.
• This C code is now being used as a reusable component in different assignments, involving extracting CDF data from different test Cells
• In phase -2, Written Bteq & Loaders embedded Shell scripts to automate control complete data flow (20 Stage loads, 12 Dimension loads and 6 Fact loads) with Audit log capturing and error-handling strategy.

Environment: Informatica 8.6, UNIX Sun Solaris, Teradata V2R6, TTU-8, Teradata SQL Assistant, Bteq, Fastload, Mload.

Confidential

Informatica Team Lead

Responsibilities:

• Analysis of existing Oracle Code, Informatica Code and its upstream & downstream applications.
• Analyzed existing logical Data model using Erwin and converted to physical data model in Teradata
• Migrated all Oracle tables to Teradata as per new architecture.
• Converted nearly 80 complex Oracle procedures to Informatica Logic and implemented them.
• This migration resulted space saving of 100GB/Month and a huge performance improvement by a factor of 10: 1 for many loads and (1Hr: 1 Min.) for few of loads.

Environment: Informatica 8.6, UNIX Sun Solaris, Teradata V2R6, TTU-8, Oracle, Bteq, Fastload, Mload.

Confidential 

Informatica Developer

Responsibilities:

• Analysis of the requirements provided by the client.
• Designing and Developing Informatica mappings.
• Preparing unit test reports and other documents.
• ETL loading (Loading data from the source to the target databases).
• Job monitoring and capturing statistics.
• Identifying the Errors and Database issues.
• Analysis of each field in existing reports and did revere engineering on those elements.

Environment: Informatica 7.X, 8.x, Unix/Linux, Perl, DB2 UDB