SUMMARY

• About 6+ years of experience in Information Technology with a strong background in Database development and Data warehousing and ETL process using Informatica Power Center and IDQ (Informatica Data Quality).
• Strong experience in creating ETL processes using Informatica Power center, Informatica Designer (joiner,expressions, lookups, filters, stored procedures etc.,), Informatica Workflow Manager (Sessions, Sources, targets, transformations etc., & direct, indirect sources), Informatica Workflow Monitor, Informatica Administration Console and Repository Manager.
• Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Worked on Data Profiling using IDE - Informatica Data Explorer and IDQ-Informatica Data Quality to examine different patterns of source data. Proficient in developing Informatica IDQ transformations like Parser, Classifier, Standardizer and Decision.
• Experience in several facts of MDM implementations including Data Profiling, Data extraction, Data validation, Data Cleansing, Data Match, Data Load, Data Migration, Trust Score validation.
• Experience in integration of various data sources with Multiple Relational Databases like DB2, Oracle, SQL Server and worked on integrating data from flat files like fixed width and delimited.
• Worked on MDM Hub configurations - Data modeling & Mappings, Data validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica Data Director (IDD).
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Expertise in full life cycle of ETL (Extraction, Transformation and Loading) using Informatica Power Center (Repository Manager, Server Manager, Mapping Designer, Workflow Manager, Workflow monitor).
• Analyzed COBOL code for field level analysis.
• Implemented performance tuning techniques at application, database and system levels.Experience in UNIX shell programming.
• Solid understanding of Relational (ROLAP) and Multidimensional (MOLAP) modeling, broad understanding of data warehousing concepts, star and snowflake schema database design methodologies and Meta data management.
• Expertise in working with Oracle Stored Programs, Packages, Cursors, Triggers, Database Link, Snapshot, Roles, Privileges, Tables, Constraints, Views, Indexes, Sequence, and Synonyms Dynamic SQL and SQL*Loader in distributed environment.
• Expertise in working with different data sources like flat files, XML, Teradata, DB2, and Oracle.
• Experience in SQL-tuning using Hints, and Materialized Views. Expertise in understanding Fact Tables, Dimension Tables, and Summary Tables.
• Good exposure to development, testing, debugging, implementation, documentation, user & production support.
• Have a clear understanding of Business Intelligence and Data Warehousing Concepts.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

TECHNICAL SKILLS

ETL Tools: Informatica Data Quality (IDQ), Informatica Power Center 9.6, Informatica PowerExchange, Informatica Data Quality (IDQ)

Reporting Tools: SSRS, Oracle BI Business Intelligence (OBIEE 10.1.3.x, Siebel Analytics 7.x.), Business Objects, Cognos 8.4 (Awareness).

Scheduling Tool: OBIEE DAC, Autosys, Tidal, Control M, Puppet, Chef

Operating System: UNIX, WINDOWS & LINUX

Database: Oracle 11g/10g/9i, Netezza,MS SQL Server 2012/2008/2005 , DB2, Teradata

Database tools: SQL PLUS, Toad, SQL Developer, SQL Assistant

Languages: Basic, PL/SQL, SQL,SQL* Loader, UNIX shell programming, C, C++,, COBOL

PROFESSIONAL EXPERIENCE

Confidential, Southbury CT

Sr. ETL IDQ /MDM Developer

Responsibilities:

• Created ETL Design documents and technical specifications for ETL team to understand the Star & Snowflake Schema designs related to Fact & Dimension Tables in MDM.
• Worked with Informatica Data Quality 9.6 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling.
• Identified and eliminated duplicates in datasets thorough IDQ 9.6 Algorithms of Edit Distance, Jaro Distance, Hammer Distance and Mixed Field matcher, It enables the creation of a single view of customers data.
• Worked onInformaticaPower Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Developed IDQ mappings using various transformation like Labler, Standarization,Case Converter, Match and Address validation Transformation
• Extracted the provider records based on given requirement and sending the error messages for the records excluded from state file.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Wrote SQL overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Designing, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
• Developed IDQ mappings using various transformation like Labler, Standarization, Case Converter, Match and Address validation Transformation.
• Worked on Informatica MDM tool for the data processing of the master data as required by the Business users.
• Developed data conversion, quality, cleansing rules and executed data cleansing activities such as data Consolidation, and standardization for the unstructured flat file data.
• Created various transformations such as Expression, Lookup, Joiner, Router, Filter, Aggregator and Sequence Generators.
• Worked closely with MDM team and testing team to resolve any data issues.
• Extensively used SQL Scripts and worked in UNIX Environment.
• Extensively worked in the performance tuning of the ETL process at mapping and transformation level.
• Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed debugged mappings for failed sessions.
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Developed UNIX Shell Scripts to start the Informatica jobs using command line.
• Worked withre-usablesessions,decisiontask,controltask andEmailtasks foron success, on failuremails.
• Deploying and scheduling Reports using Business Objects to generate all daily, weekly, monthly and quarterly Reports including current status.

Environment: Informatica Power Center 9.6, Informatica Data Quality IDQ 9.6, Informatica MDM, Teradata 12, SSRS, Oracle 11/10g, PL/SQL, Perl Scripting, SSRS, Autosys, TOAD 9.x,Oracle Financials, Shell Scripting, python, Dynamic SQL, Oracle SQL *Loaderand UNIX.

Confidential, Billerica MA

ETL InformaticaDeveloper

Responsibilities:

• Design and develop data migration mappings and workflows to load data from SQL Server to Oracle using Informatica.
• Performed performance tuning of the Informatica jobs to load large volume of the data. Extensively used reusable objects like mapplets, sessions and transformations in the Mappings.
• Developed sequential, concurrent sessions and validated them. Scheduled these sessions using workflowmanager.
• Creating Informatica MDM Base objects, staging tables, mappings, setting up strong match rules and creating IDD applications.
• Developed complex Informatica mappings using various transformations- Source Qualifier, Normalizer, Filter, Connected Lookup, Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator, Reusable sequence generator transformation.
• Designing, document and configure the Informatica MDM Hub to support loading, cleansing, matching, merging, and publication of MDM data.
• Tuned target, source, transformation, mapping, and session to improve session performance Expertise in understanding the reporting requirements.
• Developed stored procedures and tested the application with Toad. Developed PL/SQL procedures andfunctions to build business rules which are helpful to extract data from source and load data to target.
• Created and maintained the Shell Scripts and Parameter files in UNIX for the proper execution of Informatica workflows in different environments.
• Extensively used debugger to find out errors in mappings and later fixed themExpertise in running and controlling workflows using the pmcmd.

Environment: Informatica MDM, InformaticaPower Center 9.1, Power Designer,Power Exchange, Work Flows, ETL, Oracle 11g, Teradata, XML, SSRS, Web-Services, MS SQL Server, TOAD 9.6.1, Unix Shell Scripts, Autosys.

Confidential, Houston, TX

ETL Informatica Developer

Responsibilities:

• Responsible for requirement gathering from various groups. Followed Iterative Waterfall model for Software Development Life Cycle Process (SDLC).
• Designed and developed Informatica mapping codes to build business rules to load data.
• Extensively worked on Informatica Lookup, stored procedure and update transformations to implement complex rules and business logic.
• Analyzed and created facts and dimension tables.
• Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all applications and systems.
• Developed the functionality at the database level PL/SQL using Toad tool as well at the Unix OS level using shell scripting.
• Experienced in identifying and documenting data integration issues, challenges such as duplicate data, nonconfirmed data, and unclean data
• Imported Source/Target Tables from the respective databases and created Reusable Transformations (Joiner, Routers, Lookups, Rank, Filter, Expression and Aggregator), Mapplets and Mappings using Designer module of Informatica.
• Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Participated in PL/SQL and Shell scripts for scheduling periodic load processes.
• Worked extensively on SQL coding to check the data quality coming from the respective parties.
• Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and databases.
• Applied performance tuning techniques for cubes to reduce calculate time and partitioned cubes.

Environment: InformaticaPower Center 8.1, Oracle 9i, SQL, PL/SQL, SQL*Plus,Unix Shell Scripting.

Confidential

ETL Developer

Responsibilities:

• Developed ETL mappings, Transformations and Loading using Informatica Power Center.
• Extensively used ETL to load data from Flat file, MS Excel, which involved both fixed width as well as Delimited files and also from the relational database, which was Oracle.
• Developed and tested all the Informatica mappings, sessions and workflows - involving several Tasks.
• Worked on Dimension as well as Fact tables, developed mappings and loaded data on to the relational tabase.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, update strategy, Lookup, sequence generator, joiner, Stored Procedure.
• Analyzed the session, event and error logs for troubleshooting mappings and sessions.
• Provided support for the applications after production deployment to take care of any post-deployment issues.

Environment: SQL Server 2000/ 2005,PL/SQL,SSIS,T-SQL,SQL*LOADER, Microsoft Office, Windows 2003/XP.