SUMMARY:

Around 7 years of overall IT exposure with system design, development, testing support and production support Data Warehousing which involves ETL, Teradata, Reporting and Data modeling experience. Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using Informatica Power Center 9.5 .

TECHNICAL SKILLS:

Data warehousing ETL tools: Informatica Powercenter 9.x and 8.x, Informatica MDM, Informatica Data Quality 9.1(IDQ), Microsoft SSIS, SSAS, SSRS

Data Modeling: Relational Data Modeling, Dimensional Data Modeling, Star Schema, Snow - Flake Modeling, Fact and Dimensions Tables

Databases: Oracle 11g/10g/9i, SQL Server 2014/2012/2008 , DB2, Teradata V12

Reporting Tools: Crystal Reports 8.x/10.x, Tableau Desktop, IBM-SPSS

Languages: SQL, PL/SQL, C++, SAS, R Studio

Web Technologies: ASP.NET, Jscript.NET, HTML, JavaScript

DB Tools: SQL*Plus, SQ oader, SQL*Forms, TOAD

Web Tools: ASP.NET, Jscript.NET, HTML, JavaScript

Schedulers/ Querying tools: Oracle SQL Developer, MS Visual Studio, SQL Server Management Studio

Operating Systems: Vista, Windows XP/2007/2010, Windows 95, 98, Unix

Others: MS Office, MS Project, MS Visio, MS One Note

PROFESSIONAL EXPERIENCE:

Confidential, Fremont, CA

ETL Informatica Developer

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Loading data to the staging tables following the Data Integrity rules of Interface Design Specifications.
• Used source external tables to load the data to the staging tables.
• Created mapping documents to outline data flow from sources to targets.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Developed and scheduled the Jobs using Autosys Scheduler.

Environment: Informatica PowerCenter 9.0.1, Flat files, Excel files, Oracle11g, Erwin, Autosys, UNIX

Confidential, Columbus, OH

Informatica/ ETL developer

Responsibilities:

• Interacted with Business Analysts to understand the requirements and the impact of the ETL on the business.
• Worked with data modelers in preparing logical and physical data models and adding/deleting necessary fields using Erwin.
• Extracted data from flat files and oracle database, applied business logic to load them in the central oracle database.
• Created reusable transformations and Mapplets and used them in mappings.
• Worked on different data sources such as Oracle, SQL Server, Flat files etc.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Created E - mail notifications tasks using post-session scripts.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Wrote SQL, PL/SQL, stored procedures & triggers, cursors for implementing business rules and transformations.
• Worked with BTEQ, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency
• Assessed functional issues by troubleshooting Informatica mappings, sessions, and workflows with UNIX shell scripts; Perl scripts; SQL queries in all stages of development and/or production.
• Developed a. Framework for extensible automated production support in PL/SQL.

Environment: Informatica Power Center 8.6.1, Oracle 10g/9i, SQLServer2005, Teradata 13, PL/SQL, XML, MS Access, Java, Sybase, Netezza, Web services, UNIX, Perl, UDB DB2 8.1, Toad, Business Objects.

Confidential, Bloomington, IL

ETL Informatica Developer

Responsibilities:

• Provided enterprise data warehousing solutions, including design and development of ETL processes, mappings and workflows using Informatica Power Center.
• Worked on Power Center tools like Source Analyzer, Mapping Designer, Mapplet Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Responsible for change/release management, production support and onshore and offshore coordination.
• Analyzed high level design specification to simple ETL coding and developed mappings as per standards.
• Implemented slowly changing type 2 dimensions maps to capture current and to maintain the complete historic data.
• Handled extraction of various types of source files such as Flat files, XML and standard source data of different transactions and load it in to staging area.
• Created mapplets and reusable transformations to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimension and Fact tables.
• Developed mapping parameters and variables to support SQL Override.
• Modified existing mappings as per new business requirements.
• Wrote UNIX Shell scripts required to extract, transform, load (ETL), clean, and move data and metadata so it can be loaded into a data warehouse, data mart, or data store.
• Worked extensively on Unit Testing the ETL mappings and preparing efficient unit test documentation for the developed code.
• Performed data validation testing by writing complex SQL Queries.
• Responsible for creating complete test cases, test plans, test data ensuring accurate coverage of requirements and business processes.
• Scheduled batch jobs in Control M. Coordinated with System Operators to Schedule the batch jobs in control M.
• Provided 24/7 production support.

Environment: Power Center 10.1/9.6, Flat files, MS Excel Files, MS Access,, Oracle 9i/10g, Erwin 7.3, Power Designer, PL/SQL, IBM DB2 8.0, Unix scripting, Windows NT, WinSQL, Control M, JCL

Confidential

Informatica Consultant

Responsibilities:

• Worked with Development Life Cycle teams
• Involved in designing SQL SSIS packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005/08R2 for further Data Analysis and Reporting by using multiple transformations, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks
• Wrote database triggers for automatic updating the tables and views
• Designed and developed forms and reports
• Involved in the creation of jobs using Informatica workflow manager to validate schedule run and monitor jobs using Workflow monitor.
• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental Informatica mappings and workflows to provide data for Data Warehouse.
• Created several mappings using various active and passive transformations like Source Qualifier, Lookup, Router, Aggregator, Filter, Joiner and Expression.
• Identified and fixed bottlenecks and tuned the complex Informatica mappings for better Performance.
• Developed Conceptual Business Model, Logical Data Model, Physical Data Model and Star - Schema design.
• Researched operational data store (ODS) and Legacy systems to find qualified source data.
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
• Extensively created BTEQ scripts to implement post load processes.
• Extensively created MLOAD, FLOAD and control files to load data in to EDW tables.
• Used Shell Scripting to automate the loading process.
• Used Pipeline Partitioning feature in the sessions to reduce the load time.
• Analyzed and Created Facts and Dimension Tables.
• Performed regular backup of data warehouse, backup of various production, development repositories including automating and scheduling processes. As part of optimization process, performed design changes in Informatica mappings, transformations, sessions.

Environment: Informatica Power Center 6.x, ETL, Oracle 8i, MS Access, SQL, PL/SQL, Windows NT.