SUMMARY:

• 9+ years of extensive experience in Analysis, Design, Development, Implementation & maintenance of Informatica ETL processes, OLTP & Data Warehouse systems, Business Intelligence and Enterprise Application Integration.
• Solid expertise in Data Extraction, Data Migration, Data Transformation and Data Loading using ETL process in Informatica Power Center 9.x/8.x/7.x and Informatica Data Quality and Informatica Data Analyst tools and expertise skills in reporting using the Business Objects.  
• Experience in all the phases of life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Creation of ETL frame work and review of high level design document
• Proficient in data modeling for OLTP relational databases and Data warehouse applications using Ralph Kimball and Bill Inman design principles including Facts and dimensions tables, Slowly Changing Dimensions (SCD) and Dimensional Modeling - Star and Snow Flake Schema.
• Developed a Conceptual model  using Erwin based on requirements analysis
• Developed normalized Logical  and Physical  database models to design OLTP system for insurance applications
• Having very good knowledge in Informatica Data Quality 9.7.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r8.0
• Strong working knowledge in design and development of ETL (Informatica) Process, Data (Dimensional and Relational) modeling for Data warehouse (EDW)
•  Proficient with Informatica ETL Integration with Oracle, SAP, Mainframe, Siebel CRM, SFDC, SQL Server, Mainframe and other ERP / CRM systems.
• Experience in integration of various data sources like Oracle, Teradata, DB2, Sybase, SQL server, MS Access and non-relational sources like Flat files and XML files into staging area.
• Experience in developing XML/XSD/XSLT as a part of Source XML files for Informatica and also  input XML for Web service Call.
• Experience in designing Reusable Transformations in Informatica such as Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and security configuration in Informatica server (end-to-end), Power exchange, Power Connect processing and using Workflow Manager to move data from multiple sources into targets.
• Loading XML messages received from various hospitals across the nation into Database using JMS JBOSS queues/Informatica.
• 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.
• Strong Knowledge in developing   OBIEE/Siebel Analytics Repository (.rpd) - three layers (Physical Layer, Business Model & Presentation Layer)
• Having strong knowledge on setting up  LDAP  for   OBIEE.
• Experience with creating profiles, rules, scorecards for data profiling and quality using IDQ
• Data Cleansing rules for MDM Projects
• Experience in identifying bottlenecks in ETL Processes and Performance tuning of applications using Database Tuning, Partitioning, Index Usage, and Aggregate Tables, Session partitioning, Load strategies, commit intervals and transformation tuning.
• Solid experience with Informatica Power Center Data Validation client for Unit testing ETL mappings and transformations.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Strong SQL, PL/SQL, T-SQL programming skills in Oracle 12c/11g/10g, SQL Server 2012/2008/2000 , Teradata14/13/12 and DB2 databases. Proficient in writing Packages, Stored Procedures, Triggers, Views, Indexes and query optimization.
• Experience in SFDC development using Apex classes and Triggers, Visual Force, Force.com IDE, SOQL.
• Proficient in running Explain Plans for SQL queries to identify performance issues.
• Experience in d esigning and developing B2B transformations for EDI and other formats using InformaticaB2B Data Exchange.
• Expertise in deploying and maintaining Informatica ETL code in Production environment.
• Extensive experience with Teradata SQL Assistant and Teradata Load/Unload utilities like TPUMP, Fast Export, Fast Load, MultiLoad and BTEQ.
• Experience with issue and project management tool JIRA to track defects. Solid experience in project documentation including Technical specifications and Technical Design Documents (TDD).
• Strong trouble-shooting, problem solving, analytical and design skills.
• Possess effective communication, professional attitude, strong work ethic and interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 8.1.1/ 8.6.1/9.01/9.1.0/9.5/9.6.

Data Quality: IDQ 8.x/9.x/9.6.

Data Modeling Tools: Erwin 8.0.

Programming Languages: SQL, Oracle PL-SQL, Java Script.

Management: Agile/Water fall model.

Databases: Oracle 10/9i/8, MYSQL, MS SQL server, Teradata, DB2, SOQL.

BI Tools: Informatica Scheduler, Informatica Visio Data Stencil

Scheduler Tools: AutoSYS, Tivole work scheduler (TWS).

IDE’s & Utilities: Eclipse and JCreator.

Web Dev Technologies: HTML, XML.

Protocols: TCP/IP, HTTP and HTTPS.

Web services: SOAP UI, Tomcat.

Operating Systems: Linux, MacOS, WINDOWS 98/00/NT/XP.

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr. Informatica developer

Responsibilities:

• Gathered requirements from CRM and Salesforce team and created ETL Mapping Specification Documentation.
• Involved in the ETL technical design discussions and created ETL high level technical design document
• Involved in the analysis of source to target mapping provided by data analysts and prepared functional and technical design documents
• Involved in System Study and Transferred knowledge to offshore team
• Analyzed Salesforce data and then extracted into Microsoft SQL Server 2012.
• Worked with Informatica Data Quality 9.6 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 9.6.
• Developed IDQ mappings using various transformations like Labler, Standarization, Case Converter, Match and Address validation Transformation.
• Developed mapping using Key Generator Transformation with Match Transformation.
• Analyzed Salesforce data and then extracted into Microsoft SQL Server 2012.
• Developed complex Mappings using various transformations like expression, lookups, Update strategy, Sequence generator, Java, Rank, Aggregator, SQL, Xml, Stored procedure and Normalizer.
• Created complex SCD Type 1, Type 2 and Type 3 mappings using Dynamic Lookup, Joiner, Router, Union, Expression transformations.
• Extensively worked in cleaning data from salesforce before loading into SQL Server 2012.
• Having good knowledge on medical procedures, physician’s services and Revenue codes.
• Created Tables, Views, Constrains, Synonyms, Sequences.
• Used the inner join, outer join, cross join while writing the complex SQL Queries.
• Used Collection objects, ref cursor, and bulk collect, aggregate functions while Writing SQL Queries.
• Used workflow Monitor to monitor the performance of the Jobs.
• Extensively worked in the performance tuning of the ETL process at mapping and transformation level.
• Involved in System Study and Transferred knowledge to offshore team
• Distribution of work to onsite and offshore team and follow-ups.
• Responsible to migrate the mappings into testing and production environment.
• Reviewing the work and submitting the work to client with sufficient documentation
• Responsible to migrate the mappings into testing and production environment.

ENVIRONMENT: Informatica PowerCenter9.6, Informatica Data Quality IDQ 9.6, Salesforce.com, Microsoft CRM, SQL, SQL Server2012, Informatica Scheduler.

Confidential, Charlotte, NC

Senior Informatica developer

Responsibilities:

• The main goal of this project is to load the data from PeopleSoft and flat files into a staging area and then into Enterprise Data warehouse (EDW) by using Informatica. I was involved in using Informatica Power Center as an ETL tool to load the data in Data Staging area and then ultimately into Enterprise Data Warehouse which consist of multiple subject areas.
• Worked with business analysts to gather requirements. Responsible for converting Functional Requirements into Technical Specifications and design documents.
• Designed and developed Informatica ETL process to integrate data from loyalty, sales third-party vendors that are being phased out.
• Design, configuration of Informatica web services to automate the EID requests using Web Services Hub.
• Working with various sources such as Flatfiles, Relational, XML and Web services as part of Informatica Mappings.
• Designed and developed dimensional model for Customer Data Warehouse in Teradata14and Created Fact and Dimensional tables in the Star Schema for data warehouse.
• Implemented data cleansing, match/merge, de-duplication, standardization using Informatica IDQ transformations like Parser, Standardizer, Classifier, Match, Merge and Decision to create golden copies of Customer. Successfully completed data integration into MDM.
• Analyzed and extracted data from the PeopleSoft to Oracle Instance.
• Created profiles to analyze the structure of source data. Created and applied rules in profiles
• Used IDQ analyst tool to create rules and apply while running column profiling
• Worked on designer tools Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities.
• Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator.
• Created complex SCD Type 1, Type 2 and Type 3 mappings using Dynamic Lookup, Joiner, Router, Union, Expression transformations.
• Identified   issues,   performance   bottlenecks and optimized the Business Intelligence   Dashboards and   Reports.
• Created scorecards to visually represent data quality progress and to score the frequency of each value for columns.
• Created Pre-Sql and Post-Sql scripts which need to be run at Informatica level.
• Developed SQL, PL/SQL, T-SQL Stored Procedures and Views in Oracle 11g, SQL Server2012 and Teradata 14.
• Extensively used Explain Plans to identify SQL query performance and created Indexes to optimize execution time.
• Developed BTEQ, FastLoad and MultiLoad scripts in Teradata. Wrote UNIX Shell scripts.
• Developed the automated and scheduled load processes using Autosys scheduler.
• Responsible for Unit testing and Integration testing of mappings and workflows. Extensively used Informatica Power Center Data Validation tool to unit test the ETL mappings.
• Assisted QA team in testing the ETL process in Integration environment.
• Worked on production tickets logged in JIRA to resolve the issues in a timely manner.
• Populated and updated data dictionary, standardized naming convention. Delivered ETL and Data warehouse technical design documentation.

ENVIRONMENT: Informatica Power Center 9.5.1, Informatica Data Quality IDQ 9.x, OBIEE, Teradata 14, Oracle 11g, PL/SQL, T-SQL, Toad, Erwin, SOAP UI, Teradata SQL Assistant, JIRA, Unix, Win

Confidential, Cranston, RI

Sr. Informatica Developer

Responsibilities:

• Analyzed the business requirements and framing the business logic for the ETL process.
• Designed and Developed complex mappings, reusable Transformations for ETL using Informatica Power Center.
• Created complex SCD type 1&type 2 mappings using dynamic lookup, Joiner, Router, Union, Expression and Update Transformations.
• Performed data manipulations using various Informatica Transformations like Aggregate, Filter, Update Strategy, and Sequence Generator etc.
• Extensively worked on Power Center Designer, Workflow Manager.
• Developed Transformation logic using Informatica.
• Used concept of staged mapping in order to perform asynchronous Web Services request and response as part of Informatica Mappings. 
• Created profiles to analyze the structure of source data. Created and applied rules in profiles
• Extensively used Change data capture concept in Informatica as well as in the Oracle to capture the changes to the data mart. Change data capture enabled us to reduce the time taken to load the data into the data mart by allowing only the changed data.
• Worked on Dimension and Fact tables, developed mappings and loaded data into the data warehouse.
• Used Informatica Data Quality (IDQ) for data quality, integration and profiling.
• Extensively worked on Address validator transformation in Informatica IDQ to parse the partial address and populated the full address in the target table
• Used Address validator transformation in IDQ and passed the partial address and populated the full address in the target table.
• Created profiles to analyze the structure of source data. Created and applied rules in profiles
• Created Informatica parameter files and User Defined Functions for handling special characters.
• Written SQL overrides in source Qualifier according to business requirements.
• Conversant in WSDL requests and responses for data manipulation in Oracle on Demand CRM system.
• Implemented variables and parameters in the mappings.
• Created workflows and worklets for designed mappings.
• Involved writing BTEQ scripts for validation & testing of the sessions, data integrity between source and target databases and for report generation
• Coding using BTEQ SQL of TERADATA, write UNIX scripts to validate, format and execute the • SQL's on UNIX environment.
• Generated UNIX shell scripts for automating daily load processes.
• Scheduled and unscheduled workflows and used UNIX command tasks to automate the entire process of fetching the source file from a different path and FTP it onto the server.
• Generated completion messages and status reports using workflow manager.
• Involved in writing ETL specifications and unit test plans for the mappings.
• Performed Developer testing, Functional testing, Unit testing for the Informatica mappings. Extensively used Informatica Data Validation tool to build and test unit test cases.
• Redesigned some of the mappings in the system to meet new functionality.
• Used workflow Monitor to monitor the performance of the Jobs.
• Extensively worked in the performance tuning of the ETL process at mapping and transformation level.
• Migrated the mappings to the testing and production environment.

ENVIRONMENT: Informatica Power Center 9.1/9.5, IDQ 9.x,DB2, UNIX, Oracle 11g, PL/SQL, TeraData12, SQL Assistant 12.0 ,Korn Shell Script, Tivoli Workload Scheduler 8.4, Cognos, TOAD 9.7.2.

Confidential, Detroit, MI

Informatica Developer

Responsibilities:

• Participated in the design, development and deployment of reporting solutions.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Developed complex Initial/Incremental Informatica Objects (Workflows / Sessions, Mappings/mapplets with various transformations.
• Worked on Agile technology.
• Experienced with Informatica PowerExchange for Loading/Retrieving data from mainframe systems.
• Developed Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Developed complex mappings in Informatica to load the data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Very strong knowledge of Informatica Data Quality transformations like Address validator, Parser, Labeler, Match, Exception, Association, Standardizer and other significant transformations.
• Involved in massive data profiling using IDQ (Analyst Tool) prior to data staging.
• Designed Mappings using B2B Data Transformation Studio.
• Parameterized the mappings and increased the re-usability.
• Used Informatica power center for extraction, transformation and loading data from heterogeneous source systems
• Extensively created mapping/Mapplets, reusable transformations using all the transformations like Joiner, lookup, filter, expression, stored procedure, aggregator, update strategy, worklets etc
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.
• Designed the Physical Layer with Aliases, views and followed all Industry standards.
• Designed BMM Layer and presentation layer according to the Business requirements.
• Configured the OBIEE Repository (RPD) and Implemented Security (Object Level and Data Level Security in the OBIEE Repository and Answers) using Repository Variables, Session Variables.
• Developed many Dashboards with different views (Pivot Table, Chart, Tabular and View Selector), dynamic dashboard prompts and guided navigation links
• Migration of Repository, OBIEE web cat and Informatica mapping across the environment.
• Implemented and configured Actions on development, Test, Production and UAT assigned users are groups and also masked the data and restricted users.

ENVIRONMENT: Oracle Business Intelligence 11.1.1.6/11.1.1.7 , BI Publisher, Oracle PL/SQL,Informatica 9.1/9.5,Toad, Windows XP, Oracle 11g