SUMMARY

• 9+ years of extensive experience in Analysis, Design, Development, Implementation & maintenance of Informatica ETL, Informatica Data Quality (IDQ), Informatica MDM (Master Data Management), Informatica Cloud (IICS) and SSIS processes, OLTP & Data Warehouse systems, Business Intelligence and Enterprise Application Integration.
• 3 years’ experience in Informatica IDQ.
• Solid expertise in Data Extraction, Data Migration, Data Transformation and Data Loading using ETL process in Informatica Power Center 11.x/10.x/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 aConceptual modelusing Erwin based on requirements analysis
• Developed normalizedLogicalandPhysicaldatabase models to design OLTP system for insurance applications
• Created dimensional model for the reporting system by identifying required dimensions and facts usingErwin r8.0
• Strong working knowledge in design and development of ETL (Informatica) Process, Data (Dimensional and Relational) modeling for Data warehouse(EDW) and scheduling Oracle DAC.
• 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, Web services 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 developingOBIEE/Siebel Analytics Repository (.rpd) - three layers (Physical Layer, Business Model & Presentation Layer)
• Having strong knowledge on setting upLDAPforOBIEE. 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.
• Hands on in application development using with Java, Web Forms in JSP using JDBC.
• Knowledge of Eclipse tool for the development of java projects.
• Strong SQL, PL/SQL, T-SQL programming skills in Oracle 12c/11g/10g, SQL Server 2012/2008/2000, Teradata 14/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.
• Expertise in deploying and maintaining Informatica ETL code in Production environment.
• Experience in designing and developing B2B transformations for EDI and other formats using Informatica B2B Data Exchange.
• 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: Java, Oracle PL-SQL,Java Script.

Management: Agile/Water fall model.

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

BI Tools: Informatica Scheduler, Oracle DAC.

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,Webservice Hub(WSH),Tomcat.

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

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. Informatica/IDQ Developer

Responsibilities:

• Gathered requirements from Orachestra Network Team(EBX) Application and created ETL Mapping Specification Documentation.
• Involved in the ETL technical design discussions and created ETL high level technical design document
• Analyzed Salesforce and HRMS(Oracle) data and then extracted into Orachestra Network (EBX5) Application.
• Worked withInformaticaData 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.
• Developed IDQ mappings using various transformation like Labler, Standarization,Case Converter, Match and Address validation Transformation for third party vendors (KRONOS, Centarl Site Profile(CSP)).
• Developed complex Mappings using various transformations like expression, lookups, Update strategy, Sequence generator, Java, Rank, Aggregator, SQL, Xml, Stored procedure and Normalizer.
• Used concept of staged mapping (ODS) in order to load data into Flat File and CSV file and load into Orchestra Network Application (EBX5).
• Created Autosys jobs for Informatica and Orachestra Network Application (EBX5).
• Created complex SCD Type 1, Type 2 and Type 3 mappings using Dynamic Lookup, Joiner, Router, Union, Expression transformations.
• Created Tables, Views, Constrains, Synonyms, Sequences.
• Used the inner join, outer join, cross join while writing the complex 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.
• Responsible to migrate the mappings into UAT and Production environment.
• Reviewing the work and submitting the work to client with sufficient documentation

Environment: InformaticaPowerCenter9.6, Informatica Data Quality IDQ 9.6, Orchestra Network(EBX5), Oracle 11g, Autosys(CA Work load).

Confidential, Chicago, IL 

Sr. Informatica/IDQ 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.
• Developed IDQ mappings using various transformation like Labler, Standarization, Case Converter, Match and Address validation 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.
• Used concept of staged mapping in order to perform asynchronous Web Services request and response as part of Informatica Mappings using Web Service Hub.
• Worked on Batch Web Service Operation using Web service provider component. Worked on Real-time Web Service operation using Web service provider component
• 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: InformaticaPowerCenter9.6, Informatica Data Quality IDQ 9.6, Salesforce.com, Microsoft CRM, SOQL, SQL Server2012, Informatica Scheduler.

Confidential, Charlotte, NC

Senior Informatica/IDQ Developer

Responsibilities:

• 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 WebServicesHub.
• Developed mapping using Webservice Provider.
• Working with various sources such as Flatfiles, Relational, XML and Webservices as part of Informatica Mappings.
• Designed and developed dimensional model for Customer Data Warehouse in Teradata 14 and 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.
• Integrated Oracle DAC with Informatica Power Center and Configured DAC for Processing.
• Based on user requirements, DAC tasks and Informatica mappings were debugged and DAC parameters were changed to load multiple Subject Areas into Datawarehouse.
• Created profiles to analyze the structure of source data. Created and applied rules in profiles
• Created scorecards to visually represent data quality progress and to score the frequency of each values for columns.
• 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.
• Designed and implemented Informatica (IDQ v9.1), Data Quality applications for the business and technology users across the entire full development life cycle.
• 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.
• Created various rules in IDQ to satisfy the Completeness, Conformity, Integrity, Timeliness
• Cleansed, standardized, labeled and fix the data gaps in IDQ where it checks with reference tables to fix major business issues
• Identifiedissues,performancebottlenecks,andoptimizedtheBusiness IntelligenceDashboards andReports.
• Exposed IDQ mapping/mapplets as web service.
• Worked on enhancements for stored procedure and IDQ web services.
• Created scorecards to visually represent data quality progress and to score the frequency of each values 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 Server 2012 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 PowerCenter 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 PowerCenter 9.5.1, Informatica Data Quality IDQ 9.x, ORACLE DAC,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 PowerCenter.
• 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.
• 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.
• Actively participated in Scrum Meetings.
• Analyzed WSDL interactions with Oracle on Demand to push as well as pull data via Informatica.
• 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 PowerCenter 9.5, 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

Sr.Informatica Developer

Responsibilities:

• Collect business requirements from the users/Business Analysts & Converted the Business logic into functional specs with enhancements to get better performance of the system.
• Created and Worked technical requirements and detail level documents.
• Involve in the entire SDLC (Software Development Life Cycle) process that includes implementation, testing, deployment and maintenance.
• Analyzed different data sources like Oracle 11g, Flat files and XML files and understand the relationships by analyzing the OLTP Sources and loaded into Oracle data warehouse.
• Performed Oracle Data Warehousing design and development including data modeling and backend processes, specifically, Extraction, Transformation and Loading (ETL) of data into staging tables and then into Data Marts/Warehouses.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for the data to target warehouse using Informatica Workflow Manager.
• Developed Mapplets and Reusable Transformations to prevent redundancy of transformation usage and maintainability.
• Implemented and extensively worked on Slowly Changing Dimensions (SCDs both Type 1 & Type2).
• Configured the sessions using Workflow Manager to have multiple partitions on Source data and to improve performance.
• Used Informatica Debugger, session logs and Toad to resolve problems in a timely manner.
• Worked on performance tuning Informatica Mappings to identify and remove processing bottlenecks. Deployed and monitored Informatica mappings into production.
• Wrote PL/SQL Packages, Stored Procedures and Views in Oracle 11g.
• Coordinate and develop all documentation related to ETL design and development.

Environment: Informatica Power Center 9.1, Toad Data Modeler, Oracle 10g/11g, Toad, PL/SQL, Linux, UNIX Shell Scripting.

Confidential

Informatica Developer

Responsibilities:

• Responsible to meet with business stakeholders and other technical team members to Gather and analyze application requirements.
• Involved in development of Logical and Physical data models that capture current state Developed and tested all the Informatica Data mappings, sessions and workflows - involving several Tasks.
• Developed end-to-end ETL processes for Trade Management Data Mart Using Informatica.
• Worked on source analyzer, Target Designer, Mapping and Mapplet Designer, Workflow manager and Workflow Monitor.
• Created mappings for initial load in Power Center Designer using the transformations Expression, Router and Source Qualifier.
• Created complex mappings for full load into target in Power Center Designer using Sorter, Connected Lookup, Unconnected Lookup, Update Strategy, Router, Union etc.
• Created Mapplets to reuse all the set of transformations for all mappings.
• Responsibilities include creating the sessions and scheduling the sessions.
• Created various tasks to give various conditions in the workflows.
• Mappings, Mapplets and Sessions for data loads and data cleansing. Enhancing the existing mappings where changes are made to the existing mappings using Informatica Power center.
• Involving in extracting the data from Oracle and Flat files. Developed and implemented various enhancements to the application in the form of Production and new production rollouts.
• Worked on identifying facts, dimensions and various other concepts of dimensional modeling which are used for data warehousing projects.
• Extensively worked on confirmed Dimensions for the purpose of incremental loading of the target database.
• Worked on Fast Load, MultiLoad, Pump and Fast Export loading techniques through Informatica into Teradata.
• Performed Unit testing on the Informatica code by running in the debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for the optimum performance.
• Involved in fixing invalid Mappings, Testing of Informatica Sessions, Work lets and Workflows.
• Created parameters and variables for the reusable sessions.
• Analyzed the various bottlenecks at source, target, mapping and session level.
• Tuning of the mappings and SQL Scripts for a better performance.
• Designed the ETL processes using Informatica to load data from DB2, SQL Server and Flat files to the Target Database.
• Assign work and responsible for providing technical expertise for the design and execution of ETL projects to onshore and offshore developers.

Environment: Informatica 8.6.1, Teradata, Oracle 10g, PLSQL, DB2, XML, SQL* PLUS,MS Excel, UNIX(AIX), UNIX Shell

Confidential

Java Developer/Informatica Developer

Responsibilities:

• Involved in Requirement gathering anddesign document.
• DevelopedwebformsinJSPusingJDBCasthecode-behindlanguage and LINQ as theSQL data consumer.
• Developed accordion control with Data Listcontrols.
• Developed master pages.
• Developed JavaScript.
• Created mappings for initial load in Power Center Designer using the transformations Expression, Router and Source Qualifier.
• Created complex mappings for full load into target in Power Center Designer.
• Worked on identifying facts, dimensions and various other concepts of dimensional modeling which are used for data warehousing projects.
• Performed Unit testing on the Informatica code by running in the debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for the optimum performance.
• Involved in creation of stored procedures in Oracle 9.

Environment: Java 1.6,JDBC,JSP,MyEclipse Webservices Informatica 8.6,Oracle9.