PROFESSIONAL SUMMARY:

• Around 9+ 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
• Optimize Stored Procedures, Indexing, Consistency Checks, performance tuning; SQL Server log shipping, SQL replication, scripting, Fine tune database, Function and trigger design and coding, Index implementation and maintenance, Clustering, Indexing, Informatics PowerCenter, Business Glossary, Informatica Data Quality, PowerCenter, Informatica Analyst/Metadata Manager ETL, SQL, Databases, Data Management, Data Warehousing, Data Governance concepts, data software development
• Experience with Informatica PowerCenter 9.x/8.x and Informatica Data Quality (IDQ) and databases such as Netezza, Oracle 10g/9i and MS SQL Server 2005/2014
• Performed POC for migrating from Oracle 11g to Amazon Redshift using AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service(AWS DMS).
• Designed Real - time Datawarehouse using CDC tool Informatica Power Exchange 9.5.1/8.6.1
• Work experience in Informatica EDC 10.2, Axon 5.4/6.0 & Azure cloud infrastructure & IICS.
• Extensively in Informatica Data Quality 9.5.1/9.6.1 and Informatica power center 9.x/8.x/7.x
• Extensive experience in Informatica V9.1, V8.6.1, V8.1.1, Oracle, SQL Server
• Extensive experience in all the phases of the Data warehouse life cycle involving design, development, analysis & testing of Data warehouses using ETL, Data Modeling & reporting tools
• Experience in gathering and documenting business requirements and converting them into ETL Design
• Extensive experience in Source system Analysis, understanding the source system architecture, data profiling, finding data anomalies and acting as a Source system Analyst
• Experience in Mapping Designer, Workflow Manager and Workflow Monitor testing, analysis and Performance Tuning in Power Center
• Experience with AWS, Azure, SFDC, Zuora and IICS Cloud Platforms.
• Good exposure with UNIX, Linux, Windows Informatica environments
• Experience in Informatica Administration, creating Users, Groups, Folders through Admin Console and migrating code from one environment to another
• Performed data profiling, data cleansing, data conversion, exception handling and data matching using Informatica IDQ
• Experience in developing Shell scripts on UNIX and experience with UNIX command line
• Extensive experience in Production support management involving Informatica, Oracle, UNIX
• Hands on Experience with the scheduling tools like Control-M
• Experience in working with large database systems such as Oracle, SQL Server, DB2 as well as hands-on experience in architecting and building data marts and data warehouses
• Hands on experience in Performance Tuning of sources, targets, transformations and sessions
• Good troubleshooting/debugging and technical problem-solving skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/8.x/7.x/6.x, Informatics Multi Domain Edition

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Sybase Power Designer 16/15, Erwin 3.5.2/ 3.X & Toad 8.0/9.1

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

Reporting/OLAP Tools: Business Objects XI 3.1, OBIEE 10.1.X

Applications: AWS S3, AWS EC2, AWS SCT, AWS DMS, MS office, Silectis Magpie (Data Lake), Composite Data Virtualization, MS office, Control - M, Win SCP, Autosys, Putty, JIRA, Confluence, Service Now, Share Point, Cherwell Service Management, Nagios, Splunk.

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

PROFESSIONAL EXPERIENCE:

Confidential -Nashville, TN

Senior Informatics Power Center

Responsibilities:

• Identify and recommend various ETL approaches to proactively solve large data integration patterns
• Work with Solution Architects to build and review High Level(L2) design documents and Data Intake Strategies for EDW
• Involved in Requirement gathering sessions with End Users, Mapping specification documentation, source data analysis, source-target data comparison
• Involved in End to End project delivery including Discovery, Planning, Construction and Go Live phases of Lean project Methodology
• Informatics++ Data Quality (IDQ) Best practices in the Data quality rules implementation process.
• Responsible for the data management and data cleansing activities using Informatica data quality (IDQ)
• Worked on Informatica PowerCenter tool - Source Analyzer, Data Warehousing Designer, Mapping Designer & Mapplets, and Transformations
• Install and configure the Informatica on Azure Cloud environment.
• Strong on Exception Handling Mappings for Data Quality, Data Cleansing and Data Validation
• Created complex and detailed Informatica Mappings, Mapplets, Transformations and Workflows
• Debug Job Failures, Involve in Performance Tuning of Informatica Mappings and sessions.
• Involved in code reviews, end to end user testing and sign off
• Used CA7 scheduling tool for scheduling the Informatica workflows
• ETL code was migrated to GFB servers as per the ETL standards of 9.6.1
• Participate in Business Requirements gathering, Requirements walk through sessions with Business and IT Team
• Involved in AWS Data Migration Services and Schema Conversion with ETL
• Worked with the System Analysts to do Source to Stage and Stage to Target GAP Analysis and Data Mapping.
• Ensure proper data load and balancing techniques are utilized across various layers of PDW including RV(Receiving), IC(Integration), OD, Marts etc.
• Design and review low level ETL design documents
• Used Informatica Workflow Manager for Creating, running the Batches and Sessions and scheduling them to run at specified time
• Used Cron job to schedule the UNIX script and PL/SQL programs
• Created and maintained the Shell Scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments
• Worked with Informatica Power Center Development/IDQ Output
• Development and testing of the business rules that are coded in Informatica ETL
• Integrated and sourced data from various source systems including Microsoft SQL Server, Flat Files, Oracle, DB2
• Wrote complex SQL Scripts in SQL Server for data analysis and ETL.

Environment: Informatica Power Center 9.1, Microsoft PDW 2012, SQL Server 2012, TFS, Visual Studio 2012, Sybase Power Designer 16.5 IBM DB2 3.2.0, SQL Server Management Studio, Visio, PL/SQL, UNIX Shell Scripting.

Confidential -Nashville, TN

Informatics Power Center

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.
• Worked with large scale migration from on-premise applications to cloud platforms (AWS)
• Integrate with EDC & Data Quality for business glossary, score cards discovery.
• Setup the EDC resources for Oracle, SQL servers and Azure cloud DBs for metadata lineage.
• Install and configure the Informatica on Azure Cloud environment.
• 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

Informatics Power Center

Responsibilities:

• Responsible for Internal Delivery of ETL code from Architecture /Design/ Development/ Testing and Implementation phases
• Created Several Informatics Mappings to populate the data into dimensions and fact tables
• Involved in the development of Informatica mappings and Mapplets and tuned them for optimum performance, Dependencies and Batch Design
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level
• Worked in handling both on premise and on Cloud (AWS) ETL
• Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator
• Used Debugger to test the data flow and fix the mappings
• Created and monitored workflows and task using Informatica Power Center Workflow Manager
• Partitioned Informatica mappings using Hash value partition and Round robin partition to improve target load time
• Uploaded the data in incremental fashion by using batches & sessions on Informatica Server Manager
• Used Informatica designer for designing mappings and mapplets to extract data from Mainframes, SQL Server and Oracle sources
• Developed system architecture and system design documentation Design and arrangement of scalable, highly attainable, and fault tolerant systems on AWS
• Used Various Transformations like Expression, Filter, Router, Joiner, Look Up, Update strategy, Source Qualifier in many mappings
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping
• Created different parameter files and changed Session parameters, mapping parameters, and variables at run time
• Executed Workflows and Sessions using Workflow Monitor
• Dealt with data issues in the staging flat files and after it was cleaned up it is sent to the targets.

Environment: Informatica PowerCenter 10.1, Business Objects 6.0, Oracle 10g, SQL Loader, PL/SQL, DB2, UNIX Shell Programming, Linux and Windows NT

Confidential -Raleigh, NC

Informatics Power Center

Responsibilities:

• Informatics PowerCenter, Business Glossary, Informatica Data Quality, PowerCenter, Informatica Analyst/Metadata Manager ETL, SQL, Databases, Data Management, Data Warehousing, Data Governance concepts, data software development life cycle
• ETL, SQL, Databases, Data Management, Data Warehousing, Data Governance concepts
• Performed Informatica Data Profiling with IDQ and Analyzer
• Generated Data Quality Dashboard, KPI Reports
• Experienced working with Informatica Data Quality (IDQ)
• Performed analysis to identify data anomalies, data cleansing (ETL) and resolved data quality issues
• Developed IDQ using Joiner to configure & Develop Business Rules
• Performed cross system joins for identifying duplicates and data anomalies
• Created IDQ Dashboards/KPI Metrics for reporting
• Performed ETL and resolved data quality issues with analysis
• Worked with Informatica Power Center Development/IDQ Output
• Worked on multiple projects with client/provider data, built new dimensional Data Warehouse
• BI tools Cognos, Informatica PIM, Business Objects, MicroStrategy, Netezza
• Worked with Data Modeling, Data Extraction, Data Migration, Data warehousing and report generation using Informatica, Cognos Reporting and MicroStrategy Reporting
• Worked with client and provider analytics, developed new data marts for new and existing data warehouses.
• Worked with Informatica PowerCenter, Oracle, Dimensional Data Modeling, Healthcare/Payor Data
• Worked with ETL SSIS, ERWIN, PLSQL, Informatica PowerCenter, Data Analyst, EPIC, Facets, Informatica MDM, Informatica IDD, TOAD, salesforce
• Worked as a Tableau Engineer by utilizing the BI/Reporting platform for the Data Lake environment.
• Analyzed CRM Data, customer, business, and product needs and requirements
• Analyzed product capabilities and helped in defining conceptual solutions
• Designed and documented technical specifications.

Environment: Environment: Informatica PowerCenter 9.8, Informatica Power Exchange 9.8, Informatica Data Quality 9.6.1, Cognos 9.0, Sun Solaris, SQL, PL/SQL, Oracle 11g, TOAD, SQL Server 2012, Autosys, Shell Scripting

Confidential -Chicago, IL

Informatics Power Center

Responsibilities:

• Migration of the objects using the XML export and import features.
• Prepared the migration DB scripts and ETL documents.
• Involved in Performance Tuning of Jobs.
• Assisted operation support team for transactional data loads in developing SQL & Unix scripts
• Used import/export utilities to transfer data from production instance to the development environment.
• Participated in discussions with Project Manager, Business Analysts and Team Members on any technical and/or Business Requirement issues
• Obtained detailed understanding of data sources, flat files and complex data schemas
• Prepared ETL mapping Documents for every mapping and Data Migration document for moving changed objects from development to testing environment and then to production environment.
• Involved in Unit testing, System testing to check whether the data loads into target is accurate, which was extracted from different source systems according to the user requirements.
• Migrated repository objects, services and scripts from development environment to production environment. Extensive experience in troubleshooting and solving migration issues and production issues.
• Tested the migrated objects.
• Extended support to solve issues after PROD migration

Environment: Informatica 8.1/8.6, Oracle 10g, TOAD, Windows-XP (Client), Unix, Informatica in Unix server.

Confidential -Chicago, IL

Informatics Administrator

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, Teradata, Sales force.
• 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, Teradata.