Informatica Consultant Resume

SUMMARY:

Member of informatica ILM R&D Engineering Team.
Extensive experience in Solution Engineering, Testing and Implementing Informatica Power center, Informatica Test Data Management (TDM) Product
Implemented ILM TDM at Verizon, Meijer and Time Warner including Data Masking, Subsetting and Test Data Generation
Hands - on experience in installing, configuring and delpoying informatica Powercenter and TDM product
Extensively worked on ILM TDM (Test Data Management)- Data Masking, Data Subset and Data Profiling, Test Data Generation, Test Data Warehouse, Masking on Hadoop.
Extensive experience on ETL tool informatica Power Center 9.5.0, 9.6.0, 9.6.1.
Worked on Creating Mappings,Workflows,Sessions,Mapplets in Powercenter.
Expertise in Informatica’s DMO Transfomation
Experience on Data Profiling using Informatica Developer Tool, Analyst Tool and ILM TDM
E xperience on Multiple Databases like Oracle, SQL Server, DB2, Sybase, Teradata .
Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.
Performed Test Automation working in all stages of SDLC; automating Smoke/Sanity, Regression, and Functional Testing
Diverse work experience in GUI Testing, Functional Testing, Regression Testing, Ad-hoc Testing Exploratory Testing, ETL Testing and Database Testing
Well acquainted with SDLC, STLC, Testing Methodologies and Processes
Well acquainted with writing T-SQL queries.
Well used to Work in Agile Environment .

TECHNICAL SKILLS:

Operating Systems: LINUX, UNIX, Windows

Programming Languages: Core JAVA.

Databases: Oracle, SQL Server 2008, DB2, Sybase.

ETL Tool: Power Center 8.6.1, Informatica 9.1.0, 9.5.0 and 9.6.0

Data Profiling Tool: Informatica Developer Tool, Analyst Tool

Configuration Management Tool: Perforce 10.0

PROFESSIONAL EXPERIENCE:

Informatica Consultant

Confidential

Responsibilities:

Installation of Informatica Software 9.6.1 HF3
Installation of Test Data Management 9.7.0
Creating all the masking Rules to mask the sensitive data
Assigning the masking rules within informatica
Masking all the sensitive columns.
Masking close to 7 applications within Verizon.

Lead Software Engineer

Confidential

Environment: ILM, TDM, Java SDK, Power Center, Informatica Data Explorer (IDE), Informatica Developer Tool, Informatica Analyst Tool, Perforce, Linux, Solaris, HP UX, Windows, Oracle, SQL Server, DB2, Sybase, TeraData, Flat files (.dic,.txt,.dat)

Responsibilities:

Advanced Customer Engineering for TDM 9.5.0, 9.5.1, 9.6.0, 9.6.1, 9.7.0 releases
Installation and Administration of PowerCenter and TDM in different Platforms/Environments
Installation and upgradation of TDM on different platforms in sync with Power Center
Preparation of Test Scenarios and Test Cases as per the business needs
Creation of data sources and developing Extraction Logic and ETL Maps
D ata Profiling and Relationship Discovery for Sensitive Data utilizing Informatica’ s Developer Tool, Informatica Analyst Tool( IDQ ) and export the results in to TDM
Modelling Test Objects by creating Metadata
Implementing and Validating Masking Techniques like Substitution, Key, Random, Expression, SSN, Credit Card, Email, IP Address, URL, Nullification, Shuffling, Encryption and Complex
Validation of Mappings that are generated in Power Center through TDM with Source Qualifier, DMO, Expression, Router, Joiner, Lookup Transformations
Validation of Data Subset by creating Entities, Groups and Templates
Validation of data movement across different target systems for both data masking as well as data subset
Data Validation using DVO and File comparision Tool WinMerge
Worked on the Test Data Warehouse Soulution TDW available in the TDM Product in 970 release.
Creating Mappings,Sessions, Workflows,Mapplets in Powercenter.
Debugging the Mappings and Sessions in Powercenter.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship