SUMMARY

• 7+ years of experience in IT industry with expertise in Analysis, Design, Development, Implementation, Modeling, Testing, and Support for Data Warehouse applications.
• Expertise in working with Informatica Power Center 9.x/8.x/7.x (Designer, Repository manager, Work flow manager, workflow monitor).
• Well acquainted with Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer, Schedulers and Warehouse Designer.
• Well versed with Relational and Dimensional modeling techniques like Star Schema, OLAP, Fact and Dimensional Tables.
• Expertise in designing and developing complex Mappings using transformations like Source qualifier, Aggregator, Expression, Connected &Unconnected lookup, Filter, Joiner, Sequence generator, Sorter, Router, Normalizer and Update Strategy.
• Experience with high volume datasets from various sources like Oracle, Flat files, SQL Server and XML.
• Expertise in Tuning teh DW environment including Oracle SQL query tuning, Database tuning and in Informatica Power center to identify bottlenecks, tune and remove bottlenecks.
• Used Debugger to test teh data flow and Optimized teh Solution by using teh performance tuning methods in teh Oracle SQL queries like Indexing techniques, Hints, Partitioning and Parallel execution process.
• SCD Management including Type 1, 2, De - normalization, Cleansing, Conversion, Aggregation, and Performance Optimization.
• Design Source to Target maps, Code Migration, Version control, scheduling tools, Auditing, shared folders, data movement, naming in accordance with ETL Best Practices, Standards and Procedures.
• Thorough knowledge of teh Data Warehouse Development Life Cycle. Performed all dimensions of development including Extraction, Transformation, and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Power Center.
• Extensively worked with SQL Stored Procedures, Triggers and also involved in Query Optimization in Oracle and Teradata.
• Ability to write complex SQLs needed for ETL jobs and analyzing data, and is proficient and worked with databases like Oracle, SQL Server, DB2, MY SQL, Excel Sheets, Flat Files and XML files.
• Quick learner and adaptive to new and challenging technological environments.

TECHNICAL SKILLS

Data Warehousing/ETL: Informatica Power Center 9.x/8.x/7.x, Informatica Power Exchange 9.x/8.x

Data Modeling: Erwin 7.1.3, MS Visio

Databases: Oracle 11g/10g/9i MS SQL Server 2008R2/2008/2005 My SQL, DB2, MS-Access, SSIS

Programming: SQL, PL/SQL, MS SQL, UNIX Shell Scripting

Environment: Win 2008R2/2008/2003 Win 7/XP, UNIX.

Other tools & Utilities: SQL*Plus, Business Objects 6.5, SQL Navigator, Toad for Oracle, SQL tools, Autosys, Quest, MS-Office

PROFESSIONAL EXPERIENCE

Confidential, Dayton, OH

ETL / Informatica Developer

Responsibilities:

• Work closely with Team Lead, BA, DA and SAS developers for requirement gathering
• Participate in daily stand-up and weekly code review meetings with team members to discuss daily progress, plans, and technical issues
• Designed ETL Process using Informatica to load data from Flat Files, and Excel Files to target Oracle Data Warehouse database.
• Interacted with teh business community and database administrators to identify teh Business requirements and data realties.
• Designed and developed various mappings to extract data from sources such as Facets, Care Advance, SQL Server and load teh data into Teradata
• Wrote simple to complex queries in Teradata SQL Assistant and SQL Server in order to manipulate and design various tables
• Automated manual report scripts present in Teradata in Informatica by designing teh mapping according to teh business requirement
• Used persistent caches whenever data from workflows were to be retained.
• Used connected and unconnected lookups whenever appropriate, along with teh use of appropriate caches.
• Created tasks and workflows in teh Workflow Manager and monitored teh sessions in teh Workflow Monitor.
• Designed a mapping to see teh history and teh current status, diagnosis and various other attributes of teh Medicaid cases present in teh database for reporting purpose

Environment: Teradata 14.10, Power Center Client 9.6.1, SQL Server 2008 R2, Facets, Care Advance, Windows Server, Flat Files, CSV Files, Tortoise SVN

Confidential, Rancho Cordova, CA

ETL/Informatica Developer

Responsibilities:

• Worked with Business Analysts and Team Leads for requirements gathering.
• Used Informatica Power Center 9.5 for extraction, loading and transformation (ETL) of data.
• Designed and Developed ETL Mappings to extract data from SQL, Flat files, DB2 and Oracle to load teh data into teh target database.
• Developed new mappings with reusable transformations and mapplets based on business requirements.
• Extensively worked in teh performance tuning of programs, ETL procedures and processes.
• Error checking and testing of teh ETL procedures and programs using Informatica session log.
• Developed complex mappings for data integration based on business requirement and logic.
• Created Connected, Unconnected and dynamic Lookup transformation for better performance and increased teh cache file size based on teh size of lookup data.
• Worked on existing mappings to add teh new codes.
• Extensively used ETL Processes to load data from various source systems such as DB2, SQL Server, Flat Files and XML Files into target system by applying business logic on transformation mapping for inserting and updating records when loaded.
• Profoundly worked with testing team in identifying teh 'code defects' raised from SIT/UAT resources.
• Closely worked with teh database developer to ensure teh database changes are implemented as per teh requirement.
• Participating daily stand-up calls with team members to discuss daily progress, plans, and technical issues.
• Worked on data validation and error handling process within teh Informatica.
• Preparing internal Release Notes for weekly build.
• Worked on all Transformations.
• Analyzed and tuned queries on teh database dat will be executed from reporting system.
• Done Extensive testing and wrote Queries in SQL to ensure teh loading of teh data.

Environment: Informatica Power Center 9.5/9.1, Oracle 11g/10g, SQL Server 2008R2, Flat files, XML, UNIX.

Confidential, Richfield, MN

ETL/Informatica Developer

Responsibilities:

• Collection of requirements from business users and analyzed based on teh requirements.
• Database Design knowledge (data warehouse structures, writing/building tables, understanding primary and foreign keys)
• Extensively used all teh features of Informatica 8.6 including Designer, Workflow manager and Repository Manager, Workflow monitor.
• Implemented Variables and Parameters in teh mappings.
• Designed and developed complex Informatica mappings using expressions, aggregators, filters, lookup and stored procedures to ensure movement of teh data between various applications.
• Creation of Sessions and executing them to load teh data from teh source system using Informatica Workflow Manager.
• Extensively worked in teh performance tuning of programs, ETL procedures and processes.
• Error checking and testing of teh ETL procedures and programs using Informatica session log.
• Used SQL tools like TOAD to run SQL queries and validate teh data.
• Designed and developed Oracle PL/SQL Procedures.
• Developed procedures to populate teh customer data warehouse with transaction data, cycle and monthly summary data, and historical data.
• Worked with teh Quality Assurance team to build teh test cases to perform unit, Integration, functional and performance Testing.
• Worked with relational and multidimensional modeling by using Erwin 7.1.3
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads.
• Worked on Power Exchange 9.0.1 version to retrieve teh data.
• Performed migration of mappings and workflows from Development to Test and to Production Servers.

Environment: Informatica PowerCenter 8.6, Oracle 10g/11g, SQL, Power Exchange 9.0.1, TOAD, PL/SQL, Autosys, MS SQL Server, UNIX, ERWIN 7.1.3

Confidential, Herndon, VA

ETL/Informatica Developer

Responsibilities:

• Worked with business and data analysts during requirements gathering to translate business requirements into technical specifications.
• Coordinated with Data modeling team and architect team to close teh Mapping Spec and source to target mapping related queries.
• Understand and discuss teh ETL requirements with teh Business Unit and preparing teh detail design documentation according to teh standards.
• Prepare design document for teh data flow from Extract team to teh ADS or ODS tables.
• Responsible for developing Mappings to load aggregate tables for reporting ease.
• Responsible for unit testing and unit test cases preparation.
• Perform code Reviews and Internal Quality checks on mappings created by teh team.
• Responsibility to create documentation/release notes for each release.
• Worked on source analyzer, Ware House Designer, Mapping and Mapplet Designer, Workflow manager and Workflow Monitor.
• Designed and developed Informatica Mappings, Mapplets and Sessions for data loads and data cleansing.
• Configured Informatica Repository Manager to manage all teh repositories of various applications. Created users, user groups, security access controls.

Environment: Informatica Power Center 8.6, Oracle, SQL Server 2008, ERWIN, Toad, Informatica Developer

Confidential, Seattle, WA

ETL/Informatica Developer

Responsibilities:

• Used update strategy to TEMPeffectively migrate data from source to target.
• Moved teh mappings from development environment to test environment.
• Designed ETL Process using Informatica to load data from Flat Files, and Excel Files to target Oracle Data Warehouse database.
• Interacted with teh business community and database administrators to identify teh Business requirements and data realties.
• Created various transformations according to teh business logic like Source Qualifier, Normalizer, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression and Update Strategy.
• Created design document Informatica mappings based on business requirement.
• Created Informatica mappings using various Transformations like Joiner, Aggregate, Expression, Filter and Update Strategy.
• Involved in teh performance improvement project.
• Involved in designing of testing plan (Unit Testing and system testing)
• Tested scripts by running workflows and assisted in debugging teh failed sessions.
• Improving workflow performance by shifting filters as close as possible to teh source and selecting tables with fewer rows as teh master during joins.
• Used persistent caches whenever data from workflows were to be retained.
• Used connected and unconnected lookups whenever appropriate, along with teh use of appropriate caches.
• Created tasks and workflows in teh Workflow Manager and monitored teh sessions in teh Workflow Monitor.
• Used SQL Server to teh extent for source data.
• Perform Maintenance, including managing Space, Remove Bad Files, Remove Cache Files and monitoring services.
• Set up Permissions for Groups and Users in all Development Environments.
• Migration of developed objects across different environments.

Environment: Informatica Power Center 8.1, Oracle 10g, SQL Server 2005/2008, UNIX, Windows Server 2008.

Confidential, Portland, OR

ETL/Informatica Developer

Responsibilities:

• Reviewed teh Business Requirement Documents and teh Technical Specification.
• Worked with ETL tool Informatica to create mappings and workflows and Transformations.
• Configured Repository Manager, created folders and managed objects in repository Manager for Informatica.
• Used Filter, Router, Aggregator, Lookup, Expression and Update Strategy transformations whenever required in teh mapping.
• Worked on Source Analyzer, Mapping Designer & Mapplets and Transformations.
• Designed Test scripts and test cases in Test Director and MS-word.
• Generated automated test cases on first build of teh module using QTP, Rational Tools.
• Developed automated test scripts from manual test cases for Regression testing based on teh requirement documents using QTP.
• Analyzed Software Requirement Specification.
• Involved in writing teh Test cases and Test plans based on Source to Target Mapping documents and Data Model diagrams.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate teh data between Enterprise Data Warehousing and Data Mart Staging Tables.
• Wrote and ran Unix Scripts for batch jobs.
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity.

Environment: Informatica Power Center 7.1, Oracle 9i, TOAD, My SQL, UNIX, Windows, SQL Navigator.