SUMMARY

• Over 8 Years of experience in Information Technology and Data warehousing, ETL, applications using Informatica (Power center/Power Mart)
• Implemented data warehousing methodologies for Extraction, Transformation and Loading usingInformatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, Repository Server Administration Console.
• Extensively worked onETL Informatica TransformationsTEMPeffectively including - Source Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, SorterandSequence Generatorand created complex mappings.
• Strong experience in designing and developing Business Intelligence solutions in Data Warehousing/Decision Support Systems usingInformatica Power Center 9.1/8.6/8.1/7.1
• GoodExperience in developing Unix Shell Scripts for automation of ETL process.
• Worked on Exception Handling Mappings forData Quality, Data Profiling, Data Cleansing, Data Validation
• Expertise in creatingdatabases, users, tables, triggers,macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
• Strong noledge of OBIEE 10g/11g as a Business Intelligence tool and Data Extraction using Informatica as ETL tool.
• Extensively worked with Teradata utilities likeBTEQ, Fast Export, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
• ImplementedSlowly Changing dimensions Type 1andType 2, methodology for accessing teh full history of accounts and transaction information.
• Involved in understanding requirements and in modeling activities of teh attributes identified from different source systems likeOracle, Teradata, SQLandFlat files.
• Expertise in Data modeling techniques like Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.
• Expertise in implementing complex business rules by creatingre-usable transformations, Mapplets,Mappings, Mapping, Session and Workflow Variables.
• Experience in staging, validating and loading teh data intoTeradata Warehouseusing Informatica.
• Good understanding of relational database management systems like Oracle, TeraData, DB2, and SQL Server and extensively worked on Data Integration using Informatica for teh Extraction transformation and loading of data from various database source systems and mainframe Cobol and VSAM files
• Experienced inPerformance of Mapping Optimizationsin Informatica.
• Experienced in using teh Oracle SQL* Loader feature for loading teh data from Flat Files to Data Base tables for Bulk Loading.
• Involved in Relational database design and development of data warehouse data feeds.
• Involved in CompleteSoftware Development LifecycleExperience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation
• Very strong in Relational Databases (RDBMS), Data Modeling and Design and build teh Data Warehouse, Data marts using Star Schema and Snow Flake Schema for faster and TEMPeffective Querying.
• Good experience in using SQL, PL/SQL, Indexes, Functions, Procedures, Triggers and Cursors.
• Excellent Team Player self-motivated with good communications skills.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter 9.1/8.6/8.1/7.1 /6.1 (PowerCenter Repository, Informatica Designer, Workflow manager, Workflow monitor), Power Exchange, Developer (IDQ) and Analyst (IDE).

Databases: MS SQL Server 2005/2008, Oracle 8i/9i /10g, Teradata, IBM DB2, Sybase

Data Modeling Tools: ERWIN 4.0/3.4, Star Schema Modeling, Snow Flake Modeling, Fact and Dimensions tables, Entities, Attributes

Database Skills: Cursors, Stored Procedures, Functions, Views, Triggers and Packages

Client Side Skills: SQL, T-SQL, PL/SQL, UNIX ShellScripting, XML.

Web Servers: IIS v5.0/6.0, Apache Tomcat

Operating System: Windows 2000/2003/XP/Vista/Windows 7, UNIX Linux.

Methodologies: Master Data Modeling Logical/ Physical, Star/ Snowflake Schema, FACT& Dimension Tables, ETL, OLAP.

PROFESSIONAL EXPERIENCE

Confidential, VA

Informatica/ETL Developer

Responsibilities:

• Involved in Builing scalable, highly available, and reliable business intelligence systems
• Developed Extraction, Transformation and Loading (ETL) processes to acquire and load data spanning across various applications (enterprise, cloud), data centers, and social graphs
• Experience in Performance tuning and Optimization of Cache with Informatica and OBIEE.
• Used concept of staged mapping in order to perform asynchronous Web Services request and response as part of Informatica Mappings
• Participated in setting teh strategy for data warehousing systems; set standards and best practices for programming, security, and operations areas
• Collaborated with developers, stakeholders and subject-matter experts to establish technical vision and analyze trade-offs between usability and performance needs
• Played a key role in teh setting of standards for both teh physical and logical database schema and table design.
• Modifying teh UNIX scripts as a part of Upgrade and making sure they point to teh correct directories.
• Participated in design and specification of teh hardware and storage architecture used to support data warehousing systems
• Involved collaborating with global delivery teams
• Involved with data modeling using ER and dimensional modeling techniques
• Experience in defining security standards aligned with corporate data governance and compliance policies
• Wrote UNIX Shell Scripting for Informatica Pre-Session, Post-Session Scripts and also to run teh workflows.
• Involved in developing OBIEE Repository at three layers (Physical, Business model and Presentation Layers), Interactive Dashboards and drill down capabilities using global and Filters and Security Setups
• Involved in designing prototypes and working closely with implementation teams in engineering and operations
• Involved in Using OBIEE 11g for Creating RPD,S and creating Reports and Dashboards.
• To develop ETL procedures to transform teh data in teh intermediate tables according to teh business rules and functionality requirements.
• Used Cobol files by using Power exchange using data maps
• Implementing various workflows using transformations such as SQL Transformation, XML transformation, Normalizer, look up, aggregator, stored procedure and scheduled jobs for different sessions.
• Performance Tuning of Sessions and Mappings.
• Tune performance of Informatica sessions for large data files by implementing Pipeline partitioning and increasing block size, data cache size, sequence buffer length, target based commit interval.
• Worked on DB2.

Confidential, Dallas, TX

Sr. Informatica Developer

Responsibilities:

• Worked as a Sr. Informatica Developer and participated in all teh project phases starting from Requirements gathering through Deployment of this Program (SDLC).
• Worked as a part of Onsite - Offshore model. Being a developer, I has taken teh responsibility for creating checklists for coding standards, naming conventions etc. I has also developed reusable code components to maintain ETL standard load practices like Table Analyze script, Stage pre load, file archive and maintaining two months of archived files and logs
• Used Full PDO (Push down optimization) in infromatica for loading data.
• Creating mappings to load data using different transformations
• Troubleshooted teh ETL process developed for Conversions and implemented various techniques for enhancing teh performance.
• Extensively involved in creating design documents for loading data into Data warehouse and worked with teh data modeler to change/update teh Data warehouse model when needed.
• UsedTeradata utilities fastload, multiload, tpumpto load data
• WroteTeradata Macrosand used various Teradataanalytic functions
• Excellent noledge on ETL tools such as Informatica, SAP BODS to load data to Teradata by making various connections to load and extract data to and from Teradata efficiently.
• Developed ETL processes to load data into dimensional model from various sources using Informatica Power Center 9.5.1
• Developed Mapplets and reusable transformations that were used in different mappings and across different folders
• Designed and developed teh error handling mechanism to be used for all teh Informatica jobs, which load data into teh data warehouse.
• Extensively used warehouse designer of Informatica Power center Created different target definitions.
• Working on Billion record tables ( performance tuning for historical loads )
• Created robust and complex workflows and worklets using Informatica workflow manager and Troubleshooted data load problems

Environment: Informatica Power Center 9.1 Hot fix2 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Oracle 11g, SeaQuest, HPDM, SQL Server, TeraData,UNIX, Toad, Control-M.

Confidential, Carlsbad, CA

EDW Informatica Developer

Responsibilities:

• Worked in all teh project phases starting from Requirements gathering through Deployment of this Program.
• ETL Tool Informatica is used for Design and Development of teh code.
• Data is sourced from 22 different Work Units. These Work Units span across huge variety of data sources like Oracle, Flat Files, MS Access and Spread Sheets.
• ETL flows are developed from Source to Stage, Stage to Work tables and Stage to Target Tables.
• Used Conversion process for VSAM to ASCII source files using Informatica Power Exchange
• Used BTEQ andSQL Assistant(Query man) front-end tools to issue SQL commands matching teh business requirements to Teradata RDBMS
• Extracted data from various sources such asDB2, Oracle, Teradatafixed width and de-limited flat files, cleansed and loaded data into Teradata and Flat file targets using Informatica and PL/SQL
• Source and Target Definitions are imported from Source Analyzer and Target Designer connecting to databases using Relational and ODBC Connections.
• Developed Informatica Mappings for teh complex business requirements provided using different transformations like Normalizer, SQL Transformation, Expression, Aggregator, Joiner, Lookup, Sorter, Filter, and Router and so on.
• Worked in developing Mapplets and Re-usable Transformations for reusability and reducing effort.
• Created Work Flows with Command Tasks, Worklets, Decision, Event Wait and Monitored sessions by using workflow monitor.
• Migrated Informatica Folders from Development Env to Test and System Test Env and Worked with Admins to migrate teh same to Production environments.
• Wrote PL/SQL procedures for reconciliation of financial data between source and target to automate testing phases and help business for preliminary validation.
• Wrote UNIX scripts, environment files for Informatica.
• Developed Metadata driven code for TEMPeffective utilization and maintenance using technical metadata, business metadata and process metadata.
• To externalize teh business logic instead hardcoding in teh mapping I has used Parameter file in Informatica.
• Generated BO reports to test standardized reports as per business requirements.
• Tuned Mappings and Mapplets for best Performance on ETL Side and Created Indexes and Analyzed tables periodically on Database side.
• Organized teh dataflow and developed many AutoSys jobs for Scheduling MINT program and moved to production.
• Primary resource in Production support team so, involved in emergency calls when application outage occurred and resolved defects when raised.

Environment: Informatica Power Exchange, Power Center 8.6, Power Connect, Teradata, Data Explorer and Data Quality, Data Flux, Erwin 3.5, OBIEE 10.1.3, DB2,Oracle 10g, SQL Loader, XML, Unix, Win NT, TOAD, AutoSys.

Confidential, Parsippany NJ

ETL Developer

Responsibilities:

• Developed Informatica jobs for Conversions which involved loading teh mainframe extract data into staging tables
• Troubleshooted teh ETL process developed for Conversions and implemented various techniques for enhancing teh performance.
• Developed and maintained custom PL/SQL packages and procedures for analysis of source system data and also for data validation
• Extensively involved in creating design documents for loading data into Datawarehouse and worked with teh data modeler to change/update teh Datawarehouse model when needed.
• Developed ETL processes to load data into dimensional model from various sources using Informatica Power Center 8.1.
• Developed Mapplets and reusable transformations that were used in different mappings and across different folders
• Designed and developed teh error handling mechanism to be used for all teh Informatica jobs, which load data into teh data warehouse.
• Extensively used warehouse designer of InformaticaPowercenter Created different target definitions.
• Created robust and complex workflows and worklets using Informatica workflow manager and Troubleshooted data load problems

Environment: Informatica Power Center 8.1(Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Oracle 9i, SQL Server, UNIX, Toad.

Confidential, NYC, NY

DW Informatica Developer

Responsibilities:

• Involved in meetings with teh business for gathering requirements and identifying teh source data.
• Developed SQL packages for analyzing teh source system data and also for generating teh extract scripts for loading data into staging tables.
• Performed GAP analysis and also determined teh cross-reference tables needed.
• Developed Complex mappings and workflows using PowerCenter designer and Workflow manager for loading data into Datawarehouse from staging.
• Troubleshooted teh Informatica jobs identified teh performance bottlenecks and adopted various techniques to improve teh performance.
• Performed unit testing on teh Informatica jobs developed and documented teh test results.
• Involved in updating teh shell scripts and parameter files, which are used to run teh workflows daily, with teh new Informatica jobs developed.
• Involved in integration testing of teh jobs developed and migration of jobs from one environment to another.
• Developed Informatica jobs for loading data into DataMart from data warehouse using reusable transformations and Mapplets.
• Involved in Informatica Administrative tasks Repository and folder management, User permissions, version controlling, metadata reporting, and server management.
• Worked on performance tuning for mappings by optimizing teh sources, transformations, targets and sessions.
• Developed test scripts for Unit testing teh Informatica jobs developed for loading data into data mart.
• Involved in production support for teh data warehouse Informatica jobs

Environment: Informatica Power Center 8.1, Informatica Power Connect, (Repository Manager, Designer, Server Manager, Workflow Monitor, Workflow Manager), Power Exchange, Power Analyzer, ETL, Oracle 11g/10g, Teradata V2R5, PL/SQL,ODI, Unix commands, Trillium 11, Excel and shell scripting, MS Windows XP professional 2002,UNIX.

Confidential

ETL Developer

Responsibilities:

• Analysis of teh specifications.
• Maintain Meta data in teh repository.
• Document all Meta data dictionary.
• Designer Mapping Designer and mapplets, and Transformations.
• Preparing mapping documents.
• Extracting Data from source to target usingInformatica
• Testing - unit testing & integration testing.
• UNIX and Perl scripts for Screen Door Programs.

Environment: Flat files, MS SQL Server 2000, PL/SQL, Reporting Services 2000, AutoSys, DOS commands, Excel and batch scripting, DOS, MS Windows 2000.