SUMMARY

• Senior Certified Informatica Consultant having over 8 years of Experience in dealing Data Warehousing projects using Informatica Powercenter and ETL Techniques.
• Expertise in gathering Business Requirement Analysis, Designing, coding and testing.
• Expertise with Informatica PowerCenter (9x,8x,7x) and Strong experience in performing ETL using Informatica PowerCenter Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Experience in Informatica B2B Data Transformation and its feature like Data Transformation Studio, Data Transformation Accelerator, Data Format Transformation Libraries.
• Used B2B DT extracted data from all files, Document and message - based data, including Microsoft Word and Excel Document.
• Experienced with Data Exchange internally and securely and applied the key features like Advanced data transformation, Business Activity Monitoring, Self-service partner portal, Flexible partner Management and Pre-packaged Industry Format Standards.
• Experience with design and implementation of Informatica (IDQ v9.1/8.6.1), Data Quality applications like Analysis, data cleansing, data matching, data conversion, exception handling, and reporting.
• Experience in Informatica MDM and utilise its solutions like data Integration, data quality and business process management (BPM).
• Experience in Informatica Data Quality and expert in designing, testing, deploying, and documenting the data quality procedures and their outputs.
• Experience on Teradata System Architecture and understanding Indexes in Teradata.
• Experienced with Teradata Utility like BTEQ, Fast Load, Multi Load, Tpump to load data from various source systems to Teradata.
• Expertise in OLTP, OLAP, System Study, Analysis and E-R Modeling. Developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data Modeling.
• 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.
• Designed complex Mappings and have expertise in performance tuning and slowly-changing Dimension Tables and Fact tables.
• Experience in PL/SQL Programming and in writing Stored Procedures, Functions etc.·
• Created technical specification documents like system design and detail design documents for the development.
• Experienced in preparing Technical design document, mapping documents, data definition documents and Detail design document for the Source/Target mapping.
• Understanding & working knowledge of Informatica CDC (Change Data Capture).
• Experienced in integrating from various data sources like Flat Files, XML files, databases (Oracle, SQL Server, and MS Access) and handling large volumes of data.
• Experienced with Oracle Golden Gate.
• Automated Informatica jobs, using Scheduler, Autosys, and UNIX scripts.
• Extensive experience in the ETL testing, manual testing and Business Intelligence Applications.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6/9.1/8.6 IDQ 9.1 8.6.1, SQL*Loader

Database: Oracle 11g/10g/9i, IBM DB2, Teradata, SQL Server 2008R2/2012, Netezza, Vertica

Scripting Languages: Shell, Perl

Version Control Tools: CVS, VSS, SVN

Defect Management Tools: JIRA, HPQC

Scheduling Tools: Control-M, Autosys

Data Modeling: Erwin, ER Studio

Operating Systems: Windows, Unix, Linux, Sun-Solaris, HP-UX

Reporting Tools: Cognos, Tableau

Web Technology: HTML,XML

PROFESSIONAL EXPERIENCE

Confidential, Buffalo, NY

Senior ETL Informatica Developer

Responsibilities:

• Perform daily support functions (Monitoring Service Desk Queue, Informatica Workflow Monitor)
• Work on all production issue tickets on priority basis.
• Based on the functional requirements modify the workbook and technical design specification documents.
• Making the necessary code changes to mapping, session and workflows based on business requirements.
• Preparing the test cases and do thorough testing based on business requirements.
• Prepare the promote sheet, CMR and get approval from the board.
• Responsible for code migration from DEV - QA - Prod environments by coordinating with IT Operations.
• Conduct technical meeting with business users to know more about the problem.
• Involved in peer review of the code changes done by the team members.
• Involved in Application turnover processes with all the applications that goes to production.
• Responsible in building Informatica mappings by using various transformations like Source Qualifier, Expression, Aggregator, Rank, Joiner, Lookup, Update Strategy, Java transformation and Stored procedure transformations based on the requirement from the end users.
• Used error handling strategy for trapping errors by using the error function in the mapping level and sending errors to an error table.
• Modified Mapplet and reusable transformations using Mapplet Designer, Transformation developer for the Standardization of data as per the business requirements.
• Responsible for extracting data from heterogeneous sources like Flat Files, Oracle, DB2 and loading the same in to Oracle and Flat Files.
• Extensively used TOAD to test, debug SQL and PL/SL scripts, packages, procedures, triggers and functions.
• Understanding of the business requirements and enhancing the existing data warehouse architecture design for a better performance.
• Designed Mappings using B2B Data Transformation Studio and PowerCenter with the help of UDT (Unstructured Data Transformation).
• Used Informatica Designer to Create, Load, Update mappings using different transformations to move data to different data marts in Data warehouse.
• Used B2B DT extracted data from all files, Document and message-based data, including Microsoft Word and Excel Document.
• Worked on Informatica B2B Data Exchange MFT tool to exchange the files transfer from one vendor to other vendor with SSL authentication & PGP encryption & decryption process.
• Successfully Loaded data into different targets from various source systems like Oracle data base, Flat files, ODS, SQL Server etc. into Staging tables and then into Target Database.
• Created users and user groups with appropriate privileges and permissions, folders and folder permissions in Repository Manager.
• Used Debugger in Mappings to debug the Complex mappings and fixed the Errors.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project development to testing and then to Production environment.
• Prepared and used test data cases to verify accuracy and completeness of ETL process.
• Actively involved in Production Support and helped other team members.

Environment: Informatica PowerCenter 9.6.1, Informatica Power Exchange 9.1, SQL SERVER 2008, Oracle 10g, SQL Assist, Toad, Unix Shell Scripts, B2B DXT/DT v9.1

Confidential, Plantation, Florida

Senior ETL Informatica developer

Responsibilities:

• Interacted with various business people and gathered the business requirements and translated them into technical specifications.
• Designed Mappings using B2B Data Transformation Studio.
• Used Advanced Data Transformation a key feature in the Data Exchange to integrate the Copybook files which are similar to Flat files from MOBIS Main Frames.
• Develop FASTEXPORT scripts to load data from one server to another.
• Develop FASTLOAD, MLOAD scripts to load high volumes of data from flat file to tables in Teradata.
• Developed Store procedure to load the data from source tables and populate table in EDW.
• Used Teradata SQL Assistant to test the performance of queries.
• Expertise in using data quality tool IDQ to profile the project source data, define or confirm the definition of the metadata, cleanse and accuracy check the project data, check for duplicate or redundant records, and provide information on how to proceed with ETL processes.
• Extracted data from various sources like Oracle and flat files and loaded into the target Oracle database.
• Created mapping using various transformations like Joiner, Filter, Aggregator, Lookup, Stored Procedures, Router, Sorter, Rank, Expression and Normalizer.
• Extensive performance tuning by determining bottlenecks at various points like targets, sources, mappings and sessions.
• Created and Executed workflows and Worklets using Workflow Manager to load the data into the Target Database.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Used BTEQ and SQL Assistant front-end tools to issue SQL commands matching the business
• Developed Mload scripts and shell scripts to move data from source systems to staging and from staging to Data warehouse in batch processing mode
• Extensively participated in System/Integration/Performance testing.
• We master the data and Once data is mastered, it will be vended to the downstream applications through a special internal application called Golden Gate.
• Analysed the source fields and wrote SQL queries for field to field validation by referring source to target mapping document.
• Developed test cases for business and user requirements to identify claims for Institutional, Professional, Subscriber paid, etc. and wrote SQL queries to validate the data on the source and target databases according to source to target mapping document.

Environment: Informatica PowerCenter 8.6, Informatica Power Exchange 8.6, IDQ 9.1, Teradata, Oracle 11g/9i, DB2, MS Access, TOAD 9.0, SQL, UNIX., Oracle Golden Gate

Confidential, Dallas, TX

ETL Informatica Developer

Responsibilities:

• Responsible for gathering suit of business requirements, Prepare source to Target Mapping specifications and Transformation rules.
• Extracted the data from various data source systems into the Landing Zone area by creating the Informatica mappings using the Teradata fast Loader Connections.
• Involved in System study, analyse the requirements by meeting the client and designing the system.
• Developed Mappings/ Reusable Objects/ Transformation/Mapplets by using mapping designer, transformation developer and Mapplet designer in Informatica PowerCenter.
• Worked on utilities like FLOAD, MLOAD, FEXP of Teradata and created batch jobs using BTEQ.
• Worked on Teradata SQL Assistant querying the source/target tables to validate the BTEQ scripts.
• Designed and developed complex Aggregate, Join, Lookup Transformation rules (Business rules) to generate consolidated (Fact/ Summary) data identified by dimensions using Informatica ETL tool
• Created Connected and unconnected Lookup transformation to look up the data from the source and target tables, used Update Strategy transformation.
• Workflow Manager used for creating and maintaining the sessions, Monitor, edit, schedule, copy, abort, and delete session.
• Setting up Batches and Sessions to schedule the loads at required frequency using PowerCenter Workflow Manager, pmcmd and also using scheduling tools.
• Involved in Performance Tuning for sources, targets, mappings, sessions.
• Used Debugger to debug mappings by creating breakpoints to gain troubleshooting information about data and error conditions.
• Involved in migrating folders from Development to Testing and from Testing to Production Environments, creating the connect strings and synchronizing the connect strings and connection objects in Dev, Test and Prod environments.
• Involved in end to end testing and created Test cases for those mappings.
• Worked with testing team and helped in Testing at Integration Level.
• Extensively used various tasks like Session task, Event Wait Task, Decision task, Email task, Command task.
• Actively Participated in Team meetings and discussions to propose the solutions to the Problems.

Environment: Informatica Power Center 7.1, Oracle 9i, MS SQL SERVER, Teradata 13.0, SQL, PL/SQL, Erwin, SQL Loader, UNIX Shell Script, Win 2000/NT.

Confidential

Informatica Developer

Responsibilities:

• Involved in business analysis and technical design sessions with 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 mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Update strategy and Sequence generator.
• Wrote complex SQL override scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy.
• Responsible for creating workflows. Created Session, Event, Command, and Control Decision and Email tasks in Workflow Manager
• Prepared user requirement documentation for mapping and additional functionality.
• Extensively used ETL to load data using Power Center from source systems like Flat Files into staging tables and load the data into the target database Oracle. Analysed the existing systems and made a Feasibility Study.
• Analysed current system and programs and prepared gap analysis documents
• Experience in Performance tuning & Optimization of SQL statements sql trace
• Involved in Unit, System integration, User Acceptance Testing of Mapping.
• Supported the process steps under development, test and production environment
• Participated in the technical design along with customer team, preparing design specifications, functional specifications and other documents.
• Used Transformation Developer to create the reusable Transformations.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Wrote SQL Scripts for the reporting requirements and to meet the Unit Test Requirements.
• Validated the Mappings, Sessions & Workflows, Generated & Loaded the Data into the target database.

Environment: Informatica Power Center 6.2, SQL Server 2000/2005, Teradata, Oracle 8i, Linux, TOAD, SQL, PL/SQL, SDLC, Selenium IDE.

Confidential

Informatica Developer

Responsibilities:

• Built a central Database where data comes from different sources like oracle, SQL server and flat files.
• Actively involved as an Analyst for preparing design documents and interacted with the data modeling team to understand the data model and design the ETL logic.
• Report to the Program Manager on the progress in a timely manner.
• Experience in source systems analysis and data extraction from various sources like Flat files, Oracle 10g/9i/8i, IBM DB2 UDB, XML files
• Worked on Informatica Power Center tool - Source Analyser, Target designer, Mapping & Mapplet Designer and Transformation Designer.
• Resolved issues that cause the production jobs to fail by analyzing the ETL code and log files created by the failed jobs on the Informatica server.
• Used Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• Worked on slowly changing dimension tables data.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, Stored Procedure, dynamic Lookup and Router transformations for populating target oracle tables in efficient manner
• Tuning Informatica Mappings and Sessions for optimum performance.
• Created mapping documents to outline data flow from sources to targets.
• 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.
• Actively involved in the functional requirements review with the development team and analysts.
• Attend daily and weekly meeting to review the code. Work closely with the business user.
• Delivered the needs of the reporting team in a timely manner.

Environment: Informatica Power Center 7.1, Oracle 9i, MS SQL SERVER, SQL, PL/SQL, Erwin, SQL Loader, UNIX Shell Script, Win 2000/NT.

Confidential

Intern Programmer

Responsibilities:

• Be a part of Internship program during final year project of Bachelor’s Degree.
• Involved in gathering requirements, analysis, design, testing of the project.
• Involved in preparation of the low level document.
• Writing SQL queries and executing them with respective to the business requirements.
• Experienced Performance tuning to run and execute complex queries.
• Experience KT (Knowledge Transfer) with the help of the senior team members.
• Learned new concept of Kimball methodologies to execute the DW (Data warehousing) projects
• Experienced in writing UNIX commands.
• Attend daily meeting and submitted the progress for each week to the project manager.
• Developed programming, database, testing and networking skills.
• Worked closely with the core team members like Developers, Team Leader and Project manager.
• Experienced Informatica Powercenter tool for the first time and learn the procedure to develop ETL mappings to transform the data according to the business requirements.
• Analysed the Specifications and identifying the source data needs to be moved to data warehouse.
• Involved in Database design, entity relationship modeling and dimensional modeling using Star schema.
• Worked with mappings using expressions, aggregators, filters, lookup, update strategy and stored procedures transformations.
• Created flexible mappings/sessions using parameters, variables and heavily using parameter files.
• This project is intended to load and extract Procurement, Order Management, and Accounting data from Oracle database.
• Create test cases for the above projects in providing error free solution.
• Worked with Agile method.

Environment: Informatica Powercenter, Oracle 9i, DB2, MSSQL Server 2005 PL/SQL, SQL*Plus, SQL*Loader, Toad, UNIX, Windows XP