SUMMARY

• 12+ years of data warehousing experience in building and managing various data warehouses/data marts using Informatica products: MDM 9.x/IDQ 10.x/Power Center 10.x, Power Exchange, Integration Hub, ILM and Informatica Cloud.
• Strong experience in overall SDLC including analysis, design, development, implementation, testing, debugging, deployment, production support and Maintenance of various applications on Data warehousing.
• Extensively worked on Informatica Data Quality (IDQ), defined rules, built scorecards, applied metrics and grouped into various dimensions in IDQ.
• Experienced in developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Informatica.
• Experienced in Performance Tuning of sources, targets, mappings, transformations and sessions.
• Strong acquaintance of Data Warehousing concepts and Dimensional modeling like Star Schema and Snowflake Schema.
• Expertise in using Informatica workflow manager, workflow monitor, server manager, PMCMD (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.
• Very Strong expertise on end to end process of Data Quality and MDM requirements and integration of the both environments.
• Expertise in several key areas of Enterprise Data Warehousing such as Change Data Capture (CDC), Slowly Changing Dimensions (SCD), Lookup Tables and ETL data movement.
• Experience in Integration of various data sources like Oracle, Teradata, SQL Server, Sybase, Flat Files, XML files, DB2 files.
• Experience in Toad (Tool for Oracle Application Developers) and VSS (for version Control).
• Experience in PL/SQL Programming (Stored Procedures, Functions and Triggers).
• Experience in UNIX shell scripting and experience in using third party scheduling tool Tivoli and Autosys for Informatica Job scheduling.
• Excellent communication skills, good organizational skills, self - motivated and extremely hardworking with ability to implement business concepts quickly and efficiently.

TECHNICAL SKILLS

Data Warehousing: Informatica Power Center 10.x/9.x/8.x/7.x, Informatica Power Exchange 9.x, Informatica Developer 10.x/9.6, Informatica Data hub, Informatica MDM, Informatica Metadata Manager, ILM

Reporting Tools: Business Objects XI R2, 6.5/5.0/5.1/4. x (Designer, Supervisor, Reporter and WEBI), Micro strategy 7.1/6.x, Cognos.

Data Modeling Tool: Designer 2000, Erwin.

Databases: Oracle 11g/10g/9i/8i, SQL Server 2012/2008/2005/2000 , Teradata 15.0, DB2/UDB, Sybase, Netezza, SAP ECC.

Languages: SQL, Shell Scripting, PL/SQL, C, C++, HTML, DHTML, XML.

Operating Systems: UNIX (Sun-Solaris, HP-UX), IBM AIX, Windows XP

Database Utilities: MLOAD, TPUMP, FAST LOAD, Toad 11.x, VSS.

Testing Tools: Mercury Test Director 8.0, Quality Center, Clear Quest

Scheduling Tools: Tivoli, AutoSys, Tidal

PROFESSIONAL EXPERIENCE

Confidential, Frisco, TX

Sr. Informatica Data Quality Consultant

Responsibilities:

• Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets.
• As a Lead Data Quality developer in this team initiated the process of DQ profiling different formats of data from different source systems and worked on analyzing its dimensions to find its actual structure and the rules which are implemented as part of Standardization for Data Quality Projects.
• Extensively used Informatica Developer tool to make data quality improvement and standardizing on a single platform that provides a centralized set of reusable rules and tools for managing data quality across any project.
• Used various transformations like Address validator, parser, joiner, filter, matching to develop the mappings in Informatica Developer tool.
• Created references tables, applications and workflows and deployed that to Data integration service for further execution of workflows.
• Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database.
• Migrated code/objects from the development environment to the QA/testing environment to facilitate the testing of all objects developed and check their consistency end to end on the new environment.
• Worked on Autosys as job scheduler and used to run the created application and respective workflow in this job scheduler in selected recursive timings.
• Worked on Informatica cloud to integrate Salesforce and load the data from Salesforce to Oracle Database using Informatica Cloud training lab.
• Involved in analyzing, defining, and documenting data requirements by interacting with the client and Salesforce team for the Salesforce objects using Informatica Cloud training lab.

Environment: Windows XP, Oracle 11g, PL/SQL, Toad 11.x, Informatica Developer 10.x/9.6, Informatica Power Center 10.x/9.6, Informatica Cloud, Teradata 14.0, SQL Server, SharePoint, UNIX and Autosys

Confidential, Irving, TX

Sr. Informatica Data Quality Consultant

Responsibilities:

• Developed appropriate ETL Data Quality routines and mappings using Informatica Data Quality based on the requirements and technical design specifications.
• Worked with Business Intelligence leadership team to develop and enhance Data Quality development process to meet the needs of the business and reduce risk factors.
• Participated in design sessions with ETL Data Quality developers, report developers, DBAs and Business Analysts.
• Handled multiple project assignments concurrently, serve in a production support rotation, and deliver on commitments.
• Created Physical data objects and did profiling on the data and provided the results.
• Worked on Mapplet rules, Mapplets as per business requirements and used in multiple mappings in Informatica Developer.
• Created and managed Reference tables which needed for the Projects.
• Created Applications, Topics, Publications and Subscriptions using Informatica Data Hub.
• Developed mappings and workflows in Power center and incorporated with Data Hub to execute the Publications and Subscriptions.
• Developed complex mappings in Informatica Developer to provide the data reports from various sources using various transformations like SAP BAPI/RFC, SAP IDOCs transformations, Source Qualifier, Look up, Expression, Aggregate, Association, Standardizer, Joiner, Filter and Router etc.
• Good Knowledge onapplying rules and policies using ILM (Information Life Cycle Management) workbench for Data Masking Transformationand loading into targets.
• Created Workflows and deployed using Application and executed from pmcmd/infacmd command line through UNIX server.
• Created Profiles using Informatica Analyst/developer tool to profiling the data and applied rules on profiles.
• Migrated all Developer objects including Application deployment into higher environments. QA, PROD etc.
• Created XML parameter files for all the mapping and Workflows objects.
• Coordinated and develops process automation/job scheduling, conduct code reviews, testing and defect analysis.
• Scheduled all the Workflows using Autosys tool.

Environment: Windows XP, Oracle 11g, PL/SQL, Toad 11.x, Informatica Developer 10.x/9.6, Informatica Power Exchange 9.6, Informatica Cloud, Informatica Data Integration Hub 9.6.0, Informatica MDM, Informatica Metadata Manager, ILM, SAP ECC, Sybase, SharePoint, UNIX and Autosys.

Confidential, Dallas, TX

Sr. Informatica Data Quality Consultant

Responsibilities:

• Strong experience in creating Technical requirement documents and Gap Analysis documents.
• Experience in Leading the projects and delivering with high efficiency.
• Prepared user requirement documentation for mapping and additional functionality.
• Extensively Used ETL to load data using Power Center / Power Exchange from source systems like Mainframes into staging tables and load the data into the target database Oracle/DB2.
• Created data maps (Records and Tables) of Mainframe data files using Power Exchange.
• Used Power Exchange to read/write from/to Tapes, db2unload and VSAM files.
• Used Informatica Designer to create mappings using different transformations to move data to the ODS.
• Developed mappings in Informatica to load the data from various sources into the Data
• Warehouse, using different transformations like Source Qualifier, Expression, Lookup,
• Aggregator, Update Strategy, Joiner, Normalizer, Router, Stored Procedure, Union.
• Worked on Error handling and Performance Tuning of the mappings.
• Optimized the performance of the mappings by various tests on sources, targets and various transformations.
• Extensive knowledge in writing Bash scripts to perform various tasks related to files.
• Provided key Information about source data to drive data cleansing with IDQ(Informatica
• Data Quality).
• Tuned performance of Informatica sessions for large data files by increasing block size, data cache size and sequence buffer length.
• Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database.
• Worked partially on finding out the Data Lineages using Metadata manager and
• Implemented changed data capture (CDC) technique to maintain the incremental loads.
• Developed PL/SQL Procedures, Functions and Packages and used EXPLAIN PLAN to tune the SQL queries.

Environment: Windows XP, Oracle 11g, PL/SQL, Toad 11.x, Informatica Power Center 9.x, Informatica Developer 9.x, Informatica Power Exchange, Teradata, SQL Server, SharePoint, UNIX and Autosys.

Confidential, Irving, TX

Sr. Informatica Consultant

Responsibilities:

• Responsible for eliciting requirements, designing dimensional data models and preparing written design documents.
• Interfaced with Business Analysts for gathering the business requirements and designed user-friendly templates to communicate any further enhancements needed.
• Responsible for creating ETL detailed design docs and also high level process overview documentation.
• Lead the team in development of design standards and codes for effective ETL procedure development and implementation.
• Developed complex mappings in Informatica to load the data from various sources using various transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Joiner, Filter and Router
• Maintaining the change management with the source code versions, scripts and documents in Confidential Shared Point.
• Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD and Informatica.
• Validated unit test results using Metadata tables like OPB tables and REP tables.
• Used Tidal to schedule the workflows using shell scripts to run automatically on daily, weekly and monthly as per business needs.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.
• Worked with ET, UV and WT Tables and did error handling and performance tuning in Teradata queries and utilities.

Environment: Windows XP, Oracle 11g, PL/SQL, Toad, Informatica Power Center 9.x,Informatica Developer9.x, Teradata, SQL Server, SharePoint, UNIX, Tidal.

Confidential, Detroit, MI

Lead/Sr. Informatica Data Quality Consultant

Responsibilities:

• Collection of data source information from all the legacy systems and existing data stores.
• Created Datamaps in Informatica Power Exchange to extract the Mainframe sources across all subject areas.
• Worked extensively on different types of transformations like Expression, Filter, Aggregator, Lookup, Joiner, Sequence generator and Router.
• Developed complex mappings using multiple sources and targets in different databases, Flat files and Mainframe files.
• Involved in creating Tivoli workflow Job streams for each subject area and scheduled as per the business requirements.
• Pushing the compressed and encrypted xml files and flat files generated to the external vendor using MFT (managed file transfer).
• Comprehensively analyzed and systematically documented the end-to-end flow of the Inbound and Outbound claims file (834 HIPAA).
• Implemented CDC process across all subject areas using MD5 function in Informatica.
• Implemented ABC (Audit, Balance, and Control) architecture for all Informatica workflows across all subject areas.
• Implemented four steps algorithm for Member matching process to load the accurate data into EDW.
• Created stored procedures to generate the sequence numbers for Master data tables in landing area.
• Worked on DB2 files to make sure that the files are connected with Informatica Power Exchange nodes properly.
• Used IDQ tool to validate SSN, Member, and Address data in the Source systems.
• Worked within a team to populate Type II slowly changing dimension customer tables from several mainframe flat files.
• Created Teradata External loader connections such as MLoad, Upsert and Update, Fastload while loading data into the target tables in Teradata Database.

Environment: Windows XP, Oracle 10g, PL/SQL, Informatica Power exchange 8.6.1, Toad, Informatica Power Center 8.6.1, Informatica Data Explorer, Informatica Data Quality, Informatica B2B Data Exchange 8.6, Informatica B2B Data Transformation Studio 8.6, PVCS, SQL Server, UNIX, DB2, Tivoli, Teradata