SUMMARY:

• Over 8+ years of expertise in all phases of Data Warehousing and Business Intelligence Development life cycle including Design, Requirements gathering, Development, Data analysis and Testing.
• Created ETL mappings using Informatica PowerMart/PowerCenter to move information from multiple sources into a common target area such as Data Marts and Data Warehouse.
• Extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Informatica B2B Data Exchange, Designing and developing B2B transformations for EDI and other formats using Informatica B2B Data Transformer. Performed Developer testing, Functional testing, Unit testing for the Informatica mappings.
• Requirement Gathering and Data Analysis of all supporting systems. Designed Informatica mappings and data flows.
• Full Software Development Life Cycle (SDLC) experience including Analysis, Design and Review of Business and Software Requirement Specifications; Development and Testing as per the SDLC waterfall methodology.
• Excellent experience in implementing Web Service, WCF, REST service which communicate data in a advanced XML.
• Have RDBMS concepts experience in Oracle 11i/10g/9i/8i/7.x, SQL*Loader,Netezza
• Strong experience in complex PL/SQL packages, functions, cursors, triggers, views, materialized views, T - SQL, DTS.
• Extensive experience on Informatica power center 9.x/8.x versions to load the data from sources like Relational database, Flat Files, XML Files, COBOL Files, into Data Warehouse and Data Mart.
• Developed Complex mappings in Informatica from various transformations like Router, Filter, Expression, Aggregator, Joiner, Update Strategy using the Informatica Power Center and IDQ.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Teradata.
• Knowledge in Business Intelligence areas such as Data Integration, Data Masking, Physical data modeling in Teradata.
• Converted Oracle stored procedures to Netezza Equivalent.
• Extensively worked withNetezzadatabase to implement data cleanup, performance tuning techniques.
• Extensively used Aginity Netezza work bench to perform various DML, DDL...etc operations on Netezza database.
• Having knowledge on scheduling tools like UC4
• Extensively worked on SQL/PLSQL programming development and execution of Stored Procedures, Functions and Packages.
• Experience using Teradata BTEQ, FastLoad, MultiLoad, FastExport, and SQL Administraton
• Extensively worked on Relational Databases RDBMS like Oracle MS SQL Server, MySQL, Teradata, DB2, and Sybase. Also worked on various source files like delimited flat file, CSV file and XML file.
• Knowledge in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• Excellent knowledge on J2EE design patterns such as Singleton Design Pattern, Factory Design Pattern, Front Controller Design Pattern, N-Tier Architecture, MVC Architecture Performed data validation by Unit testing, integration testing and System Testing.
• Used SQL Server 2012 Integration Services (SSIS) transformations in the data flow of a package to aggregate, merge, distribute, and modify data.
• Expertise in upgrading from DTS to SSIS packages, Logging, SQL Mail, Auditing, Variables Deploying,resolving complex issues and Error Handling in SSIS.
• Excellent knowledge in ETL using SQLServer Integration Services 2008/2005 (SSIS), DTS, Bulk Insert.
• Experience in creating Jobs, Alerts, SQL Mail Agent and Scheduling DTS and SSIS Packages

TECHNICAL SKILLS:

Operating Systems: Windows 2008/2007/2005/ NT/XP, UNIX, MS-DOS, IBM S/3,MVS/ESA

ETL Tools: Informatica Power Center 9.6/8.6/8.5/8.1/7.1 (Workflow Manager, WorkflowMonitor, Warehouse Designer, Source Analyzer, Transformation developer,Mapplet Designer, Mapping Designer, Repository manager and Informatica server)

Databases: Oracle 11g/10g/9i/8i, DB2 v8.1, MS SQL Server 2008/2005, Netezza 6.x/7.x

Data Modeling: ERWIN 4.x and Concepts like Star Join Schema Modeling, Snowflake Modeling,FACT and Dimensions Tables, Physical and Logical Data Modeling.

Languages: SQL, PL/SQL, UNIX Shell scripts, C, C++, T-SQL,OBIEE.

Scheduling Tools: AUTOSYS

Development Tool: SQL *PLUS, TOAD, SQL Navigator.

Packages: MS Word, MS Excel, MS Project, MS Visio, MS PowerPoint

Web Tech: HTML/DHTML, JavaScript, JMS

GUI and Other: Oracle Designer, Reports, PLSQL, TOAD 8.x/7.x/6.x, SQL Loader, Erwin, CrystalReports, PVCS VM and PVCS Tracker, Pervasive Data Integrator.

PROFESSIONAL EXPERIENCE:

Confidential, charlotte, NC

ETL Informatica Developer

Responsibilities:

• Involved in gathering requirements from Business and converted them it into Technical documents.
• Extensively worked on Power Center Designer, Workflow Manager.
• Involved in extracting data from ERPs like JD ENTERPRISE 1 into EDW (Oracle) and developed Transformation logic using Informatica.
• Developed ETL technical specs, ETL execution plan, Test cases, Test scripts etc.
• Created ETL mappings and mapplets to extract data from ERPs like SAP, ENTERPRISE 1 (Oracle) and load into EDW (Oracle 10g).
• Queried target database using Teradata BTEQ Warehouse.
• Worked on Programming using PL/SQL, Stored Procedures, Functions, Packages, Database triggers for Oracle and SQL Server.
• Writing Teradata sql queries to join or any modifications in the table.
• Designed and developed table structures, stored procedures and functions to implement business rules.
• Extensively used Aginity Netezza work bench to perform various DML, DDL...etc operations on Netezza database.
• Extensively used Netezza Bulk reader and writer.
• Used Netezza groom to reclaim the space for tables and databases.
• Extensively managed the data skew all the Netezza database tables.
• Coordinated Daily scrum meetings, spring planning, spring review, and spring retrospective.
• Involved in various phases of SDLC from requirement gathering, analysis, design, development and testing to production.
• Worked on optimizing and tuning the Netezza SQLs to improve the performance of batch.
• Converted Oracle stored procedures to Netezza Equivalent.
• Experienced with transformations like Source Qualifier, Lookups, Expression Editor, Update Strategy, Filter, Router, Joiner and Sequence generator, SQL, java and etc.
• Used the Aggregator transformation to load the summarized data for Sales and Finance departments.
• Extensive experience using connected and unconnected lookups in several mapping using different caches like Static cache, Dynamic cache and Persistent cache.
• Designed, developed, implemented and maintained Informatica Power center and IDQ applications for matching and merging process.
• Redesigned Informatica mapping to handle multiple updates and deletes.
• Worked with Informatica Data Quality 8.6.1, data cleansing, data matching, data conversion, and reporting and monitoring capabilities of IDQ 8.6.1.
• Design and development of multi-layer Web Based information systems using Web Services.
• Excellent hands on experience in developing application using JAVA, J2EE (JSP, Servlets, EJB), Web Service, XML, XSLT, XSD and Jakarta Struts Framework (Struts 1.2)
• Utilized Informatica IDQ to complete initial data profiling and matching/removing duplicate data.
• Developed Error handling process incase Fact record gets submitted without corresponding dimension record.
• Converted typical PL/SQL code and DTS packages to Informatica.
• Created multiple sessions for all the existing mappings.
• Scheduled Informatica Workflows/Sessions to execute on a timely basis and create backup for source files.
• Contribute in estimations for the project, identify and log project milestones and periodically report to management throughout the life of the project.
• Used Cognos Reporting studio and frame work manger.
• Developed Cognos reports for Business users based on the requirements using with Cognos 8.3.
• Developed UNIX shell scripts to control the parameter files and copy dates from one parameter file to other.

Environment: Informatica 9.6, 8.6/8.1, IDQ 8.5, SAP R/3, SAP BWH, Cognos 8.3, Windows 2000 professional, Netezza6.x/7.x, SQL Server 2008, Oracle 9i/10g/11g, DTS Scripts, PL/SQL, Teradata.

Sr. ETL Informatica Developer

Responsibilities:

• Interacted with various business people in External Vendors side and gathered the business requirements and translated them into technical specifications.
• Documented business requirements, discussed issues to be resolved and translated user input into ETL design documents.
• Experienced working with team, lead developers, Interfaced with business analysts, coordinated with management and understand the end user experience
• Used Informatica Designer to create complex mappings using different transformations to move data to a Data Warehouse.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse using different transformations like Source Qualifier, Expression, Lookup, aggregate, Update Strategy and Joiner.
• Optimized the performance of the mappings by various tests on sources, targets and transformations.
• Experience with high volume datasets from various sources like Oracle and Netezza Relational Tables and xml targets.
• Usedinformaticapower center 9.0.1 to Extract, Transform and Load data into Netezza Data Warehouse from various sources likeOracle and flat files.
• Scheduling the sessions to extract, transform and load data in to warehouse database on Business requirements.
• Extracted (Sybase, Oracle, Flat files), Transformed and Loaded data into the staging area and Data Warehouse (Oracle) using Informatica mappings and complex transformations (Aggregator, Joiner, Lookup, Update Strategy, Source Qualifier, Filter, Router and Expression.
• Designed and developed complex Router, Sequence Generator, Ranking, Aggregator, Joiner, Lookup, Update Strategy transformations to load data identified by dimensions using Informatica ETL (Power Center) tool.
• Involved in creation and usage of stored procedures and Informatica power mart for data Loads in to data mart on a weekly basis.
• Read and understood the logic in COBOL in Mainframe environment and transformed that logic and coded into Informatica to load in target tables.
• Used Informatica Identity Resolution to search and match identical data coming from various sources.
• Exposure to all the steps of Software Development Life Cycle (SDLC). Also worked in development environment using Agile Methodology.
• Kicked off the Informatica workflows by running JCLs from Main frame environment.
• Generating shell scripts on UNIX side to move invoices to Accounts Payable in regular intervals.
• Involved in creating and managing repositories using Repository Manager.
• Take part in design and creation of Fact tables.
• Perform ETL processes using SSIS tool for SQL Server.
• Promoted Data Model from data sources and defined the dimensions, levels and measures in the model.
• Interacted with various departments, gathering their needs and developing reports based on user requirements.
• Experienced in generating various complex reports using COGNOS. Worked with Framework Manager to create BI metadata. Experienced in using Query studio, Report Studio in creating ad-hoc and complex reports.
• Extensively worked with UNIX Shell (Korn Shell) scripting to validate and verify the data that is loaded in the flat files.

Environment: Informatica Power Center 9.0.1,Oracle 11g,PL/SQL, Netezza,SQL Server, T-SQL,SQL Server DTS, Sybase12.5, db2, UNIX Shell Scripts.

ETL Informatica Developer

Responsibilities:

• Interacted with Business Users and Managers in gathering business requirements.
• Wrote Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews.
• Extensively used Greenplum Data warehouse and Postgres SQl.
• Prepared low-level technical design document and Reviewed Unit Test Plans & System Test cases.
• Worked with WhereScape Red to build ELT transformations for BDW load Process.
• Extensively worked on Power Center Client Tools like Power center Designer, WorkflowManager, and Workflow Monitor, IDQ
• Involved in various phases of SDLC from requirement gathering, analysis, design, development and testing to production.
• Working with various sources such as flat files, Relational, XML and Web services as part of Informatica Mappings.
• Created, scheduled, and monitored workflow sessions on the basis of run on demand, run on time, using Informatica PowerCenter Workflow Manager.
• Developed use case diagrams, class diagrams and sequence diagrams for identifying the behavior within system and dynamic modelling.
• Extensively worked on Power Center 8.6 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Extensively used various transformations like Source Qualifier, Joiner, Aggregation, Update Strategy, lookup, Rank and Filter.
• Developed Java classes conforming to J2EE design patterns such as Business Delegate, Service Locator, Session faade, Value Object and packaged with J2EE specification and deployed in BEA WebLogic 6.X application server.
• To schedule the Informatica workflows we used AutoSys.
• PerformedSmoke Testing, GUI-Testing, Functional-Testing, Backend Testing, System Integration Testing, Sanity Testing,and User Acceptance Testing (UAT)
• Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements.
• Extensively used Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor.
• Verified session logs to identify the errors occurred during the ETL execution.
• Worked with HPQC to fix the bugs that occur in Test and lower environments
• Worked with developers to fix bugs that occur on the staging environment through the use of Jira.
• Analyzed test results, identified issues and reported it to the developers and project manager through Jira.

Environment: Informatica Power Center 8.6, Green Plum, PostgresSQL, Putty, Autosys, WhereScape RED, Unix, SQL Server,Informatica, Data Warehousing, PL/SQL, Unix Shell Script, Business Objects, SQL Server, Performance Tuning, unix, Workflow, WorkFlow Manager, Autosys, DB2, Stored Procedures, EDW, ERWIN, Linux

Informatica Developer

Responsibilities:

• Prepared the technical design documents.
• Designed, developed, implemented and maintained Informatica Power center applications for matching and merging process.
• Preparing E-R diagrams to represent Mappings, Mapplet designs in design documents using Erwin and Visio.
• Creating Mappings, Mapplets, Sessions and Workflows in Informatica. For configuration of applications, writing shell scripts, stored procedures and other database objects based on the complexity of requirements.
• Creating unit test plans and executing unit test cases.
• Production support and support to testers for fixing defects.
• Release management activities for all PBI deliverables.

Technical Platform: Informatica PowerCenter8.1.6, DB2, XML, Oracle 10g and UNIX Shell Scripts.

Informatica Developer

Responsibilities:

• Analyzed existing system and developed business documentation on changes required.
• Fine-tuned mappings, transformations, various aggregations and workflow requirements to load the data warehouse as per business processes, data flow logic and technical requirements.
• Attended Subject Matter Experts (SME) meetings for requirements gathering, analysis and involved in preparation of functional specifications and technical specifications.
• Developed complex mappings and SCD type I, Type II and Type III mappings to load the data from various sources using different transformations like Source Qualifier, Lookup, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations.
• Assigned appropriate memory (Caches) requirements for Lookup, Aggregator and Rank caches for Optimum Performance.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata.
• Fine-tuned existing mappings for performance optimization.
• Involved in loading of data into Teradata from legacy systems and flat files using complex MultiLoad scripts and FastLoad scripts.
• Involved heavily in writing complex SQL queries to pull the required information from Database using Teradata SQL Assistance.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Extensively used Debugger Process in resolving issues in Development and Testing phases.
• Executed sessions for proper execution of mappings and performed event based scheduling
• Automated the jobs through scheduling using built in Informatica scheduler, which runs every day by maintaining the data validations
• Involved in the Unit testing, Integration testing and System testing.
• Extensively involved in testing the system from beginning to end to ensure the quality of the adjustments made to oblige the source system up-gradation.

Environment: Informatica 7.1, SAP R/3, Teradata, DB2, XML, Oracle 9i/10g/11g, MQ Series, and UNIX Shell Scripts.