SUMMARY

• Around 10+ Years of Strong experience on Designing, testing, deploying, and documenting the data quality procedures and their outputs in Data Quality and Data Analysis using with Informatica IDQ/IDE 8.x/ 9.1/9.5/9.6/10
• Extensively in Informatica Data Quality 9.5.1/9.6.1 and Informatica power center 9.x/8.x/7.x
• Extensively worked on Informatica Analyst tool 9.5.1/9.6.1 as initial phase
• Experience of working on Informatica Data quality tools like Integration with platform stage in MDM and Create Cleansing types Validation, standardization, Enrichment and Cleansing
• Implemented the Data Quality solution with the appropriate DQ Rules, Metrics and projects
• Experience in writing oracle SQL queries and PL/SQL procedures, functions and packages
• Implemented the Parser, Mapper, XMap to load the huge XML and Json files on Informatica B2B Data Transformation
• Extensive experience with ETL performance evaluation and tuning
• Experience on Installation and Configuration of IDQ HA environment on Grid
• Experience with Informatica Axon glossaries and Integrating them with Informatica EDC
• Expertise in Installation, Configuration, maintaining, enhancing Informatica suite of products like IDQ, Power Center, BDM, EDC and Axon tools
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center
• Experience in Production support management involving Informatica, Oracle, UNIX and Mainframes
• Worked with Involved in the designing of Landing, Staging and Base tables in Informatica MDM
• Involved in User Exits on Stage processes. Creating user, user groups, roles in MDM
• Used IDQ to perform Unit testing and create Mapplets that are imported and used in PowerCenter Designer
• Experience working on Informatica MDM to design, develop, test and review & optimize Informatica MDM.Worked with the offshore team lead and supervised on their development activity
• Excellent working experience in Data Warehouse applications, directly responsible for the Extraction, Transformation and Loading (ETL) of data from multiple sources into Data Warehouse
• Extensively worked on Informatica Data Quality and Informatica Power center throughout complete Data Quality and MDM projects
• Experience on automation of the IDQ and BDM profiles, Scorecards, mappings and workflows
• Establishes, enhances, implements, enforces, and maintains ETL, Data Quality and data integration best practices
• Experience in Informatica Administration, creating Users, Groups, Folders through Admin Console and migrating code from one environment to another
• Extensively in Informatica Data Quality 9.5.1/9.6.1 and Informatica power center 9.x/8.x/7.x
• Extensively worked on Informatica Analyst tool 9.5.1/9.6.1 as initial phase
• Excellent communication, presentation, project management skills, a very good team player and self - starter with ability to work independently and as part of a team.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5, Informatica MDM 10.1, Informatica Data Explorer (IDE), Informatica 9.5.1, Informatica Data Quality (IDQ), SSIS

Databases: Oracle 11g/10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, Netezza 5.0/6.0, XML, Teradata, SQL Server 2000/ 2005/ 2008 & MS Access

Languages: SQL, PL/SQL, VB, C, C++ & Java, SQL*Plus & SQL*Loader, UNIX Shell Scripting

MDM Packages: Informatica MDM 10.1,10.2,10.3 HF1 (MDM Hub, Informatica Data Director, Message Queues) Informatica MDM 10.1/9.1,IDD,SIF API

IDE: Eclipse, MS Visual Studio, NetBeans, WebStorm, Visual Studio Code, Sublime Text 3, IntelliJ

Operating System: Windows XP Professional/95/98/2000/XP/2010/Vista/Windows8 Mac OS, Linux, Ubuntu

Reporting/OLAP Tools: Business Objects XI 3.1, OBIEE 10.1.X Control-M, CA7 Schedule, CA ESP Workstation, Autosys, Informatica Scheduler

PROFESSIONAL EXPERIENCE

Confidential - Agoura Hills, CA

Sr ETL Informatica MDM Developer

Responsibilities:

• Co-ordinated with business users & client IT teams to analyze & understand business requirements
• Worked with architects to identify source & target attributes, data, reference data & relationships
• Responsible for end to end design, development, unit testing, migration of the ETL code for a crucial segment related to Informatica MDM Application
• Led ETL team & responsible for all ETL related deliverables ensuring timely deliveries with quality
• Design of Cust prime ORS DB schema to store customer prime hierarchy, name, address & different relationships
• Worked with ETL SSIS, ERWIN, PLSQL, Informatica PowerCenter, Data Analyst, EPIC, Facets, Informatica MDM, Informatica IDD
• Development of ETL incremental and onetime load processes using Informatica Power Center, which fetches relevant data from different platforms such as Teradata, MS SQL Server & Apache Impala, transforms according to various business rules, cleanses, standardizes & loads into the target
• Implemented real-time integration with MDM HUB using real-time batch processing for business data coming from four source systems
• Developed complex mapping using transformations such as Source Qualifier, Router, Filter, Expression, Sorter, Union, Aggregator, Joiner, Sequence Generator, Rank, Connected and Unconnected Lookup and Update Strategy, XML Parser, HTTP Transformation etc.
• Developed PowerCenter workflows with complex conditional execution & waiting logic, exception handling and email functionality etc.
• Developed custom retry mechanism in workflow executions (retry n times after failure of a session from failed session) and used informatica error log tables for logging row errors & rep task inst run & other repository views to get runtime job information
• Developed reusable IDQ mapplets for customer name & address cleansing & integrated with Informatica PowerCenter mappings
• Designing MDM packages, MDM external match rules for recommendation engine
• Create TSQL(PL/SQL) stored procedures, functions for realignment, matching & other processes
• Write complex analytical SQL queries for various data discrepancy analysis and data quality metrices
• Develop complex SQL queries for IDD packages for IDD application dashboards & bulk export reports
• Review query execution plans and optimize the performance of SQL queries by using appropriate joins, SQL hints, common table expressions, proper indexing, partitioning massive tables
• Follow standard guidelines & best practices for database driven development, perform code review, unit testing, QA, UAT and code migration support
• Created batch scripts, AutoSys JIL scripts for job scheduling
• Perform code reviews and other quality assurance steps as required
• Providing migration support, creating deployment instructions
• Work on root cause analysis of failed jobs and rejected records and provide resolution
• Resolve tickets related to prime data issue raised to L3 team.

Environment: Informatica Power Center 10.1.1, Informatica Cloud 10.1.1, Informatica DataQuality 10.1.1, Informatica MDM 10.1.1, Informatica Power Exchange, Informatica DVO, Power Connect, SQL Query Analyzer, SAP, DB2, Teradata, Netezza, SQL Server 2012, Toad, SQL Developer, Jitterbit Data Loader, Unix.

Confidential - Los Angeles, CA

Sr ETL Informatica MDM Developer

Responsibilities:

• Worked closely with business analysts to analyze business requirements
• Involved with architects on designing ETL data flow, data extraction rules and standardization rules
• Led team of 4 Informatica developers & took responsibility of all ETL related deliverables ensuring timely deliveries with quality
• Worked on customer data profiling using IDQ & SQL to identify data quality issues in customer data & worked on finalizing the data quality rules
• Designed Change Data Capture (CDC) logic to integrate customer data from different source systems to Informatica MDM & mechanism to publish data to outbound systems
• Designed Database components, relationships for MDM & DI layer to load and store customer information loaded from different systems
• Developed PowerCenter delta mappings, mapplets, workflows to load data in batch model as well as developed web service jobs for real-time data publishing
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, HTTP, Lookup, and Union to develop robust mappings in the Informatica Designer
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
• Improved performance of huge amount of customer data processing by implementing Informatica session level partitioning, range partitioning in intermediate table levels and created indexes on appropriate columns. This approach improved load performance by 300%
• Created IDQ mapplets involving transformations such as standardizer, parser, case converter etc. & Address Doctor (for address standardization) to cleanse & standardize data according to data quality rules
• Created IDQ webservice mappings to be consumed by external applications for data cleansing, & standardization
• Created IDQ scorecards for monitoring data issue by creating logical data objects & profiling them.
• Perform code reviews and other quality assurance steps as required
• Worked with business users QA team to create test cases and test execution plan & performed unit testing, provided QA/UAT Support
• Code migration & environment support.

Environment: Informatica Power Center 10.1, Informatica Power Exchange, Informatica Cloud Real Time, Informatica DVO, Oracle 12C, Greenplum, Flat files, SOAP, SAP, Workday, Toad, Business Objects, Get access, Box, Gnosis, Putty, Unix,UC4, Share Point.

Confidential - Seattle, WA

Sr Informatica Administrator

Responsibilities:

• Installation of Informatica suite of products (8.6/9.1/10.1 ) like PowerCenter, Data Quality, Power Exchange Server products on Linux Environment
• Install and the Enterprise Data Catalog (EDC) v10.2.1 on the Hadoop cluster nodes
• Configure Data Catalog services on the multi node Informatica domain
• Configure the prerequisite catalog databases like Model repository, profile warehouse and reference data ware house etc.
• Integrate with EDC & Data Quality for business glossary, score cards discovery
• Co-ordinate with developers to resolve the issues related to PWX CDC workflows in all the environments
• Upgrading the PowerCenter from 9.5 to the latest version 10.2 HF1
• Involved in setting up the data maps for different sources using Power Exchange Navigator
• Helped the projects teams for dbmover files and navigator to connect to cdc environments
• Keep the Informatica service up and running for Dev, QA, BAT and Production environments
• Provide 24/7 Support related to Administration tasks (Emergency Deployments, fatal errors on the Informatica Server, unexpected Informatica services failures, Repository issues etc.
• Prepared detailed cutover plan as part of upgrade project
• Upgraded the Informatica environment from 9.1 to the latest version 10.1.1
• Worked with various teams (unix, network,DBA Development & testing teams) as part of upgrade & testing
• Configuration, maintenance, technical support and troubleshooting of Informatica ETL Server implementation
• Work with the project group to identify the process bottlenecks and helping the Project to an amicable solution.
• Maintain all necessary updates and patches for the ETL environments
• Configure security (User/Groups, Roles, File system level) as per security design and configuration document
• Coordinate and prioritize all escalated activities, including testing, implementation of system upgrades, enhancements, and bug fixes
• Coordinate with different administrative services (like DBAs, Mainframe Admins, and Unix Admins) for the upkeep of the environment
• Involved in Software upgrades plan and manage Informatica software patching and upgrades
• Managing and monitoring the various Informatica services through Informatica Admin console and also through the Linux environment
• Perform regular administration tasks like migrations, setups, server accessibility requests, decommission and cleanup activities
• Work with Informatica technical support group regarding any unknown issues. Migrating the code from the development environment to the production environment following the change management process
• Provide POC environments for Various teams for PowerCenter, IDQ,Metadata Manager
• Involving Testing, Debugging, Validation and Performance Tuning of data warehouse, help develop optimum solutions for data warehouse deliverables
• Outage Handling - Notify the user group on scheduled outage during the weekend, bringing down the Informatica service and restarting once the change is done
• Regularly monitor the Informatica jobs, validate the target data with source files.

Environment: Informatica PowerCenter (v10.1/ v9.1/ v8.6/), Informatica BDM v10.1,Informatica Data Quality v 10.1/9.1/8.6 , Metadata Manager, Power Exchange for VSAM, Power Exchange CDC for Oracle, Power Exchange for MQ, SQL server 2008/2012, Business Objects, MS Share Point, Oracle 12c/11g, Tortoise SVN, Red Hat Enterprise Linux, Toad for Oracle v 12.6.

Confidential - Portland, OR

ETL Informatica MDM Developer

Responsibilities:

• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets
• Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager
• Created MDM mapping and configured match and merge rules to integrate the data received from different sources. Good experience user exits and JMS Queue
• Created various financial checkouts in IDQ for various amounts to match and validate as per the business and created scorecards to analyze the current process
• Involved in the entire SDLC (System Development Life Cycle) process that includes Implementation, testing, deployment and maintenance
• Tuned IDQ Development process to push the most of the process to database and removed unwanted ports and transformations
• Extensively worked for address validation and name matching (Standardization) task at IDQ
• Extensively worked on Informatica Designer and workflow Manager. Designed and developed various reusable mappings and Mapplets in Mapping designer and sessions and workflows in Workflow manager to extract data from various sources like DB2, Oracle, Flat files, SQL server and load to final EDW Oracle database
• Developed rules and mapplets that are commonly used in different mappings
• Used various transformations like Address validator, parser, joiner, filter, matching to develop the maps
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations
• Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager
• Worked on multiple projects using Informatica developer tool IDQ of latest versions 9.5.0 and 10.1.1
• Involved in migration of the mapps from IDQ to power center
• Applied the rules and profiled the source and target table's data using IDQ
• Developed the mappings, applied rules and transformation logics as per the source and target system requirements
• Worked on different environments with different source and target databases like Teradata, Oracle, and SQL server.

Environment: Informatica PowerCenter (v9.5/v9.6), Power exchange CDC(Change Data Capture) PowerExchange for IDMS, PowerExchange for VSAM, Informatica Data Quality, Master Data anagement (MDM),Test Data Management (TDM), Oracle 11g, SQL Server 2008, Tomcat/Apache Red Hat Enterprise Linux.

Confidential - Oklahoma, OK

ETL Informatica MDM Developer

Responsibilities:

• Communicating with business users to discuss the issues and requirements
• Involved in implementing the Land Process of loading the customer/product Data Set into Informatica MDM from various source systems
• Worked on data cleansing and standardization using the cleanse functions in Informatica Data Quality
• Developed several IDQ complex mappings in Informatica a variety of Power Center, transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica Power Center
• Profiled the data using Informatica Data Explorer (IDE) and performed Proof of Concept for Informatica Data Quality (IDQ)
• Used Informatica Power Center to load data from different data sources like xml, flat files, CSV, MS Acess and Oracle
• Debugging and Performance Tuning of sources, targets, mappings and sessions
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.

Environment: Informatica Power Center 9.6.1, IDQ 9.6.1,MDM, UNIX, Oracle, Shell, IDQ, PL/SQL, Erwin Tidal, Autosys, Oracle 11g/10g, Java, Teradata.