SUMMARY

• Total 7+ years of IT experience in Analysis, Design, Development, Implementation, Testing and support of Data Warehousing and Data Integration Solutions using Informatica PowerCenter 9.6.1/9.5.1/8.6, Oracle.
• Experience in ETL (Extraction, Transformation and Loading) of data from various sources into EDW, ODS and Data marts using Data Integration Tool Informatica, 9.x/8.x, Oracle in Banking, Insurance, Retail, Telecom and Health care Domains.
• Monitoring and Developing solutions of exiting Batch jobsin Control - M.
• Updation of Calanders and User daily according to Scheduling requirements.
• Experienced in Data warehouse development, working with data migration,Data conversion and Extraction/Transformation/Load using Informatica PowerCenter.
• Experience in Performance Tuning of Database queries, Running on Voluminous Data.
• Tuning Informatica Mappings for performance by finding bottlenecks and enhancing performance.
• Worked on Relational and Dimensional Data Modeling.
• Understanding of ETL design process and principal, development and maintenance and Repository configuration using Mapping Designer, Repository manager, Sessions, Worklets, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Involved working on the transformations like Source Qualifier, Filter, Joiner, Aggregator, Expression and Lookup.
• Using standard practices in Data warehousing: Star Schema/Snowflake Schema, Fact and Dimensions tables and Slowly changing Dimensions(SCD1,SCD2,3).
• Solid understanding of OLAP (Online Analytical Processing) concepts.
• Worked in Software Development Life Cycle (SDLC) like Agile and Waterfall methodologies.
• Experience in the Implementation of full lifecycle in Enterprise Data warehouse, Operational Data Store (ODS) and Business Data Marts with Dimensional modeling techniques.
• Analysed the backend capabilities and Implemented Push down optimization for Performance gain in Informatica.
• Extensively worked in creating Unix shell scripts and automation of ETL project, Monitoring and Scheduling of Jobs using UNIX Shell Script.
• Experience in documenting High Level Design (HLD), Low level Design (LLD), STM's, Unit test plan, Unit test cases and Deployment documents.
• Hands on experience in the reconciliation process and checking integrity (IC ) of Datawarehouse.
• Worked on Databases like Oracle, SQL Server, Netezza and Worked on integrating data from Flat files like fixed width /delimited, XML files.
• Supported on Unit testing, Functional testing and User Acceptance testing on UNIX and Windows Environment and worked on Solving the incidents/Defects and Providing hotfixes, writing and debugging to find out the problems in mappings, troubleshooting and rectifying ETL bugs.
• Participated and understood business requirements, discussed with Business Analyst to gather and analyze the requirements and to prepare business rules.
• Collaborated with Decision Management system team for creation of business rules to be deployed on IBM ODM
• Worked with PMCMD to interact with Informatica Server from command line and execution using Unix scripts for quick automation.
• Proficient Confidential using Excel for Data Analysis and using Advanced excel functionalities like Pivot,Vlookup and More.
• Analysis of PL/Sql Procedures and implementing the functionality in Informatica.

TECHNICAL SKILLS

Data Warehouse Tools: Informatica PowerCenter

Operating Systems: Windows XP/Vista/Windows 10/08/07, Unix, Linux,Redhat

Databases: Oracle 11g/10g/9i, MySql, SQL Server, Netezza

Dimensional: Data ModelingDimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling

Database Tools: Oracle SQL Developer, SQL Plus, Toad, Aginity Workbench, MySql Xampp

Languages: SQL,Unix Shell Scripting, PL/SQL, XML

PROFESSIONAL EXPERIENCE

Confidential

Data Integration Programmer

Responsibilities:

• Production Support and providing the solutions to the errors in ETL jobs. ETL Process consist of Building dynamic parameter files, Landing, ODS layer and then Integration layer in such a way dat identified the Data Model with respect to subject areas.
• Analyzing Sales data and creating Informatica mappings for generation of Hourly, Daily, Weekly, Monthly and Yearly Reports.
• Worked on establishing ETL Design in such a way dat each ETL Jobs identified to data model (subject area).
• Responsible to build System design, ETL data flow diagram, Building of Data Mapping Sheet and Run Book.
• Monitor loads and troubleshoot any issues dat arise.
• Build Dynamic parameters ETL Process in Importing the data from flat files
• Build Address transformation to validate the address.
• Processing financial data for timely profit calculation.
• Decision support system to be used for Sales and marketing.
• Build in depth test Cases and automate the test cases by writing the Integrity checks.
• Worked on data profiling and automate the process of test cases
• Data mapping sheets for subject areas like Revenue generation, Sales, Cost centre analysis, Finance, Prior Authorization for new dealers.
• Building Views for validating data mapping sheets
• Building views in the integration layer.
• Building validation queries for data validation of source system (Oracle 11g) and Created Validation mappings.
• Writing Functions/procedures for data validation
• Writing shell scripts for pre and post command sessions
• Setting up reconciliation ETL design for staging and Integration layer
• Setting up Event ID and Batch ID for the ETL process.

Environment: Informatica Power Center 9.6.1, Control M, Oracle 11g, ALM, XML/XSD, Flat file Sources, UNIX, SharePoint

Confidential, Pittsburgh, PA

ETL/Informatica Developer

Responsibilities:

• Confidential operations include a regional banking franchise operating primarily in nineteen states and the District of Columbia with more than 2,600 branches. This project is developed for maintaining a catalogue of all the products dat are offered online to the customers. It involved extraction of data from multiple Source systems and loading them through an ETL process in to staging tables and then in to Target tables.
• Interact with business analysts, Analyzed, inspected and translate business requirements into technical specifications.
• Participated in system analysis and data modeling, which included creating tables, views, triggers, functions, indexes, functions, procedures, cursors.
• Involved Creating Fact and Dimension tables using Star schema.
• Extensively involved working on the transformations like Source Qualifier, Filter, Joiner, Aggregator, Expression and Lookup.
• Created session logs, workflow logs and debugger to debug the session and analyze the problem associated with the mappings and generic scripts.
• Design and developed complex Informatica mappings including SCD Type 2 (Slow Changing Dimension Type 2).
• Extensively worked in Workflow Manager, Workflow Monitor and Worklet Designer to create, edit and run workflows.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.
• Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.

Environment: Informatica PowerCenter v 9.6, Oracle 11g, Flat files (fixed width/delimited, XML, SharePoint, JIRA, Quality Center.

Confidential, Chicago, IL

ETL/Informatica Developer

Responsibilities:

• Confidential is one of the leading companies in the nation for the auto insurance with more than 10 million policyholders. Its companies has consistently received high ratings for financial strength and claims paying ability from various independent rating agencies. The Insurance DW project was developed in an effort to streamline the entire process of Insurance and to keep track of various financials on a daily, weekly, monthly basis. Claims, Premium, Loss and Contracts were some of the modules to deal with.
• Responsibilities:
• Worked with Business Analysts and DBA for requirements gathering,business analysis and designing of the datawarehouse.
• Extensively worked on the transformations like Source Qualifier, Filter,Router, Joiner, Aggregator, Expression and Lookup.
• Worked on Informatica PowerCenter tool - Source Analyzer, Target Designer, Mapping Designer, Mapplets Designer and Transformation Developer.
• Created Mapplets and used them in different Mappings.
• Created Workflows and Sessions to load data from the SQL Server, Oracle, flat file, and XML file sources dat exist on servers located Confidential various locations.
• Created and monitored workflows and task using Informatica PowerCenter Workflow Manager.
• Responsible for creating business solutions for Incremental and full loads.
• Created different parameter files and changed Session parameters, mapping parameters, and variables Confidential run time.
• Created high-level design document for extracting data from complex relational database tables, data conversions, transformation and loading into specific formats.
• Created schema objects like indexes,views and sequences.
• Developed standard and re-usable mappings and Mapplets using various transformations like Expression, Lookups, Joiner, Filter, Source Qualifier, Sorter, Update strategy and Sequence generator.

Environment: Informatica PowerCenter 9.5.1, Oracle 11g,fixed width/delimited f, Erwin, Putlat files, XML Source,Putty, WinScp, Linux, XML, Sharepoint, Quality Center.

Confidential, Minneapolis,MN

ETL/Informatica Developer

Responsibilities:

• Confidential Group Is an innovative leader in Health and Well-being industry. United is dedicated to making business decisions dat reflect its commitment to improving the health and well-being of its members, associates and the communities. During this project, worked closely with ETL team,customers,business analysts and other colleagues in the IT department to analyze operational data sources,determine data availability,define the data warehouse schema and develop ETL processes for the creation,maintenance,administration and overall support of the data warehouse.
• Worked with Business Analysts for requirements gathering, implementing designs process, development and preparing business rules.
• Worked in Software Development Life Cycle (SDLC) like in Agile Scrum methodologies.
• Actively performed in the meeting and providing comments for user story review meeting in Agile Scrum environment.
• Created Complex Mappings to load data using transformations like Source Qualifier, Expression, Aggregator, Dynamic Lookup, Connected and unconnected lookups, Joiner, Sorter, Filter, Stored Procedures, Sequence, Router and Update Strategy.
• Created Mappings using parameters, used Session parameters, Mapping variable/parameters and created Parameter files and runs of workflows based on changing variable values.
• Worked on complex mapping for the performance tuning to reduce the total ETL process time.
• Developed ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, Flat Files and SQL server, and loaded into Oracle.
• Developed Informatica Workflows and sessions connected with the mappings using Workflow Manager. Implemented Slowly Changing Dimensions (SCD Type 1 & 2) in Mappings.
• Hands on experience using query tools like SQL Developer, PLSQL developer, Teradata SQL.
• Involved in creating new table structures and modifying existing tables discussing with Data Modeler.
• Experience in writing documentation like Micro documents from Macro documents, High level and low level design, analyzing Source to Target Mapping (STM’s), Test cases and Code migration report.
• Developed Mapplets, Source and Target definitions, mappings, Reusable Transformations, using Informatica PowerCenter 9.6.1
• Update the tables as per the requirements by generating queries using SQL to check the data consistency in the table.
• Checked Sessions and error logs to troubleshoot problems and also used debugger.
• Created Unix Shell Scripts to automate pre-session and post-session processes.
• Created shortcuts for reusable transformation, source/target definitions, mapplets in Shared folder.

Environment: Informatica PowerCenter 9.1/9.5, Oracle 10g, Power mart, Pl/SQL, Flat files (fixed width/delimited),, Putty, WinScp, Linux, XML, Sharepoint, Quality Center.

Confidential, Ralegh, NC

Informatica Developer

Responsibilities:

• Enterprise Data warehouse for Confidential & Confidential . This data warehouse is developed to halp the top executives make decisions about the products (Network Bandwidth) and to also analyze various metrics and understand the performance of the business. Data in EDW is consumed by different systems like Business Intelligence reporting using Business Object, Decision support Systems, Executive Information, Demand Planning, Automated Underwriting systems.
• Interacted with business analysts and translate business requirements into technical specifications.
• Participated in system analysis and data modeling, which included creating tables, views, triggers, functions, indexes, functions, procedures, cursors.
• Using Informatica designer, developed mappings which populated the data into the target.
• Extensively worked Creating Fact and Dimension tables using Star schema.
• Created session logs, workflow logs and debugger to debug the session and analyze the problem associated with the mappings and generic scripts.
• Designed and developed complex Informatica mappings including Slow Changing Dimension Type 1,2.
• Extensively worked in Workflow Manager, Workflow Monitor and Worklet Designer to create, edit and run workflows.
• Developed UNIX Shell scripts to automate repetitive database processes and maintained shell scripts for data conversion.

Environment: Informatica PowerCenter v 8.6/9.1, SQL server 08, Oracle 10g/9i, PL/SQL, SAP BO, SSRS, Windows NT, Flat files (fixed width/delimited), MS-Excel, UNIX shell scripting, Putty, WinScp.

Confidential, Plano,TX

Informatica Developer

Responsibilities:

• This project was initiated to deliver customer-centered service across the ecommerce enterprise. While enhancing the online and mobile shopping experience, this project also aimed Confidential creating better in Store solutions ranging from POS to Inventory to Datawarehouse management, involved in continuous Mobile application enhancement project for easy access and user friendly navigation to the site, focused on Retail management
• Worked closely with project managers, business analysts, DBA’s to achieve business and functional requirements.
• Extensively worked on the transformations like Source Qualifier, Filter, Joiner, Aggregator, Expression and Lookup.
• Worked on Informatica PowerCenter tool - Source Analyzer, Target Designer, Mapping Designer, Mapplets Designer and Transformation Developer.
• Assisted in the design and Maintenance of the Metadata environment.
• Created Workflows and Sessions to load data from the SQL Server, Oracle, flat file, and XML file sources dat exist on servers located Confidential various locations.
• Extensively used Source Qualifier Transformation to filter data Confidential Source level
• Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Created and monitored workflows and task using Informatica PowerCenter Workflow Manager.
• Responsible for creating business solutions for Incremental and full loads.
• Created different parameter files and changed Session parameters, mapping parameters, and variables Confidential run time.
• Created high-level design document for extracting data from complex relational database tables, data conversions, transformation and loading into specific formats.
• Developed standard and re-usable mappings and Mapplets using various transformations like Expression, Lookups, Joiner, Filter, Source Qualifier, Sorter, Update strategy and Sequence generator.
• Performed unit testing, Integration testing and Functional testing of the mappings.

Environment: Informatica PowerCenter v 8.6, SQL, DB2, Oracle 9i, Windows NT, UNIX (AIX 5.2), Flat files (delimited), UNIX Shell Scripting, TOAD, Windows XP.