SUMMARY:

• About 5+ years of experience in IT industry working with tools Informatica Data Quality, Informatica Data Analyst and Informatica Power Center.
• Expertise in agile methodologies of Software Development Life Cycle (SDLC).
• Experienced in Installation, Configuration, and Administration of Informatica Data Quality and Informatica Data Analyst.
• Expertise in address data cleansing using Informatica Address Doctor to find deliverable personal and business addresses.
• Analyzed Data Profiling Results and Performed Various Transformations.
• Hands on Creating Reference Table using Informatica Analyst tool as well as Informatica Developer tool.
• Experienced in Data Cleansing, Validation and Audit
• Expertise using Address Validator, Parser, Key Generator, Match Standardizer, Expression transformation.
• Experience in creating PDO, CDO and LDO to import data (flat file, relational database file etc.)
• Experience in using Standardizer transformation to standardize the data.
• Expertise in using varied Transformation logic like Filter, Expression, Unconnected and Connected lookups, Aggregator, Joiner, Update Strategy, Data Transformation Services, Sorter etc. for designing and developing complex mappings.
• Experienced in using various log files for troubleshooting techniques and error handling.
• Excellent Knowledge on developing and debugging Mapplets, Workflow and Mappings.
• Expertise in SQL scripts and stored procedure to perform various business transformations as well as validations on data.
• Expository mastermind that reliably settle progressing issues or deserts and a speedy learner on new advances.
• Included in documentation for offshore development and coordination with Clients Project Manager and Team Members.
• Experience in Dimensional data modeling, Star schema modeling, Snow - Flake modeling, identification of fact and dimension tables, Normalization, Physical and Logical Data Modeling.
• Well versed with Installation, Configuration and Administration of Informatica Power Center on Client/Server environment.
• Excellent Communication, Organizational & Analytical Skills.
• A Good Team Player, Fast Learner and Highly Motivated.

TECHNICAL SKILLS:

ETL Tools: Informatica Data Quality 10.x/9.x

EIM Tools: Informatica Power Center 10.0/9.x/8.x

Databases: Oracle 11g/10g/9i, SQL Server 2012, DB2

Database Tools: TOAD, SQL*PLUS, SQL Developer

Programming Tools: C, C++, SQL, PL/SQL

Operating Systems: Windows Server 2012//2008/2003/2000/ NT/98/95

PROFESSIONAL EXPERIENCE:

Confidential, MA

Informatica Data Quality Consultant

Environment: IDQ Informatica Developer Tool 10.0, IDQ Informatica Developer Tool 9.6.1 HF3, IDQ Informatica Analyst Tool 9.6.1 HF3, Informatica Power Center 9.6, Oracle 11g, Windows Server 2012/2008

Responsibilities:

• Involved in analyzing legacy sources to figure out data quality issues.
• Worked with DQ Country Accelerators and extensively used them for Profiling and Standardization.
• Build different validation criteria for Investigator (Person) data, Center (Organization) data and Study (Trials) data.
• Using Informatica Developer Tool, created Sources to Targets mappings for Data cleansing, validating, integrating and matching.
• Developed various rules in Developer tool to utilize while Profiling.
• Developed workflows in DQ for validation and cleansing. Automated the workflows developed using UC4 Jobs.
• Responsible for developing Mappings, Mapplets and Rules using different types of transformations like Parser, Address Validator, Key Gen, Match etc. transformations, created PDOs and CDOs.
• Provide high-level design walkthrough on how the solution will be built for each requirement.
• Involved in Daily Scrum team meeting.
• Implemented DQ mappings to test the standardized and cleansed new data.
• Assist in code testing, migration, deployment, enhancement and bug fixes.
• Performed Data Quality Checks, Cleansed the incoming data feeds and profiled the source systems data as per business rules using IDQ.
• Reviewed and demonstrated the abnormalities back to the business and made proper adjustments.
• Documented the functionalities built as part of the development.

Confidential, MA

Informatica Data Quality Consultant

Environment: IDQ Informatica Developer Tool 9.6.1, IDQ Informatica Analyst Tool 9.6.1, Informatica Power Center 9.6, Oracle 11g, Windows Server 2008

Responsibilities:

• Involved in analyzing Oracle based databases sources to figure out data quality issues.
• Responsible for working with ETL Lead, MDM lead, Data Modeler and other stack holders to understand business requirements.
• Using Informatica Developer Tool, created source PDOs from the Oracle tables, created Sources to Targets mappings for Data cleansing, validating, integrating and matching.
• Responsible for developing Mappings, Mapplets and Rules using different types of transformations like Parser, Address Validator, Key Gen, Match etc. transformations, created PDOs and LDOs.
• For cleansing legacy addresses, created Address Validation rules for RMV’s various Mail, Residence and organization addresses, created match rules.
• Parsed the RMV’s Person data and Organization data.
• Migrated various rules as well as Mapplets developed at IDQ Developer tool to the Power Center.
• Moreover, using Informatica Power Center, designed and developed two workflow variable driven solutions to process Flat file sources.
• Provide high-level design walkthrough on how the solution will be built for each requirement.
• Involved in Daily Scrum team meeting.
• Implemented PC DQ mappings to test the standardized and cleansed new data.
• Assist in code testing, migration, deployment, enhancement and bug fixes.
• Performed Data Quality Checks, Cleansed the incoming data feeds as and profiled the source systems data as per business rules using IDQ.
• Reviewed and demonstrated the abnormalities back to the business and made proper adjustments.

Confidential

ETL Consultant

Environment: Informatica Power Center 9.5, Oracle 11g, UNIX, Siebel 8.1.1 SIA (Public Sector), SQL Developer

Responsibilities:

• Understanding the legacy system based on requirements and structuring the Siebel Data model.
• Extensively used all the features of Informatica including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Involved in analyzing the legacy system and mapping the entities between legacy system and Siebel system.
• Designing the staging area structure for capturing the extracted business data from the legacy system.
• Created Complex mappings using transformation like Filter, Expression, Joiner, Aggregator, Router and Stored Procedure transformations for populating target table in efficient manner.
• Loading the data from legacy system to staging table using the extraction logic and transfer of data to Siebel interface table through SQL.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes for Staging and EIM table population using Informatica power center.
• Involved in performance tuning of mappings, transformations and sessions to optimize performance.
• Involved in loading different entities into Siebel base tables. (Case, Incident, Interrogation, Order, Contact, Address, Hearing Session, Account, Employee etc.)
• Worked on improving the performance of Complex SQL's and PL/SQL scripts by applying various performance techniques using hints, indexes and also looking queries explain plan.
• Involved in shell script creation for automating the Bulk data import process.
• Worked with trouble shooting the defects as well as performance issues.

Confidential

ETL Developer

Environment: Informatica Power Center 9.1, Oracle 11G, SQL, PL/SQL, TOAD 9.0, Windows Server 2008

Responsibilities:

• Interacted with Business users to understand the Business requirements and prepared technical documents for implementing the solutions as per business needs.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes.
• Involved in logical and physical data modeling, analyzed and designed the ETL processes.
• Involved in migration of Informatica 7.1.3 to Informatica 8.1.1
• Identified all the conformed dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Created and developed various transformations, several complex Mappings, Mapplets and Reusable Transformations and also Extracted the data from relational Database source (Oracle), flat files to facilitate one time, Daily, Monthly and Yearly Loading of Data based on company requirements and load into Oracle tables.
• Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
• Experienced in implementing and maintaining SCD Type 2 Dimension Tables
• Used Informatica Workflow Manager for Creating, running the Batches and Sessions and scheduling them to run at specified time.
• Involved in Debugging, Troubleshooting, Testing, and Documentation of Data Warehouse.
• Created new Tables, Indexes, and Sequences where needed.
• Documenting the ETL mapping strategies and transformations involved in the extraction, transformation and loading process

Confidential

Business Analyst

Environment: Oracle 11g, PL/SQL, Informatica Power Center 8.1, Windows, SQL plus, SQL Developer

Responsibilities:

• Defines and documents customer business functions and processes.
• Consults with functional unit management and personnel to identify, define and document business needs and objectives, current operational procedures, problems, input and output requirements, and levels of systems access.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Performed analysis, design, development and maintenance activities associated with the database and data in support of multiple applications (including following standards/procedures to achieve integration of systems through database design).
• Performed requirements elicitation through Interviews, Group Meetings and Workshops
• As a Technical Team Member, involved in identifying the business user requirements and development of different modules and PL/SQL procedures.
• Performing data pulls from the server, used for various report generations on a daily basis.
• Responsible for improving query and session performance.