SUMMARY

• Around 5 years of Information Technology experience in the Analysis, design/development, Testing, Test Data Management and Data Warehouse Implementation/development.
• Experienced in overall DataWarehouse, Data - Engineering, Test Data Management, Informatica ETL/TDM, CA TDM and performance tuning.
• Expertise in Data masking, Data subsetting, Synthetic test data generation, and Data archive using Informatica TDM/ILM Suite.
• Conducted research and lead POC’s, POV’s to evaluate various TDM tools/solutions Informatica, Delphix, CA-TDM.
• Involved in Assessment, Pilot and implementations phases of Test Data Management system for various clients.
• Experience in Gold Copy Architecture and provisioning data to different DB’s and self-serve model.
• Relevant Experience on TDM solution using CA Test Data Manager.
• Created and configured different Masking rules using different masking techniques to perform Inplace, Instream masking in Informatica TDM to mask the sensitive PHI, PII data information.
• Involved in sub-setting data and data generation using CA Data Maker and GT Subset.
• Working exposure to CA TDM utilities Javelin, CA TDM Portal, Agile Requirement Designer (ARD).
• Involved in preparing ETL mapping specification documents and Transformation rules for the mapping.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Was involved in basic Informatica administration such as creating folders, connections, users, groups, change management, etc., and also involved in Informatica upgrades.
• Good Knowledge in OLTP/OLAP system study, analysis and ER modeling.
• Good Knowledge in Data Integration (DI), Informatica Data Quality (IDQ), Metadata Manager and DVO (Data Validation Option).
• Experience in working with VLDB (Very Large Databases). Established working relationship with various vendors.
• Knowledge about Software Development Lifecycle (SDLC), Agile, Application Maintenance Change Process (AMCP).
• Expertise in doing Unit Testing, system testing, UAT and Data Validation for Developed Informatica Mappings.
• Experience in basic UNIX Korn and Bash Shell scripts.
• Ability to learn new technologies and functionalities quickly and adapt to changing requirements.
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools.

TECHNICAL SKILLS

RDBMS: Oracle 12c/11g/10g/, SQL Server 2012/2008/2005 , DB2 10.1/9.7 FP1, Sybase 15.x, Netezza, Teradata

TDM Tools: ETL Tools Informatica Power Center 10.1, 9.6.1/9.1/8. x, Informatica TDM 10.1/9.6.1/9.5 , Data Analyst, Metadata Manager, ILM Workbench, CA Data Maker, GT Subset

Operating System: Unix-AIX/Linux RHEL 6.6, Windows NT/2000/8/7

Languages: SQL, PL/SQL, Shell Scripting, Python, Java

Modeling Tools: ER Studio, Erwin 4.1, MS Office Suite

Dimensional Data Modeling: Star Schema Modeling, Snow-Flake Schema Modeling, Fact and Dimension Tables, Logical and Physical Data Modeling.

Other Tools: SQLPlus, Toad, AutoSys, SQL developer, SQL Management Studio, Aginity workbench, DB visualizer

PROFESSIONAL EXPERIENCE

Confidential

Sr. Test Data Management Engineer

Responsibilities:

• Implemented different design patterns to Mask and generate test data as per functional test needs.
• Created and processed numerous masking rules to protect sensitive PHI, PII data.
• Migrated data from production systems to create Gold copies and provisioned to lower environments.
• Created different complex masking rules as per the enterprise needs to mask data across different databases.
• Extensively used In-place and In-stream masking to mask sensitive information according to the business needs.
• Created new generation rules and extensively used different advanced rules to generate realistic and valid data.
• Worked on different masking types like substitution, key, random, ssn, shuffle, credit card etc.
• Created rules, policies and used them across various projects for masking sensitive information.
• Created entities and plans to generate complex mappings using Informatica TDM.
• Generated test data using reference lookup strategy and entity strategy in various databases.
• Worked on various tasks like Session, E-Mail task and Command task.
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner etc.
• Standardized parameter files to define session parameters such as database connection for sources targets.
• Involved in test data preparation as per test data strategy and standards.
• Involved in the Upgrade of Informatica PowerCenter v9.1 to v9.6.1 and v9.6.1 to v10.1.
• Involved in the installation and upgrade of Informatica TDM.
• Functionality, Back-end and Regression testing during the various phases of the application and Data Integrity/back end testing by executing SQL statements.
• Deliver end-to-end Data Archive and Data Subset solutions using Informatica Power Center, ILM and TDM.
• Scheduled meetings with Senior Data Leads and analyzed the data.

Environment: Informatica PowerCenter 10.1/9.6.1/9.1 , Informatica TDM 10.1/9.6.1, Oracle 11gr2, SQL Server 2012/2008, Windows 7/NT, Netezza, DB2, Cassandra, Toad.

Confidential, West Chester, PA

Test Data Management Engineer

Responsibilities:

• Involved in the business requirement and provided strategies for implementing TDM solution Using different tools.
• Design documents on provisioning data to Gold copy and to Lower environments.
• Provided technical design documents for implementing Informatica TDM solution.
• Conducted research and POC to evaluate various TDM tools
• Involved in sub-setting data and data generation using CA Data Maker and GT Subset.
• Working exposure to CA TDM utilities Javelin, CA TDM Portal, Agile Requirement Designer (ARD).
• Created POC environments and run tests to evaluate Informatica TDM, Delphix and CA-TDM solutions.
• Working experience on integrating TDM solution into CI/CD environments.
• Working experience on Agile both Kanban and sprint board.

Environment: CA TDM v4.2, Informatica PowerCenter 10.1/9.6.1/9.1 , Oracle 11gr2, SQL Server 2012/2008, Windows 7/NT, UNIX/Linux, Netezza, DB2, Toad.

Confidential

Data Analyst/ Test Data Engineer

Responsibilities:

• Involved in business requirement analysis and prepared functional requirement document
• Conducted research and POC to evaluate various TDM tools
• Implemented different design patterns to Mask and generate test data as per functional test needs.
• Created different complex masking rules as per the enterprise needs to mask data across different databases.
• Created new generation rules and extensively used different advanced rules to generate realistic and valid data.
• Worked on different masking types like substitution, key, random, ssn, shuffle, credit card etc.
• Created rules, policies and used them across various projects for masking sensitive information.
• Created entities and plans to generate complex mappings using Informatica TDM.
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner etc.
• Worked on creating numerous dictionaries and added to the LKP folder in the Informatica metadata.
• Created Data Flow Mappings to extract subset of data from production and Loaded to Target.
• Involved in the analysis of source to target mapping provided by data analysts and prepared function and technical design documents.
• Utilized Informatica IDQ 8.6.1 to complete initial data profiling and matching/removing duplicate data.
• Performed tuning of Informatica Mappings for optimum performance.
• Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Extensively used Unix Scripting, Scheduled PMCMD and PMREP to interact with Informatica Server from command mode.
• Involved in the Upgrade of Informatica PowerCenter v9.1 to v9.6.1 and v9.6.1 to v10.1.
• Involved in the installation and upgrade of Informatica TDM.
• Functionality, Back-end and Regression testing during the various phases of the application and Data Integrity/back end testing by executing SQL statements.
• Deliver end-to-end Data Archive and Data Subset solutions using Informatica Power Center, ILM and TDM.
• Scheduled meetings with Senior Data Leads and analyzed the data.

Environment: Informatica PowerCenter 10.1/9.6.1/9.1 , Informatica TDM 10.1/9.6.1, Oracle 11gr2, SQL Server 2012/2008, Windows 7/NT, UNIX/Linux, Netezza, DB2, Toad.

Confidential

ETL Consultant/Informatica Developer

Responsibilities:

• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center and data subset solutions using Informatica persistent data masking.
• Involved in business requirement analysis
• Involved in the analysis of source to target mapping provided by data analysts
• Validating the Data files from source to make sure correct data has been captured to be loaded to target tables
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Worked closely with the admin and helped in masking of sensitive information using Informatica TDM.
• Created mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Joiner etc.
• Extracted the data from Oracle, DB2, CSV and Flat files
• Developed the strategy for the incremental loads.
• Converted the regular mappings to handle the Slowly Changing Dimension.
• Install and configure Informatica TDM and worked with ILM workbench for creating jobs, rules and policies.
• Involved in test data preparation as per test data strategy and standards.
• Performed tuning of Informatica Mappings for optimum performance.
• Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Extensively used Unix Scripting, Scheduled PMCMD and PMREP to interact with Informatica Server from command mode.
• Involved in the Upgrade of Informatica PowerCenter v9.5.1 to v9.6.1.
• Functionality, Back-end and Regression testing during the various phases of the application and Data Integrity/back end testing by executing SQL statements.

Environment: Informatica Power Center 9.5.1, Informatica IDQ 8.6.1, Oracle 11g, SQL Server 2008, Informatica TDM 9.5.0, AIX 6.1/ Linux RHEL 6.x/5.x, Toad, IBM DB2, PL/SQL, SQL Developer.