Sign in

IDQ/Informatica Powercenter

Denver, Colorado, United States
February 20, 2018

Contact this candidate

Professional Summary:

Over * years of IT experience in system analysis, design, development of software applications and experience in the field of ETL methodologies, business intelligence and data Warehousing principles and architectures including concepts, designs and usage of data warehouses and data mart.

Directly responsible for the Extraction, Transformation & Loading of data from multiple sources into Data Warehouse

Experienced in using Informatica Data Quality (IDQ) tools for Data Analysis / Data Profiling / IDQ Developer client, applying rules and develop mappings to move data from source to target systems

Experience on creating Column Profiling, Rule Profiling, Mid-stream Profiling, Score Cards, Decision Task, Reference Tables, DQ Tables, Notification task as a part of workflow and deploying them.

Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets and vice versa

Extensively worked on Labeler, Parser, Key Generator, Match, Merge, Consolidation transformations to identify the duplicate records.

Experience in using Standardizer transformation, Case Converter to standardize the data.

In-depth knowledge on Informatica Address Validator/Address Doctor to discover the Mailability score and Status codes for personal and business addresses using various input and output ports

Strong understanding of Dimensional Modeling, OLAP, Star, Snowflake Schema, Fact and Dimensional tables and DW concepts.

Experienced in working with normalized and de-normalized databases of Oracle 11g/10g

Strong Data analysis to ensure accuracy and integrity of data in the context of Business functionality

Strong knowledge and Experience in using Informatica Power Center ETL tool

Experience in using update strategies, incremental loads, and implementing Slowly Changing Dimensions of Type I and Type II.

Experience in developing Transformations, Mapplet’s and Mappings using Informatica Designer to implement business logic

Created test plans, test data for extraction and transformation processes and resolved data issues following the data standards.

Extensive database experience and highly skilled in SQL, Oracle, MS SQL Server, DB2, Sybase, Mainframe Files, Flat Files, MS Access.

Skilled in SQL, PL/SQL, SQL*Plus, TOAD, SQL Assistant

Expert level skills in testing Enterprise Data Warehouses using Informatica PowerCenter DVO

Proven ability to work efficiently in both independent & collaborative environments with Excellent interpersonal and communication skills.

Have Knowledge on Informatica MDM concepts and implementation of De-duplication process.

Good Knowledge on De-duplication process in order to remove all the possible duplicates from the existing multiple sources which matches with Master Records in MDM hub.

Extensive experience with Sales, Healthcare and Financial domains.

Innovative thinking and strong problem solving and analytical capabilities

Experience in moving the developed projects from one environment to another environment.

Experience in Unit Testing of all ETL Components and submitting the results.

Good knowledge on Informatica MDM and Big data.

Technical Expertise:

ETL Tools: Informatica PowerCenter 10.x/9.x/8.x/7.x, SQL Developer, Informatica Data Quality (IDQ) 10.1.0, Metadata Manager,Business Glossary,MDM(Master Data Management)

Databases: Oracle, SQL Server, MySQL, MS Access, DB2, TOAD

Languages: SQL, PL/SQL, UNIX

Operating Systems: Windows XP, UNIX, Win NT

Scheduling Tools : Autosys

Data Modelling Tool: Erwin

SDLC: Waterfall, Agile, IBM Rational Team Concert

Professional Experience:

Kaiser Permanente/TCS, Aurora, CO April 17 – Till Date

Role: ETL Informatica/IDQ Developer


As a lead Data Quality developer in this team initiated the process of Data profiling by profiling different formats of data from different sources and started analyzing its dimensions to find its actual structure and the rules which are implemented as part of Standardization.

IBM Rational Team Concert - Using agile SDLC methodology, assigned points to user stories, tracked progress in tasks for Sprint planning and kept current sprint progress up-to-date in this tool

Create Estimation Plan and provide LOE for the IDQ Development for the projects.

Design End2End Solution including Database Model, Workflows and Job Schedule for the IDQ Cleansing/Matching and IDQ Data Mart

Designed Workflow’s using different Tasks available in Developer tool like Human Task, Inclusive Gateway, Exclusive Gateway, Notification Task, Mapping task for running tasks in Parallel/Sequence

Scheduled Jobs using the IDQ Scheduler by Deploying the Workflow’s as an Application to the Data Integration Service for running the workflows.

Expertise in creating the Conditional Sequence Flows by creating the User defined Workflow variables and assigning them to the Mapping Task output.

Expertise in understanding the Data Quality Rules defined by the business/functional teams and propose the optimization of these rules if applicable, then design and develop these rules with IDQ, including thorough unit test planning and performing.

Performed the Extract Transform and Load ETL : source to target, utilizing Informatica Power center and Data Validation Option DVO

Most of data which belongs to various Medical Claims, Pharmacy Claims Members and Service Providers will be carried out throughout the development.

Implemented Kimball’s White paper in the process of implementing the DQ Mart.

Implemented Data Validation Option DVO for understanding on how to run tests, and evaluated the test results.

Designed DVO Informatica test cases for source and target Database validation.

Expertise in configuring the IDQ’s Address Validator / Match (Field/Identity) Transformations by assigning weightages for fields involved in matching for standardizing/De-duplication of the Vendor Data.

Expertise in Creating the Profiles (Column Profiling/Rule Profiling/Join Profiling/Mid-Stream Profiling), Score cards, Reference Tables, Data Quality Tables in the Analyst tool of IDQ and configuring the Data Dictionaries in the Standardizer and Labeler Transformation.

Tools and Application Used: Informatica Developer (IDQ) 10.1.0, Informatica PowerCenter10.1.0, DVO,Oracle 11g, SQL Developer, Windows 2012, Unix, TOAD, IBM Rational Team Concert

ThermoFisher Scientific/Deloitte, Carlsbad, CA Sep 15 – Feb 17

Role: ETL Informatica/IDQ Developer


Integration of the DQ Mapplet’s into PC Mappings.

Involved in complete Life Cycle of developing Enterprise Data Warehouse Application and, developing ETL Architecture using Informatica.

Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional data modelling (Star Schema, Snow Flake Schema, FACT & Dimension Tables), OLTP and OLAP.

Developed IDQ Plans for Standardizing the RSD, LSG and GWI Data Using Labeller, Standardizer and Parser Transformations.

Used Compare and Weighted average transformations in order to implement the Match Process and to assign various weights to Different fields.

Importing the IDQ Mapplet’s to Informatica and using them in the Informatica mappings.

Implementing the SCD Type 1 and SCD Type 2 for Customers, Organizational Unit, Company, Product, Product Sales and Product Cost.

Interacted with various Business users in gathering requirements to build the data models and schemas

Developed numerous mappings using the various transformations including Address Validator, Association, Case Converter, Classifier, Comparison, Consolidation, Match, Merge, Parser etc.

Developed reusable transformations called mapplets and used them in mappings in case of reuse of the transformations in different mappings.

Developed complex mappings which involved Slowly Changing Dimensions, Change Data Capture and data quality rules.

Involved in preparing the High level Specs according to the Data Model specified by the Database Architect.

Extensively used transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create Mapping’s/ Mapplet’s, workflows/ worklet’s and worked on Performance Tuning of Large text fields, SQL Overrides, Data filters and Custom Joins

Responsible for migration of the work from Dev Repo to Test and Stage Repo’s.

Modified existing mappings for enhancements of new business requirements possible for solving the testing issues.

Assist in code testing, migration, deployment, enhancement and bug fixes.

Used Autosys to Schedule and Monitor ETL jobs.

Involved in unit testing and system testing while the code is moved to production

Tools and Application Used: Informatica Developer (IDQ) 9.1.0, Informatica PowerCenter 9.1.0, Oracle Exadata, SQL Developer, Windows 2012, UNIX, TOAD, Autosys.

First American, Santa Ana, CA May 14 - Aug 15

Role: IDQ Developer


Worked with Informatica Data Quality 9.1.0 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, reporting and monitoring capabilities of IDQ 9.1.0.

Extracted data from various data sources such as Oracle, SQL server, SAP, SFDC, SIEBEL, Flat file, DB2 and transformed and loaded into targets using Informatica.

Created various complex mappings using different transformations such as Source Qualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator etc.

Designed and developed initial and incremental data loads using Informatica.

Designed and developed several Mapplet’s and Worklet’s for reusability.

Working experience using Push down Optimization.

Implemented audit process to ensure Data warehouse is matching with the source systems in all reporting perspectives.

Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.

Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.

Involved in Unit testing, User Acceptance testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.

Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed and Debugged mappings for failed sessions to find root cause

Implemented Slowly Changing Dimensions (SCD, Both Type 1 & 2).

Tools and Application Used: Informatica Developer (IDQ 9.1.0), Analyst, Informatica PowerCenter 9.1.0, Oracle 11g, UNIX, Windows 2007

Barclays, Wilmington, DE Dec 12 – Apr 14

Sr.Informatica ETL Developer


Interacted actively with Business Analysts and Data Modelers on Mapping documents and Design process for various Sources and Targets

Developed Rules and Mapplet’s that are commonly used in different mappings

Used various transformations like Address validator, parser, joiner, filter, matching to develop the maps

Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, and Stored procedure transformations.

Worked on Power Center Tools like designer, workflow manager, workflow monitor and repository manager.

Worked on multiple projects using Informatica developer tool (IDQ) of latest versions 9.1.0 and 9.5.1.

Involved in migration of the Mapplet’s from IDQ to power center

Applied the rules and profiled the source and target table's data using IDQ.

Developed the mappings, applied rules and transformation logics as per the source and target system requirements

Created and Scheduled Job Streams and Jobs in Tidal.

Involved in database, ETL and Tidal Jobs migration to QA and Production environments.

Worked on different environments with different source and target databases like Teradata, DB2, and SQL server.

Developed the mapping to process multiple flat file as source and staged the data into Teradata and DB2 databases.

Environment: Informatica Power center 9.1/9.5-HotFix 4, Oracle, Teradata 13.1, DB2, IBM Mainframe’s, UNIX, Windows NT, and SQL Assistant 6.2.1.

Fine Stationery - Wilmington, DE Sep 10 – Oct 12

Role: ETL Developer


Collaborated with Business analysts and the DBA for requirements gathering, business analysis and designing of the data marts.

Worked on dimensional modeling to Design and develop Star Schemas, identifying Fact and Dimension Tables for providing a unified view to ensure consistent decision making.

Design ETL processes using Informatica tool to load data from Oracle source systems and Flat files into Oracle Target database

Extensively used ETL to load data from Flat files which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle 9i/10g.

Extensively used Transformations like Aggregator, Router, Joiner, Expression, Lookup, Update Strategy, and Sequence Generator.

Extensively worked in the performance tuning of ETL mappings and sessions.

Wrote Shell Scripts for Informatica Pre-session, Post session Scripts.

Written PL/SQL stored Procedures and Functions for Stored Procedure Transformation.

Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.

Performed Unit testing and verified the data.

Involved Conducted and participated in process improvement discussions and recommending possible outcomes and focused on production application stability and enhancements.

Worked with Functional team to make sure required data has been extracted and loaded and performed the Unit Testing and fixed the errors to meet the requirements.

Copied/Exported/Imported the mappings/sessions/ worklet’s /workflows from development to Test Repository and promoted to Production.

Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.

Worked with Static, Dynamic and Persistent Cache in lookup transformation for better throughput of Sessions.

Modified existing Mappings for enhancements of new business logic/requirements.

Used Debugger to test the Mappings and fixed the Bugs.

Prepared migration document to move the Mappings from development to testing and then to production repositories.

Developed & reviewed test cases. Developed & executed SQL queries to validate actual test results, and match with expected results.

Tools and Application Used: Informatica PowerCenter 8.6, Oracle 10g, Windows 2005/08, UNIX

ILabs - India Dec09 – Aug 10

Role: ETL Developer


Performed extensive data analysis to identify data gaps, redundancies and issues to help Data Warehousing efforts.

Gathered requirements and business specifications through extensive interactions with functional teams and users to design the user reports and backend data models.

Prepared detailed design documentation for the ETL process using standard templates.

Extensively used Informatica PowerCenter for extracting, transforming and loading databases from Oracle databases.

Wrote PL/SQL stored procedures, functions and triggers for implementing business rules and transformations.

Developed materialized views and summary tables necessary for structured and ad-hoc reporting.

Extensively worked on Informatica Designer tools Mapping Designer, Mapplet designer, Informatica Repository Manager and Informatica Workflow Manager.

Used Workflow Manager to create Sessions and Tasks and used them to build Workflows and Worklet’s using various Tasks and scheduled the workflows to run at predetermined times.

Performed performance tuning using partitioning and optimization of transformations.

Designed and implemented complex SQL queries for QA testing and report/ data validation.

Developed complex queries using oracle data bases for reporting purpose.

Responsible for maintaining the integrity of the SQL database and reporting any issues to the database architect.

Assisted in mining data from the SQL database that was used in several significant presentations.

Assisted in offering support to other personnel who were required to access and analyze the SQL database.

Participated in regular project status meetings related to testing.

Tools and Application Used: Informatica PowerCenter 7.1/8.6, Oracle 9i/10g, UNIX, SQL, TOAD


On request.

Contact this candidate