SUMMARY:

• 8+ years of IT experience in Analysis, Design, Development, Administration and Support of Data Wharehousing and Governance solutions using Informatica, IDQ, Teradata, Oracle, PL/SQL and Unix shell scripting along industry verticals like SCM, Banking, Financial Services.
• Worked with client facing environments for requirements gathering and drafting those requirements into design and estimation templates for effective project deliverables.
• 4+ years of experience in Informatica IDQ
• Closely worked with business SMEs on developing the business rules for cleansing and performed data profiling & various data quality rules development using Informatica Data Quality.
• Extensively worked on Customer & Supplier match analysis and Address standardization using IDQ transformations.
• Experienced in developing and maintaining Data Warehouse applications using INFORMATICA Powercenter with optimum design solutions.
• Developed complex mappings in Informatica using different transformations Joiner, Aggregator, Update Strategy, Rank, Router, Lookup - Connected & Unconnected, Sequence Generator, Filter, Sorter, Source Qualifier, Expression, Union, Stored Procedure transformation
• Excellent hands-on ETL Informatica Power Center (Source Analyzer, Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation Developer) and Repository Manager, Workflow Monitor and Repository Server Admin Console with strong business understanding in different domains.
• Strong knowledge in Data warehousing concepts, dimensional Star Schema, Snowflakes Schema and Galaxy Schema methodologies.
• Excellent understanding of Software Development Life Cycle (SDLC).
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings and sessions.
• Hands on experience in tuning mappings, identifying and resolving performance in various levels like sources, targets, mappings, and sessions.
• Excellent communication and strong interpersonal skills with the ability to interact with end-users, managers and technical personnel.
• Having knowledge on Data model Design (Conceptual/Logical/Physical) in Data Warehouse solutions using Erwin 9.x/8.x/7.x Data Modeler and SQL Developer Data Modeler 3.x Tools.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server and Worked on integrating data from flat files like fixed width and delimited.
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Experience with Informatica Advanced Techniques like Dynamic Caching, Memory Management, Parallel Processing to increase Performance throughput.
• Extensively involved in Optimization and Performance Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks, memory management and partitioning.
• Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
• Extensively used Informatica Repository Manager and Workflow Monitor.
• Knowledge in developing reports using Business Intelligence tools like Business Objects, Tableau, and Cognos.
• Extensively used Informatica PowerCenter 9.6/9.5/9.1, Informatica Data Quality (IDQ) 9.6.1/9.5/9.1 as ETL tool for extracting, transforming and loading data from various source data inputs to various targets, in batch and real time.
• Extensive knowledge of data warehouse approaches - Top down (Inmon’s approach) and Bottom up (Kimball’s approach), methodologies- Star Schema, Snowflake.
• Followed Agile methodology, Scrum process.
• Extensive experience as Teradata developer, used various Teradata utilities such as TPT(Teradata Parallel Transporter), Fastload, Multiload, TPump, BTEQ (to invoke these utilities & queries).
• Experience in handling huge volumes of data using Teradata utilities, temporary tables.
• Expertise in writing complex SQL’s and executing them through Teradata BTEQ.
• Extensive experience in other relational databases like Oracle, DB2, SQL Server.
• Extensive experience in integrating data from flat files - fixed width, delimited, XML, WSDL, Web Services by using various transformations available in Informatica such as - Source qualifier, XML parser, Web services consumer transformation.
• Extensively used various Informatica Powercenter and Data quality transformations such as - source qualifier, aggregator, update strategy, expression, joiner, lookup, router, sorter, filter, web services consumer transformation, XML Parser, address validator, comparison, consolidation, decision, parser, standardizer, match, merge to perform various data loading and cleansing activities.
• Created various profiles using Informatica Data Explorer (IDE) & IDQ, from existing sources and shared those profiles with business analysts for their analysis on defining business strategies in terms of activities such as assigning matching scores for different criteria etc.

TECHNICAL SKILL:

Architecture : EDW (Enterprise Data Warehousing), BIRA (Business Intelligence Reference Architecture), FDW (Federated Data Warehousing)

Business Systems: Insurance, Enterprise Claims Management Systems, Banking products.

Methodologies/Data Modeling Tools: Data Mart, Dimensional, Snow Flake, Star Schema, ERWIN

Databases: Teradata 15/14/13, Oracle 11g /11i/10g, DB 2 10.1 / 9.7/ 9.5/ 9.1, SQL Server 2012 / 2008.

Data Warehousing: Informatica PowerCenter 9.6.1/9.5/9.1, Informatica Data Quality (IDQ) 9.6.1/9.5, Informatica Data Explorer (IDE), Informatica DVO (Data Validation Option) 9.1/9.5, Business Objects XIR3

Scripting Languages: Unix Shell Script

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Informatica Developer

Responsibilities:

• Worked as ETL developer to integrate data ware house of acquired company to provide single-view to the business
• Performed data quality analysis, gathered information to determine data sources, data targets, data definitions, data relationships, and documented business rules.
• Worked with business SMEs on developing the business rules for cleansing. Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Perform the data profiling and Data quality solutions to the data sets to the business requirements.
• Extremely worked with DQ transformations like Standardizer, Labeler, Parser, Address Validator, Match, Key Generator, Association etc.
• Worked with the DQA for handling exception records by the business team and implemented the Postal address validation for the Supplier data sets.
• Extensively involved in Performance tuning of the mappings and then made performance improvements to the database by building the tables and using bit map indexes and push down optimizations
• Developed Mappings and Sessions based on user requirements and business rules to load data from source tables to target tables based on the design document.
• Developed Mappings and Sessions based on given requirements and business rules to load data from desired sources to targets.
• Developed several mappings using the transformations like Source qualifier, Aggregator,Expression lookup, Router, Filter, Joiner and sorter transformations.
• Extensively used various performance tuning techniques to improve the performance.
• Configured and executed sessions to load data into the target database.
• Created work lets and workflows for historical and incremental loads.
• Developed procedures to populate the customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
• Worked on optimizing and tuning the Teradata views and SQL’s to improve the performance of batch and response time of data for users
• Involved in unit testing and also in internal quality analysis procedures and reviews.

Environment: Informatica Powercenter 9.5 Repository Manager, Designer, IDQ, CSV files, PL/SQL(Stored Procedure, Trigger, Packages), SQL Developer,UNIX

Confidential, Weehawken, NJ

Informatica Developer

Responsibilities:

• Informatica powercenter & IDQ developer on a data warehouse initiative responsible for requirements gathering, preparing mapping document, designing ETL flow, building complex ETL procedures, developing strategy to move existing data feeds into the Data Warehouse (NDW) and additional target data warehouses.
• Worked closely with business users in understanding the requirements, preparing technical specifications documents.
• Used several Informatica transformations such as - expression, update strategy, router, filter, sequence generator, aggregator, joiner, sorter, XML parser, XML generator, web services to perform various integration activities.
• Extensively used Informatica data quality transformations - Parser, standardizer, match, consolidator, Address validator, classifier to transform, cleanse and consolidate source data.
• Extensive experience in integrating Informatica Data Quality mappings/mapplets with Informatica powercenter.
• Used Informatica Data Explorer (IDE) to profile source data, create scorecards and track the progress of data cleansing activities.
• Created explain plans for long running queries, worked with DBA’s to identify and solve the bottlenecks by adding appropriate indexes.
• Extensively used Informatica web services Consumer transformation to invoke 3rd party web services on Billing, Payments.
• Enabled Informatica workflows as web service to be invoked and used by different client systems.
• Created test Java programs to test the Informatica web services and Try-it option on Web Service Hub.
• Extensively used XML parser transformations to parse results from Web services output i.e. SOAP messages.
• Extensive knowledge on banking products, equities and bonds.
• Prepared implementation document for moving the code from development to QA to production environments.
• Worked with QA team and implementation team during different phases of the project.

Environment: Informatica Power Center 9.1, Teradata 13, Oracle 11i, Fastload, Multiload, Tpump, Fastexport, Oracle 11i, Web services, Java, Business Objects XI R2, Linux, Windows XP, SQL, PL/SQL, XML, SQL Loader, TOAD, control-M, Toad 9.5, Korn shell, Erwin.

Confidential, West Chester, PA

ETL Informatica Powercenter/IDQ Developer

Responsibilities:

• Senior Informatica powercenter/IDQ/Teradata developer on a data warehouse initiative responsible for requirements gathering, preparing mapping document, designing ETL flow, building complex ETL procedures, developing strategy to move existing data feeds into the Data Warehouse (NDW) and additional target data warehouses.
• Worked closely with business users in understanding the requirements, preparing technical specifications document and sharing data for UAT for production sign off.
• Extensive experience in building high level documents depicting various sources, transformations and targets.
• Extensively used Informatica transformations - Source qualifier, expression, joiner, filter, router, update strategy, union, sorter, aggregator and normalizer transformations to extract, transform and load the data from different sources into DB2, Oracle, Teradata, Netezza and SQL Server targets.
• Extensively used Informatica Data Explorer (IDE) & Informatica Data Quality (IDQ) profiling capabilities to profile various sources, generate score cards, create and validate rules and provided data for business analysts for creating the rules.
• Extensively used Standardizer, Labeler, Parser, Address Validator, Match, Merge, Consolidation transformations.
• Extensively worked on performance tuning of Informatica and IDQ mappings.
• Created Informatica workflows and IDQ mappings for - Batch and Real Time.
• Converted and published Informatica workflows as Web Services using Web Service Consumer transformation as source and target.
• Created reusable components, reusable transformations and mapplets to be shared among the project team.
• Used in-built reference data such as - token sets, reference tables and regular expressions to and built new reference data objects for various parse/cleanse/purging needs.
• Extensive experience in integration of Informatica Data Quality (IDQ) with Informatica PowerCenter.
• Extensively used XML, XSD / schema files as source files, parsed incoming SOAP messages using XML parser transformation, created XML files using XML generator transformation.
• Worked extensively with Oracle external loader - SQL loader - to move the data from flat files into Oracle tables.
• Worked extensively with Teradata utilities - Teradata Parallel Transporter (TPT), Fastload, Multiload, TPump to load huge amounts of data from flat files into Teradata database.
• Extensively used Fastexport to export data out of Teradata tables.
• Created BTEQ scripts to invoke various load utilities and queries against Teradata database.
• Created proper PI taking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Complete understanding of Primary & Secondary indexes (Unique & Non-Unique) and what to use when.
• Used global temporary tables, volatile tables while creating complex queries.
• Generated explain plans for performance tuning of queries and identifying the bottlenecks for long running queries.
• Extensively used PowerExchange for Mainframe to read data from mainframe / VSAM/ COBOL files and load into Oracle tables.
• Scheduled Informatica & Teradata jobs in production using UC4 & Autosys scheduling tools.
• Owned the defects from production as well as from system testing and worked on the solutions.
• Extensive knowledge on defect tracking tools - JIRA, TRAC.
• Extensively used RMS as version control management tool.
• Involved in unit testing and prepared documents with job flow information for QA team for their testing purpose and coordinated with QA team for defect fix and regression testing.
• Prepared implementation documents for every release, worked on initial loads and data catchup process during implementations and provided on-call support for first few days of execution.
• Extensive experience in PL/SQL programming, stored procedures, functions and triggers.
• Built UNIX Linux shell scripts for running Informatica workflows, data cleansing, purge, delete, and data loading and for ELT process.
• Knowledge on Business objects, updated existing universe with the new data objects and classes using universe designer, built joins between new tables, used contexts to avoid loops and Cartesians.
• Created Procedure Document for Implementation procedures for every release for all the Teradata, UNIX, Informatica Objects and if any catch-up process needed to be done.
• Provided on-call support for the newly implemented components.

Environment: Informatica Power Center 9.6.1, Informatica Data Quality (IDQ) 9.6.1, Informatica Data Explorer (IDE) 9.6.1, Teradata 15, Oracle 11i, DB2 10.1, LOAD, Ingest, TPT(Teradata Parallel Transporter), Fastload, Multiload, Tpump, Fastexport, SQL Developer, ERWIN, PL/SQL, RMS, Linux, AIX, TOAD, Winsql, Putty, UltraEdit, PowerExchange for mainframes, XML, UC4, Autosys, JIRA, Lotus Notes, UNIX Scripting, Unix shell scripting, Microsoft Visio, XML Spy, Business Objects XI R3

Confidential, Bloomington, IL

Informatica, IDQ Developer

Responsibilities:

• Performed the roles of Senior ETL Informatica and IDQ developer on a data warehouse initiative and was responsible for requirements gathering, preparing mapping document, architecting end to end ETL flow, building complex ETL procedures, developing strategy to move existing data feeds into the Data Warehouse (DW) and additional target data warehouses.
• Collaborated with data architects, BI architects and data modelling teams during data modelling sessions.
• Involved in functional design reviews and lead technical design reviews.
• Extensively used Informatica transformations - Source qualifier, expression, joiner, filter, router, update strategy, union, sorter, aggregator and normalizer transformations to extract, transform and load the data from different sources into Teradata, Oracle, DB2 and SQL Server targets.
• Extensively used ETL Informatica to integrate data feed from different 3rd party source systems – Claims, billing, payments.
• Extensively used Informatica Data Explorer (IDE) & Informatica Data Quality (IDQ) profiling capabilities to profile various sources, generate score cards, create and validate rules and provided data for business analysts for creating the rules.
• Used Informatica Data Quality transformations to parse individual consumer information from various vendors such as Acxiom, Alliant to identify the true source of policy holder’s origination and assign credits accordingly by performing various activities such as standardization, labeling, parsing, address validation, address suggestion, matching and consolidation to identify redundant and duplicate information and achieve MASTER record.
• Extensively used Informatica Data Quality transformations – Parser, Standardizer, Match, Merge, Address Validator, Case Converter, Classifier.
• Extensively used in-built reference data such as – token sets, reference tables, regular expressions to parse/cleanse/purge incoming data.
• Extensive experience in integration of Informatica Data Quality (IDQ) with Informatica PowerCenter.
• Created various data quality mappings in Informatica Data Quality tool and imported them into Informatica powercenter as mappings, mapplets.
• Extensively used Informatica Analyst tool (IDE) to profile source data, create score cards.
• Extensive experience in data profiling, creating score cards using Developer Client.
• Extensively used PowerExchange for Mainframe to read data from mainframe / VSAM/ COBOL files and load into DB2 tables.
• Worked extensively with Teradata utilities – TPT(Teradata Parallel Transporter), Fastload, Multiload, TPump to load huge amounts of data from flat files into Teradata database.
• Extensively used Fastexport to export data out of Teradata tables.
• Extensive experience with DB2 load and Ingest external loaders.
• Created explain plans for long running queries, worked with DBA’s to identify and solve the bottlenecks by adding appropriate indexes.
• Extensively used Informatica web services Consumer transformation to invoke 3rd party web services on Billing, Payments.
• Enabled Informatica workflows as web service to be invoked and used by different client systems.
• Created test Java programs to test the Informatica web services and Try-it option on Web Service Hub.
• Extensively used XML parser transformations to parse results from Web services output i.e. SOAP messages.
• Involved in performance tuning of existing SQL queries.
• Involved in performance tuning of Informatica mappings.
• Extensive knowledge on banking products, equities and bonds.
• Created complex ETL Informatica procedures to load data from legacy systems.
• Prepared implementation document for moving the code from development to QA to production environments.
• Worked with QA team and implementation team during different phases of the project.

Environment: Informatica Power Center 9.5, Informatica Data Quality (IDQ) 9.5, Teradata 14, Oracle 11i, DB2 10.1, Ingest, Fastload, Multiload, Tpump, Fastexport, Oracle 11i, Web services, Java, Business Objects XI R2, Linux, Windows XP, SQL, PL/SQL, XML, SQL Loader, TOAD, control-M, Toad 9.5, Korn shell, Erwin.

Confidential, Seville, OH

Informatica Developer

Responsibilities:

• Requirements Gathering and Business Analysis.
• Design of Physical and Conceptual models for the database.
• Analyzed the data models of legacy implementations, identifying the sources for various dimensions and facts for different data marts according to star schema design patterns.
• Analyze and document the level of effort for all Stages of all ETL projects.
• Studying the existing environment, validating the requirements and gathering source data by interacting with clients on various aspects.
• Designed the Functional Requirements and Mapping Technical Specifications.
• Worked with Customer Master Team to get the customer data.
• Developed and documented Informatica Mappings/Transformations, and Informatica sessions per the business requirement.
• Designed and encouraged use of mapplets in Informatica to promote reusability, eliminate coding redundancy and ease maintenance of version control.
• Debugging and Troubleshooting Informatica Mappings.
• Created sessions, workflows and worklets to run with the logic embedded in the mappings using Power center Designer
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions.

Environment: Informatica 7.1.2 (Power Connect, Power Mart, Power Center, Designer, Workflow Manager, Administrator and Repository Manager) Oracle 9i, PL/SQL, TOAD, Business Objects 6.5, UNIX

Confidential, Houston,TX

Informatica Developer

Responsibilities:

• Gathered business requirements, established functional specifications, translated them to design specifications.
• Data conversions from different legacy systems in accordance with the business rules into the Oracle Application system.
• Worked closely with SME’s to convert the legacy data for assigned modules.
• Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations.
• Written Complex SQL overrides for source qualifier and Lookups in mappings.
• Designed and developed validation scripts based on business rules to check the Quality of data loaded into EBS.
• Written ETL specifications for all the development tasks, to better evolve the ETL design.
• Involved in Data Quality Analysis to determine cleansing requirements.
• Helped the team in analyzing the data to be able to identify the data quality issues.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Extensively worked with aggregate functions like Avg, Min, Max, First, Last, and Count in the Aggregator Transformation.
• Extensively used SQL Override, Sorter, and Filter in the Source Qualifier Transformation.
• Extensively used Normal Join, Full Outer Join, Detail Outer Join, and master Outer Join in the Joiner Transformation.
• Done caching optimization techniques in Aggregator, Lookup, and Joiner transformation.
• Performance tuning to ensure optimal session performance.
• Extensively used Informatica debugger to validate Mappings and to gain troubleshooting information about data and error conditions.
• Used Erwin for data modeling and Dimensional Data Modeling.
• Designed and created logical & physical data models to support strategic business decisions.
• Designed, Developed, Reengineered and fine-tuned SQL queries and Oracle Stored Procedures and triggers.
• Involved in Designing data models for Data warehouse supporting data from multiple sources on real time.
• Designed and developed Informatica mappings for data loads.

Environment:: Informatica 8.5(Repository Manager, Repository Server Administration Console, Power Center Designer, Workflow Manager, Workflow Monitor), Power Analyzer 4.1, Erwin 4.0, COBOL, Oracle 10g, Teradata, PL/SQL, Autosys, Windows 2000, DB2, Windows NT 4.0