PROFESSIONAL SUMMARY:

• 9+ years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing using Informatica
• Worked with Informatica MDM (Siperian) to maintain gloden records
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation
• Expert in Design, Development and Implementation of Data warehousing projects as an ETL Developer
• Experience in extracting data from heterogeneous data sources, transforming and loading (ETL) process using Power Center
• Designed and developed Integrity, Technical and Business Data Quality rules using IDQ
• Involved in cleaning teh data using Informatica Data Quality
• Providing high quality detailed analysis, design and build processes to support specific projects with regard to Data Quality profiling and DQ rule coding
• Played a key role in creating / managing teh Data Quality Process and also in teh development of DQ Rules, Profiles, Profile Models and Scorecard for various business requirements
• Actively Involved in Design, Develop and Test teh Data Quality Rules, Profile Models, Column and Primary Key Profiling, for various data sources to determine root causes, ensure correction of data quality issues due to technical or business processes
• Worked in building teh reusable mapplets development and coordinated with teh data quality development tool
• Worked in IDQ complex transformations, used address validator, Parser, match and merge transformations to cleanse teh data
• Profile source data using IDQ tool, understand source system data representation, formats & data gaps Created Exception handling process and worked on teh best practices and standards for exception handling routines
• Worked with technical/business analysts for DQ requirements, business analysis & project coordination
• Involved in Unit Testing and supported User Acceptance Testing
• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica
• Experience in Performance Tuning of ETL to get quicker execution time
• Knowledge in Full Life Cycle development of Data Warehousing
• Experience with dimensional modeling using star schema and snowflake schema
• Ability to understand teh business rules completely based on High Level document specifications and implemented teh data transformation methodologies
• Experience in working with relational databases such as Oracle10g, SQL Server, Netezza and other non - relational data sources such as flat files

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.6, 9.6.0, Informatica Data Quality 9.6.1, Informatica MDM 9.6

Database Tools: Toad

RDBMS: SQL-Server, DB2, Netezza, Oracle 11g/10g/9i

Operating systems: Windows, UNIX

Languages: SQL, PL/SQL

Other Tools: WinSCP

PROFESSIONAL EXPERIENCE:

Confidential, Branchville, NJ

Responsibilities:

• Teamed with business analysts to deduce teh business requirements to produce effective technology solutions
• Involved in implementing teh Land Process of loading teh customer Data Set into Informatica MDM from various source systems
• Worked on data cleansing using teh cleanse functions in Informatica MDM
• Running teh Stage Jobs, Load Jobs, Match and Merge Jobs using teh Batch Viewer and Automation Processes
• Worked with Informatica MDM (Siperian) to maintain gloden records
• Configured, profiled and applied out of box data quality rules provided by teh product and helped them in understanding teh process along with data
• Identified and eliminated duplicates in datasets thorough IDQ components
• Integrated Informatica Data Quality (IDQ) with Informatica PowerCenter and Created POC data quality mappings in Informatica Data Quality tool and imported them into Informatica power center as mappings, mapplets
• Providing high quality detailed analysis, design and build processes to support specific projects with regard to Data Quality profiling and DQ rule coding
• Worked with technical/business analysts for DQ requirements, business analysis & project coordination
• Assist teh business analyst/project manager/data steward in defining or modifying teh project Data Quality Rules based on business rules/process
• Worked as a data quality architect and administrator to establish a data quality methodology, documenting a repeatable set of processes for determining, investigating, and resolving data quality issues, and established an on-going process for maintaining quality data
• Profile source data using IDQ tool, understand source system data representation, formats & data gaps Created Exception handling process and worked on teh best practices and standards for exception handling routines
• Proficiency in building scorecards and applying metrics
• Worked in building teh reusable mapplets development and coordinated with teh data quality development tool
• IDQ is used for data cleansing, Tuning and profiling and Implemented reports, dashboards to display DQ results
• Informatica data quality helps make data quality improvement and standardizing on a single platform dat provides a centralized set of reusable rules and tools for managing data quality across any project
• Performed unit, integration, regression and load testing at teh database and application level with teh tool
• Performed in creating tasks in teh workflow manager and exported IDQ mappings and executed them
• Involved in preparing required Tech Specification Documents from teh Business requirements following Organization standard
• Developed reusable objects like Mapplets and worklet transformations combined with userdefined functions to use across multiple mappings
• Worked with teh offshore team and supervised on their development activity

Environment: Informatica MDM 9.6, IDQ, Informatica Power Center 9.6.0, Informatica Data Quality 9.6.1, Oracle, SQL server, WinSCP

Confidential, Santa Ana, CA

Informatica ETL/IDQ Developer

Responsibilities:

• Worked with technical/business analysts for DQ requirements, business analysis & project coordination
• Worked with technical/business analysts for DQ requirements, business analysis & project coordination
• Involved in initial analysis of data and created reports out of it using SQL or Informatica
• Assist teh business analyst/project manager/data steward in defining or modifying teh project Data Quality Rules based on business rules/process
• Developed teh Mappings to move teh data loaded from Landing to Stage by using various cleanse and address doctor functions
• Worked in building teh reusable mapplets development and coordinated with teh data quality development tool
• Worked in IDQ complex transformations, used address validator, Parser, match and merge transformations
• IDQ is used for data cleansing, Tuning and profiling and Implemented reports, dashboards to display DQ results
• Informatica data quality helps make data quality improvement and standardizing on a single platform dat provides a centralized set of reusable rules and tools for managing data quality across any project
• Performed unit, integration, regression and load testing at teh database and application level with teh tool
• Developed mappings/transformations/Mapplet by using mapping designer, transformation developer and mapplet designer in Informatica Power Center 8.6.
• Translated teh business requirements into Informatica mappings/sessions/workflows
• Designed various mappings and Mapplets using different transformations such as key generator, match, labeler, case converter, standardize, Address Validator, parser and lookup
• Involved in Data Modeling based on teh business, technical and design Requirements
• Coordinated with Business Analysts for requirements gathering and to justify impact on other databases due to new requirements
• Involved in Unit Testing and Integration Testing of teh application. Supported Integration testing by analyzing and fixing teh issues
• Involved in fine tuning SQL overrides and Look-up SQL overrides for performance enhancements, Executed Pre and Post session commands on Source and Target database
• Scheduled and ran Extraction and Load process and monitor sessions using Informatica Workflow Monitor

Environment: Informatica Power Center 8.6, Informatica Data Quality, SQL Developer, ORACLE RDBMS 10g, WinSCP, TOAD 9, UNIX

Confidential, Santa Ana, CA

Informatica ETL/IDQ Developer

Responsibilities:

• Involved in initial analysis of data and created report out of it using SQL or Informatica
• Created mappings to format teh fields as per business unit requirement-Teh formatting involves conversion of raw format data into meaningful data through parsing
• Involved in Creating sessions and Workflows using Informatica Workflow Manager
• Worked with Informatica Data Quality (IDQ) 9.1 for data cleansing, data matching and data conversion
• Performed in creating tasks in teh workflow manager and exported IDQ mappings and executed them
• Involved in preparing required Tech Specification Documents from teh Business requirements following Organization standard
• Developed reusable objects like Mapplets and worklet transformations combined with userdefined functions to use across multiple mappings
• Designed various mappings and Mapplets using different transformations such as key generator, match, labeler, case converter, standardize, Address Validator, parser and lookup
• Involved in standardization and cleansing of Name, Phone number and Address information
• Involved in Unit Testing and Preparing test cases
• Involved in Performance tuning in mapping level and session level
• After teh initial conversion is done through ETL, teh data is loaded into test environment for teh Quality Analysis of Business Units and respective reports are generated
• After successful verification of teh reports, teh respective data is pushed to production (Go live) on county-by-county basis
• Involved in maintaining teh live data through daily update process

Environment: Informatica Power Center 8.6, IDQ 9.1 ORACLE RDBMS 10g, DB2, SQL Developer, WinSCP, TOAD 9

Confidential, Van Buren Township, MI

Informatica ETL/ IDQ Developer

Responsibilities:

• Involved in determining operational targets for data extraction and retrieval
• Extracted teh data from Mainframe and store in Target Data Store
• Developed mappings using needed Transformations in Informatica tool as per business logic
• Hands on experience with mappings from varied transformation logics like Unconnected and Connected Lookups, Router, Aggregator, Filter, Joiner, Update Strategy
• Implemented Slowly Changing Dimensions (SCD-2) for loading teh dimension tables
• Developed mappings to load teh data into Fact Tables
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping
• Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Performed data profiling and analysis making use of Informatica Data Quality (IDQ)
• Validated data extraction for completeness to ensure no data loss
• Involved in gathering requirements for identifying Business Objects and reports
• Involved in preparation of User Documentation of teh Reporting Solution
• Conducted noledge transfer to IT support team dat will support teh solution in future

Environment: Informatica IDQ 9.1, DB2, SQL Server, Oracle 11g, Toad

Confidential

ETL Developer

Responsibilities:

• Involved in Business Users Meetings to understand their Business requirements
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union
• Extensively worked with teh Debugger for handling teh data errors in teh mapping designer
• Created Pre/Post Session/SQL commands in sessions and mappings on teh target instance
• Designed technical design documents for ETL process
• Extensively used ETL Tool Informatica to load data from Flat Files to landing tables in Oracle server
• Created sessions and arranged them in various workflows in teh workflow manager
• Created Pre/Post Session/SQL commands in sessions and mappings on teh target instance
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored teh results using workflow monitor
• Generated Reports according to user Requirement

Environment: Informatica 8.6, Oracle, TOAD, Windows

Confidential

ETL Developer

Responsibilities:

• Involved in initial analysis of data and creating report out of it using SQL or Informatica
• Supported teh existing code to make sure dat weekly and monthly jobs are running properly
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Sorter and Sequence Generator transformations
• Implemented performance tuning techniques by identifying and resolving teh bottlenecks in source, target, transformations, mappings and sessions to improve performance
• Involved in fine tuning SQL overrides and Look-up SQL overrides for performance enhancements, Executed Pre and Post session commands on Source and Target database using Shell scripting and Proficiency in error handling mechanisms
• Involved in Scheduling Extraction and Load process
• Involved in monitoring sessions using Informatica Workflow Monitor

Environment: Informatica 8.1, Oracle, TOAD, Windows