PROFESSIONAL SUMMARY

• Around 9 years of experience in data warehousing database applications
• Strong experience in data warehousing ETL tool - Informatica
• Informatica Certified Developer
• Excellent at working with Users, Business Analysts, Subject Matter Experts and other stake holders
• Strong experience in Healthcare, Telecom, Financial and Insurance verticals
• Excellent Knowledge on Data Warehousing concepts, Data Analysis, DWH Architecture
• Strong in Design, Development, Testing Implementation of Data warehouse/Data mart.
• Hands-on experience on Ab-initio and Datastage
• Good experience on offshore/onshore model and worked as onsite coordinator/tech lead in multiple projects.
• Involved in all phases of Software Development Life Cycle SDLC
• Extensively used Informatica tools like Source Analyzer, Target Designer, Mapping Designer, Workflow Manager and Work flow Monitor.
• Strong Knowledge on Dimensional Modeling, Star and Snowflake Schema. Thorough understanding of DW concepts like Facts, Dimensions, Surrogate keys.. etc approach
• Extensively worked with different source systems like Flat files, COBOL, XML, Oracle, Sybase, Teradata, SQL Server, DB2..etc
• Strong knowledge on Data Migration, Data Cleansing, Data Integration, Data Normalization for DWH
• Excellent at performance tuning, identifying and resolving performance bottlenecks at mapping and DB level
• Testing Methodologies, templates for reporting test results
• Strong experience in validating Data Mappings, ETL Processes, BI Reports.
• Extensively worked on Informatica Power Exchange 9.1/9.5.1
• Strong knowledge of ETL Architecture and Admin work responsibilities
• Good working knowledge of SQL and BTEQ in Teradata, Oracle, PL/SQL, SQL server, DB2 as RDBMS with Procedures, Functions.
• Knowledge of Java, C, C , Web Services
• Strong conceptual knowledge of Master Data Management MDM
• Working Experience on BO, Cognos and other reporting tools
• Excellent knowledge of UNIX, LINUX, Windows, and Perl scripting
• Working Experience on BO, Cognos and other reporting tools
• Experience on scheduling tools like Informatica Scheduler, WLM , Autosys,Tivoli
• Team player with excellent Organization and Interpersonal skills and ability to work independently
• Proven ability to efficiently manage time and resources and prioritize tasks in order to work on multiple projects simultaneously in a given timeline

TECHNOLOGIES

Database: Oracle 11i/10g/9i/8i, Teradata V2R5/V2R6, Sybase, SQL Server 2005

Data Warehouse Tools: Informatica Power Center 9.1/8.6/8.1/7.1/6.2, Power Exchange 9.1/9.5.1

BI Tools: BI, Business Objects 6.1

Languages: SQL, PL/SQL, Java, C, C , Web Services, MS Access, Perl, UNIX, Linux

Office Tools: MS Office Suite, MS Project, Microsoft Share Point

Operating System: UNIX, Windows

Other Tools: Toad, Teradata SQL Assistant, SQL Loader, SQL Developer

Scheduling Tools WLM, Autosys, Informatica scheduler, Tivoli

EXPERIENCE

Confidential

Sr.ETL Developer

• CDT CRF layers in Oracle
• Involved in analyzing the requirements, Design, Development Implementation
• Extensively worked on LLD, HLD and ETL Specs based on BSD and Mapping document.
• Thorough Data profiling ,impact analysis due to source system changes
• Extensively worked on Informatica tools like Source Analyzer, Target Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Worked with different sources like Flat files, Oracle ,Teradata COBOL files and loaded them into
• Implemented Audit, Balance Control mechanism in all mappings
• Extensively worked with Informatica Power Exchange 9.1 to import multiple segment mainframe files into Horizon IDS
• Used various Transformations like Joiner, Aggregator, Expression, Lookup, Filter, Union, Update Strategy, Stored Procedures, and Router etc. to implement complex logic while coding a Mapping.
• Involved in performance tuning, identifying and resolving performance bottlenecks at mapping, session and database level
• Designed and implemented mappings using SCD type 1/2/3 and CDC methodologies
• Extensively worked on UNIX, LINUX and Perl scripting
• Interacting with business , Lights on multiple source teams on all MB A data issues
• Production support for all ICoE applications.
• Coordinating with DBA, Informatica/Unix admin, WLM teams for all the deployment activities.
• Worked on Tivoli Scheduler to automate the Workflow/UNIX scripts.

Environment: Informatica Power Center 9.1, Power Exchange 9.1/9.5.1,Mainframe, Oracle 11g, Teradata SQL Assistant 13.10, Oracle SQL Developer, HP-UX, Windows NT, UNIX Shell Scripting,WLM

Confidential

Sr.ETL Developer

• Extensively worked on TSD and ETL Specs based on BSD and Mapping document.
• Successfully completed the analysis on Infomart EDL-R1 Remediation and helped the Infomart business on decommissioning of regional data warehouses
• Involved in Edward RIM testing, Debugging and ensured that business is getting correct data.
• Created ETL stored procedures parameterized with the use of triggers functions, highly programmable PL/SQL for simplifying many complex processes such as bulk truncate and bulk load for Terabyte load of large data etc
• Worked with SQL Loader for bulk data load.
• Involved in implementation of datamart /Data warehouse..
• Implemented different Tasks in Workflow which included Session, Command, Email, Event-Wait etc.
• Involved in performance tuning, identifying and resolving performance bottlenecks at mapping and database level. Increased the Performance of a mapping by eliminating the lookups on large tables coded the complex logic with expression transformation and SQL transformation's override ability
• Interacting with business , Lights on multiple source teams on all Infomart data issues
• Coordinating with DBA, Informatica/Unix admin, WLM teams for all the deployment activities.
• Worked on WLM Scheduler to automate the Workflow/BTEQ/UNIX scripts.
• Followed client coding standards SDLC process and excellent knowledge on TSRM for code migration.

Environment: Informatica Power Center 9.1, Power Exchange 9.1.0, Oracle 11g, Teradata SQL Assistant 13.10 ,HP-UX, Windows NT, Visio 2005 ,WLM

Confidential

Sr.ETL Developer

• Extensively worked on implementation of Data mart Data Ware house.
• Implemented different Tasks in work flows which included Session, Command, E-mail, Event Wait
• Worked with Flat files, COBOL files and SQL Server and loaded them into SQL Server.
• Used various Transformations like Joiner, Aggregate, Expression, and Look up, Filter, Union, Update Strategy, Stored Procedures, and Router etc. to implement complex logic's while coding a Mapping.
• Worked on Informatica tools like Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, and Workflow Monitor.
• RDM data, simplification data extracted and loaded into staging and also involved in data profiling.
• Understand the process/business with in short time and completed the stage data load for all the source systems with in time and got appreciation from the client.
• Interacting with business Source teams on all data issues
• Loading the data from different source systems like eWPD, CM2000 FoxPro , WGS into Staging
• Involved in analyzing the requirements, Design, Development of data warehouse environment.
• Involved in Performa nce Tuning of SQL Queries, Sources, Targets and sessions by identifying and rectifying performance bottlenecks.

Environment: Informatica Power Center 9.1 Mapping Designer, Workflow Manager, Workflow Monitor , Teradata SQL Assistant 13.10, Oracle, HP-UX, Windows NT, Visio 2005

Confidential

Sr.ETL Developer

• Understanding existing system and customer requirements translated business process into Informatica mappings
• Analysis, Design, Development and Testing on production issues.
• Worked on Informatica tools like Source Analyzer, Target Designer, Mapping Designer, Workflow Manager, and Workflow Monitor.
• Involving in performance tuning activities
• Developed reusable mapplets in mapplet designer for use in different mappings
• Performed validation of all tasks and fixed invalid/ failed Workflow using Workflow Monitor
• Significantly improved session performance by tuning mappings containing complex transformation logic
• Worked with memory cache for static and dynamic cache for better throughput of sessions containing lookup, joiner, sorter, and aggregator transformations
• Designed and developed pre-session and post-session routines for Informatica sessions to drop and recreate indexes and key constraints for bulk loading
• Performed extensive unit testing of mappings to ensure delivery of data as per the business logic
• Developed UNIX shell scripts for scheduling Informatica jobs
• Involved in setting up jobs and schedules to schedule loads at required frequency using Autosys scheduler and parameter files
• Developed and mainta ined technical documentation from source to target load process

Environment: Informatica Power Center 8.1, SQL, Oracle 10g, Windows 2000, UNIX, Business Object 6.1, TOAD