We provide IT Staff Augmentation Services!

Sr. Test Data Management Engineer Resume

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.

Hire Now