SUMMARY

• 8+ years of extensive experience wif Informatica Power Center in all phases of Analysis, Design, Development, Implementation and support of Data Warehousing applications using Informatica Power Center Informatica 10.x/ 9.x IDQ, Informatica Developer, MDM, IDE, SSIS, IDS.
• Experience in analysis, design and development of enterprise level data warehouses using Informatica. Experience in complete Software Development Life Cycle (SDLC) (Requirement Analysis, Design, Development & Testing)
• Experience in Data Modeling & Data Analysis experience using Dimensional Data Modeling and Relational Data Modeling, Star Schema, Snowflake Modeling, Fact & Dimensions tables, Physical & Logical Data Modeling.
• Expertise in developing standard and re - usable mappings using various transformations like expression aggregator, joiner, source qualifier, lookup and router.
• Experienced in integration of various data sources like Oracle 11g,10g/9i/8i, MS SQL Server 2008/2005, XML files, Teradata, Netezza, Sybase, DB2, Flat files, XML, Salesforce sources into staging area and different target databases.
• Designed complex Mappings and have expertise in performance tuning and slowly-changing Dimension Tables and Fact tables.
• Excellent working experience wif Insurance Industry wif strong Business Knowledge in Auto, Life and Health Care - Lines of Business
• Worked on scheduling tools Informatica Scheduler, Autosys, Tivoli/Maestro & CONTROL-M.
• Experience in PL/SQL Programming and in writing Stored Procedures, Functions etc.
• Experience in creating complex mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism by using Informatica 10.x/9.x
• Experience in source systems analysis and data extraction from various sources like Flat files, Oracle 11g/10g/9i, IBMDB2 UDB, XML files.
• Extensively worked on Informatica Data Quality and Informatica Power center throughout complete IDQ and MDM projects.
• Designed and Developed IDQ mappings for address validation / cleansing, doctor master data matching, data conversion, exception handling, and report exception data.
• Documented teh number of source / target rows and analyzed teh rejected rows and worked on re-loading teh rejected rows.
• MDM Developer wif experience in implementing, development, maintenance and troubleshooting on Informatica MDM solutions, Metadata Management, data quality, data integration.
• Performed teh data profiling and analysis making use of Informatica Data Quality (IDQ).
• Worked Master Data Management concepts, Methodologies and ability to apply dis knowledge in building MDM solutions
• Experience in UNIX shell scripting, Perl scripting and automation of ETL Processes.
• Designed, Installed, Configured core Informatica/Siperian MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, IDD & Data Modeling.
• Experience in support and knowledge transfer to teh production team.
• Prepared user requirement documentation for mapping and additional functionality.
• Extensively used ETL to load data using Power Center / Power Exchange from source systems like Flat Files and Excel Files into staging tables and load teh data into teh target database Oracle. Analyzed teh existing systems and made a Feasibility Study.
• Thorough knowledge inDataModeling Concepts (Kimball), Star and Snowflake Schema addressing Slowly Changing Dimensions (SCDs)and OLAP/OLTP systems.
• Hands on experience in PL/SQL (Stored Procedures, Functions, Packages, Triggers, Cursors, Indexes) and UNIX Shell scripting.
• Expertise in doing Unit Testing, Integration Testing, System Testing, Data Validation and Performance tuning for Developed Informatica Mappings.
• Extensive experience in Production support management during go-live and post-production support activities.
• Expertise in scheduling workflows using scheduling tools like Autosys, Tidal, Control-M and Informatica Scheduler.
• Hands on experience working in LINUX, UNIX and Windows environments.
• Expertise in Off-shore/On-site work culture, leading and mentoring Data Warehouse teams.
• Comprehensive analytical, interpersonal and communicational skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.2/9.5/9.1/8.6.1, IDQ, Ab Initio, SSIS, Clover

Reporting Tools: SSRS, Tableau, Power BI

MDM Packages: Informatica MDM MultiDomain Edition 10.0, 9.7.1, 9.5, 9.1

Data Modeling: Dimensional Data Modeling, using Star Join Schema Modeling, Snowflake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling

Databases: Oracle 11g/10g, MySQL, SQL Server

Scripting: UNIX Shell scripting, PowerShell, SQL stored procedures

Application tools: Service now

Scheduler Tools: TIDAL, Control - M, Autosys

DB tools: SQL / PL SQL, Db2, TOAD, Oracle Developer, Teradata

Operating System: UNIX (AIX, Sun), Windows

Agile Tools: JIRA

PROFESSIONAL EXPERIENCE:

Sr. Informatica/MDM Developer

Confidential, Plano - TX

Responsibilities:

• Analyze teh business requirements and framing teh Business Logic for teh ETL Process and maintained teh ETL process using Informatica Power Center.
• Experienced in Parsing high-level design specs to simple ETL coding and mapping standards.
• Worked on Agile Methodology, participated in daily/weekly team meetings, guided two groups of seven developers in Informatica PowerCenter/Data Quality (IDQ), peer reviewed their development works and provided teh technical solutions. Proposed ETL strategies based on requirements.
• Coded Teradata BTEQ sql scripts to load, transform data, fix defects like SCD 2 date chaining, cleaning up duplicates.
• Worked on Agile Environment and used Version-One as a bug /defects tracking tool.
• Worked wif team to convert Trillium process into Informatica IDQ objects.
• Extensively used teh DQ transformations like Address validator, Exception, Parser, Standardizer, Solid experience in debugging and troubleshooting Sessions using teh Debugger and Workflow Monitor
• Extensively worked on UNIX shell scripts for server Health Check monitoring such as Repository Backup, CPU/Disk space utilization, Informatica Server monitoring, UNIX file system maintenance/cleanup and scripts using Informatica Command line utilities.
• Extensively worked on CDC to capture teh data changes into sources and for delta load. Used Debugger to validate teh Mappings and gained troubleshooting information about teh data and error conditions.
• Developing workflows wif Worklets, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Proficient in System Study, Data Migration, Data integration, Data profiling, Data Cleansing / Data Scrubbing and Data quality
• Worked onInformaticaData Quality (IDQ) toolkit, analysis, data cleansing, data matching, data conversion, address standardization, exception handling, reporting and monitoring capabilities of IDQ.
• Coded Teradata BTEQ sql scripts to load, transform data, fix defects like SCD 2 date chaining, cleaning up duplicates.
• Experience in creation of ETL Mappings and Transformations using Informatica Power Center to move data from multiple sources into target area using complex transformations like Expressions, Routers, Lookups, Source Qualifiers, XML generator, XML Parser, Aggregators, Filters, Joiners
• Performed match/merge and ran match rules to check teh effectiveness of MDM process on data
• Responsible in preparing Logical as well as Physical data models and document teh same
• Performed ETL code reviews and Migration of ETL Objects across repositories.
• Developed ETL's for masking teh data when made available for teh Offshore Dev. team
• Developed UNIX scripts for dynamic generation of Parameter Files& for FTP/SFTP transmission
• Monitored day to day Loads, Addressed & resolved Production issues in an abrupt & timely manner and provided support for teh ETL jobs running in Production in order to meet teh SLA's
• Integrated IDQ mappings through IDQ web service applications as cleanse functions in Informatica MDM using IDQ cleanse Adapters.
• Migrated codes from Dev to Test to Pre-Prod. Created effective Unit, Integration test of data on different layers to capture teh data discrepancies/inaccuracies to ensure successful execution of accurate data loading.
• Scheduled Informatica workflows using OBIEE.
• Designed and tested packages to extract, transform and load data (ETL) using SSIS, Designed packages which are utilized for tasks and transformations such as Execute SQL Task, Mapping teh right and required data from source to destination, Data Flow Task, Data Conversion, For each Loop Container.
• Involved in implementing change data capture (CDC) and Type me, II, III slowly changing Dimensions
• Developed functions and stored procedures to aid complex mappings

Environment: Informatica Power Center 10.5/9.6, Informatica MDM 9.5, Informatica Data Quality (IDQ) 9.6, Oracle 11g, Teradata, PL SQL, SQL developer, TOAD, Putty, Unix

Confidential

IT App Developer/MDM Developer

Responsibilities:

• Develop complex mappings by efficiently using various transformations, Mapplets, Mapping Parameters/Variables, Mapplet Parameters in Designer. Teh mappings involved extensive use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer, Sequence generator, SQL and Web Service transformations.
• Developed UNIX shell scripts to trigger Teradata SP/BTEQ and worked wif Teradata Utilities such as Multi
• Load, Ruby, Agile, Fast Load, Fast Export, BTEQ.
• Demonstrated teh ETL process Design wif Business Analyst and Data Warehousing Architect.
• Assisted in building teh ETL source to Target specification documents
• Built teh Physical Data Objects and developed various mapping, mapplets/rules using teh Informatica Data Quality (IDQ) based on requirements to profile, validate and cleanse teh data. Identified and eliminated duplicate datasets and performed Columns, Primary Key, Foreign Key profiling using IDQ 9.5.1. for teh MDM.
• Effectively communicate wif Business Users and Stakeholders.
• Worked on Master Data Management (MDM), Hub Configurations (SIF), Data Director, extract, transform, cleansing, loading teh data onto teh tables.
• Worked on Agile Methodology, participated in daily/weekly team meetings, guided two groups of seven developers in Informatica PowerCenter/Data Quality (IDQ), peer reviewed their development works and provided teh technical solutions. Proposed ETL strategies based on requirements.
• Design, develop, test and review & optimize Informatica MDM and Informatica IDD Applications.
• Involved in match/merge and match rules to check teh effectiveness of MDM process on data.
• Work on SQL coding for overriding for generated SQL query in Informatica.
• Involve in Unit testing for teh validity of teh data from different data sources.
• Design and develop PL/SQL packages, stored procedure, tables, views, indexes and functions. Experience dealing wif partitioned tables and automating teh process of partition drop and create in oracle database.
• Perform data validation in teh target tables using complex SQLs to make sure all teh modules are integrated correctly.
• Integrated IDQ mappings through IDQ web service applications as cleanse functions in Informatica MDM using IDQ cleanse Adapters. Implementing Slowly Changing Dimension (SCD type II) design for teh Data Warehouse.
• Worked wif Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
• Perform Data Conversion/Data migration using Informatica PowerCenter.
• Involve in performance tuning for better data migration process.
• Analyze Session log files to resolve error in mapping and identified bottlenecks and tuned them for optimal performance.
• Create UNIX shell scripts for Informatica pre/post session operations.
• Automated teh jobs using CA7 Scheduler.
• Document and present teh production/support documents for teh components developed, when handing-over teh application to teh production support team.
• Created Data Model for teh Data Marts.
• Used materialized views to create snapshots of history of main tables and for reporting purpose
• Coordinating wif users for migrating code from Informatica 8.6 to Informatica 9.5
• Contact wif Informatica tech support group regarding teh unknown problem
• Monitored day to day Loads, Addressed & resolved Production issues in an abrupt & timely manner and provided support for teh ETL jobs running in Production in order to meet teh SLA's
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing teh Mapping.
• Prepared SQL Queries to validate teh data in both source and target databases.

Environment: Informatica 10.0/9.6, Informatica Data Quality (IDQ) 9.6, Informatica MDM, Oracle 11g, SQL server 2008 R2, SQL, T-SQL, PL/SQL, Toad 10.6, SQL Loader, OBIEE, Unix, Flat files, Teradata.

Confidentia

ETL Informatica Developer

Responsibilities:

• Working on migrating health care data safely from legacy systems to a new infrastructure.
• Working on Medicare and Medicaid payment system requirements.
• Analyzing teh technical requirements and data flows and prepared technical strategy documents.
• Measuring teh performance benchmarking and fine-tuned existing Informatica Mappings, Sessions, and SQL for better performance by eliminating various performance bottlenecks.
• Worked on creation of new tables and new column additions to existing target and source tables in ETL as per new business requirements.
• Deployed new MDM Hub for portals in conjunction wif user interface on IDD application.
• Installed Informatica Cloud secure agent and set up connections to databases like Oracle, SQL Server and cloud like Salesforce, to run Informatica Cloud mappings.
• Developed Complex mappings to load data to different target entities like cloud, Oracle, XML and Flat files.
• Created Informatica Cloud mappings on Informatica cloud including synchronization and replication tasks and deployed these objects to Informatica power center.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Identify emerging trends in technology in teh MDM space and come up wif innovative solutions, both technical and non-technical.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor and Informatica MDM.
• Worked wif Informatica power exchange and Informatica cloud to integrate Salesforce and load teh data from Salesforce to Oracle db.

Confidential

Sr. Informatica/MDM Developer

Responsibilities:

• Involved in business analysis and technical design sessions wif business and technical staff to develop requirements document and ETL specifications.
• Involved in designing dimensional modeling and data modeling using Erwin tool.
• Created high-level Technical Design Document and Unit Test Plans.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Tuning pre- and post-SQL Syntax.
• Developed mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Update strategy and Sequence generator.
• Created Teradata External loader connections such as MLoad, upset and Update, Fast load while loading data into teh target tables in Teradata Database.
• UsedTeradata utilities fast load, multiload, tpumpto load data.
• Wrote complex SQL override scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve teh performance as teh volume of teh data was heavy.
• Worked on different IDQ /InformaticaDevelopercomponents/transformations like Case, Comparison, Key Generator, Parser, Standardizer, Weight, Exception, Rule Based Analyzer, Lookup, SQL, Expression etc. and created IDQ mappings.
• Worked on IDQ file configuration at user’s machines and resolved teh issues.
• Used IDQ to complete initial data profiling and removing duplicate data.
• Used Informatica EIC (Enterprise Information Catalog) for exploring assets to verify teh quality of data like profiling teh information.
• Performed teh tasks to view relationship between teh assets by using Informatica EIC.
• Extensively used ETL to load data using Informatica Power Center 10.1 from source systems like Flat Files into staging tables and load teh data into teh target database Oracle. Analyzed teh existing systems and made a Feasibility Study.
• Created customer hub (MDM) - by consolidating and integrating various sources and storing teh gloden record as individual identity in teh hub.
• Designed, documented, and configured informatica MDM Hub to load, cleanse, match, merge, and publish MDM Data.
• Successfully completed Customer and Product centric Master Data Management initiatives using Informatica Master data management product.
• Used IDQ’s standardized plans for addresses and names clean ups.
• And extensively worked on IDQ admin tasks and worked as IDQ developer.
• Experience in Performance tuning & Optimization of SQL statements using SQL trace
• Designed and tested packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations such as Execute SQL Task, Mapping teh right and required data from source to destination, Data Flow Task, Data Conversion, For each Loop Container.
• Prepared teh completedata mappingfor all teh migrated jobs using SSIS.
• Creating and monitoring TWS (Tivoli Workload Scheduler) jobs so as job runs and delivers teh data to users.
• Supported teh process steps under development, test and production environment

Environment: Informatica Power Center 10.1, 9.6.1, Informatica Power Center 8.6.1, MDM and IDQ, Oracle 11g/10g, TOAD, Business Objects XI3.5, Solaris 11/10, Teradata, clear case, PL/SQL, Tivoli Job Scheduler, SSIS.

Confidential,

Sr. Informatica Developer/ IDQ Developer

Responsibilities:

• Prepared High-level Design and Low-Level Design based on Functional and Business requirements of teh project.
• Designing & documenting teh functional specs and preparing teh technical design.
• As a team conducted gap analysis and Discussions wif subject matter experts to gather requirements, emphasize on problem areas and define deliverables.
• Supported teh development, optimization, and maintenance of Informatica mappings wif various source data including Oracle and SQL.
• Optimized and Tuned SQL queries and PL/SQL blocks to eliminate Full Table scans to reduce Disk me/O and Sorts.
• Designed and developed UNIX Shell scripts for creating, dropping tables which are used for scheduling teh jobs.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed several complex mappings in Informatica a variety of Informatica PowerCenter 9.6 transformations, Mapping Parameters, Mapping Variables, Mapplets& Parameter files.
• Developed several IDQ complex mappings in Informatica a variety of Power Center, transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica Power Center 9.6.
• Used IDQ to complete initial data profiling and removing duplicate data.
• Worked wif IDQ on data quality for data cleansing, robust data, remove teh unwanted data, correctness of data.
• Extensive experience in integration of Informatica Data Quality (IDQ) wif Informatica PowerCenter
• Worked on IDQ file configuration at user’s machines and resolved teh issues.
• Used IDQ to complete initial data profiling and removing duplicate data.
• Involved in running and scheduling UNIX Shell scripts, Informatica jobs using Tidal
• And extensively worked on IDQ admin tasks and worked as both IDQ Admin and IDQ developer.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in teh Informatica Designer.
• Created Data stage jobs (ETL Process) for populating teh data into teh Data warehouse constantly from different source systems like ODS, flat files, HDFS Files and scheduled teh same using Data Stage Sequencer for System Integration testing.
• Developed, maintained programs for scheduling data loading and transformations using DataStage
• Developed mapping parameters and variables to support SQL override.
• Worked on import and export of data from sources to Staging and Target using Teradata MLOAD, Fast Export, TPUMP and BTEQ.
• Developing workflows wif Worklets, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Expertise in Performance Tuning by identifying teh bottlenecks at sources, targets, PowerCenter transformations and session’s level. Collected performance data for sessions and performance tuned by adjusting Informatica session parameters.
• Handling all Hadoop environment builds, including design, capacity planning, cluster setup, performance tuning and ongoing monitoring.
• Worked wif teh third-party scheduler Autosys for scheduling Informatica PowerCenter Workflows Involved wif Scheduling team in creating and scheduling jobs in Autosys Workload Scheduler.
• Extensive documentation on teh design, development, implementation, daily loads and process flow of teh mappings.

Environment: menformatica Power Center 9.6, Oracle 11g, SQL, IDQ, Teradata, DataStage, PL/SQL, TOAD, Microsoft Visio, Autosys, Unix, SQL Server 2008.