PROFESSIONAL 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 principle, 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 pracatices in Datawarehousing: 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.
• 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 funtionalities 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 Modeling: Dimensional 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:

• Analyzing Sales data and creating informatica mappings for generation of Hourly,Daily, Weekely, Mothly and Yearly Reports.
• Worked on establishing ETL Design in such a way that 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 that 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 marketting.
• 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:

• 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:

• 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 that 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:

• 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.
• 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:

• 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:

• 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 that 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.