SUMMARY

• Over 7 years of experience in IT in the areas of analysis, design, development in client server environment with focus on Data warehousing applications using ETL/OLAP tools like Informatica, Business Objects with Oracle, SQL Server, Teradata V2R5.1, DB2 databases and Netezza.
• Involved in complete software development life cycle (SDLC) of project with experience in domains like Healthcare Insurance, Banking and Pharmaceutical.
• Experience in business requirements gathering, define and capture metadata for business rules, system analysis, design, development, production support, testing, user training, and strategic decision making, problem solving associated with the ETL processes by working closely with BI team.
• Experience in developing Enterprise level Datawarehouse (EDW), Data marts and Operational databases (ODS).
• Excellent knowledge and experience in data warehouse development life cycle, requirements analysis, dimensional modeling, Repository management and administration
• Through knowledge of Relational & Dimensional models (Star & Snow Flake), Facts and Dimension tables, Slowly Changing Dimensions (SCD)
• Hands on experience in implementing Slowly Changing dimension types (I, II &III) methodologies, Incremental Loads and Change Data Capture
• Experience in creating complex mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism by using Informatica 8.6/7.x.
• Experience in writing complex sub queries, PL/SQL programs (functions, procedures, packages), stored procedures, and shell scripting to run pre session and post session commands.
• Worked with heterogeneous data sources like Oracle, SQL Server 2008/2005, Teradata V2R5.1, flat files, XML files, DB2 UDB, Main Frames and COBOL files.
• Used Metadata Manager to extracts metadata from application, business intelligence, data integration, data modeling, and relational metadata sources.
• Perform error handling as part of production support on Informatica as well as Unix.
• Expert in troubleshooting/debugging and improving performance at different stages like database,workflows,mapping
• Experience in performance tuning of sources, transformations, targets, mapplets, mappings, worklets, workflows, sessions and batches
• Enthusiastic and goal - oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.

TECHNICAL SKILLS

Data warehousing: Informatica Power Center 8.6/8.5/8.1/7.1, Informatica Power Connect for Siebel/SAP/PeopleSoft, Power Exchange for DB2, Metadata Manager, Data Profiling & cleansing, OLAP, OLTP, Star & Snowflake Schema, Physical & Logical Data Modeling,, Erwin 4.0

BI Tools: Business Objects XIR2/6.0/5.1/5.0, Micro strategy 8

Databases: SQL Server 2005/2000/7.0/6.5, DTS,SSIS, Oracle 10g/9i/8i/8/7.3, Sybase, TeraData 6,My SQL, MS-Access, DB2 8.0/7.0

Languages: C, C++, XML, SQL, T-SQL, PL/SQL, UNIX Shell Scripting

Operating System: HP-UX11/10/9,IBM-AIX4.0/3.1, Sun Solaris 9/8/7/2.6/2.5, SCO-UNIX, LINUX, Windows XP Professional/2000/NT/98/95

Other Tools: MS Visual Source Safe, PVCS, Autosys, Control M, Remedy, Mercury Quality center, Star Team, Lotus Notes.

DB Programming & Tools: RDBMS, Joins, Indexes, Views, Functions, Triggers, Clusters, Procedures, SQL*Plus, SQL*Loader, Export/Import, TOAD, SQL Navigator, Explain plan, SQL Trace

PROFESSIONAL EXPERIENCE

Confidential, Hoboken, NJ

Sr. Informatica Developer

Responsibilities

• Worked on all phases of this implementation, from gathering requirements to testing, implementation, and support.
• Participated in Data Warehouse and Data Mart design and data modeling using Erwin 7.3.
• Involved in Preparing the High Level Design (HLD) and Low Level Design (LLD) documents for ETL Informatica process
• Developed several jobs to load SCD’s, Fact and Summary Tables.
• Developed several generic Informatica jobs which can be reused for several processes.
• Designed and developed complex mappings that involved Slowly Changing Dimensions, Error handling, Business logic implementation
• Created sessions, worklets, workflows for the mapping to run daily, biweekly and monthly based on the business requirements.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance
• Developed complex mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Router, Update strategy, Sequence generator, Java, Rank, Aggregator, SQL, Xml, Stored procedure and Normalizer.
• Created Sessions and partitioned using different partition types like key range partitioning.
• Used Parameter files to manage the control dates for the incremental load times.
• Worked on Informatica Data profiling to analyze the quality of incoming data.
• Worked with ETL Migration Team and Migrated Informatica folders from Dev to Test repository and from Test to Prod Repository.
• Created reusable mapplets using Mapplet Designer which involved date conversions.
• Supported the migration phases of the Informatica upgrades from versions 8.1.1, 8.6.1 to 9.0.1.
• Performed Informatica Folder/Object Level Migration using Repository Manager.
• Performed Code review of mappings of various applications.

Environment: Informatica PowerCenter 9.0.1/8.6.1/8.1.1, Unix, Oracle10g/11g, SQL Server 2005/2008, XML, Flat Files, Batch script, Windows, TSQL,PL/SQL, Erwin 7.3.

Confidential, New York, NY

Sr. ETL Developer

Responsibilities

• Worked with Data Architects and DBA’s to design the logical and Physical model for DWH.
• Worked with business team and architects to translate business requirement into tech design.
• Guided developers for successfully implementation of tech design.
• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Used Change data capture (CDC) for data integration that is based on the identification, capture and delivery of the changes made to enterprise data sources
• Developed mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Update strategy and Normalizer for XML file.
• Modified the existing ETL code (Mappings, Sessions and Workflows) and Perl scripts as per the user requirements.
• Involved in Performance tuning for better performance.
• Involved in Unit, System integration, User Acceptance Testing of Mappings. Wrote complex SQL override scripts at source qualifier level to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy.
• Responsible for Creating workflows and worklets. Created Session, Event, Command, and Control Decision and Email tasks in Workflow Manager.
• Created high-level Technical Design Document and Unit Test Plans.
• Worked on Business Objects XIR2 suite using Desktop Intelligence, CMC, Web Intelligence reporting and Publisher.

Environment: Informatica PowerCenter 8.6.1/8.1.1, UNIX, Oracle 10g, Flat Files, Batch script, Windows, PL/SQL, Erwin.

Confidential, IN

Informatica Developer

Responsibilities

• Analyzed the system, discussed with end users and business units in order to define the requirements.
• Involved in creating, administering repositories, Folders, Permissions and users using repository manger.
• Framing requirements from business information in technical terms and put that information into single document and getting it approved from the customer.
• Migration of code from one environment to another (DEV to QA and QA to PRD) and from Informatica 8.1 to Informatica 8.6
• Used ETL to extract and load data from Oracle, Sql server and flat files to Oracle.
• Used Informatica Designer to create complex mappings using different transformations load data to Data Warehouse/Data Marts.
• Involved in production Support and gave training to the new joiners.
• Developed Mappings that extract data form ODS to Data mart and Monitored the Daily and Weekly Loads.
• Created and monitored Sessions/Batches using Informatica Server Manager/Workflow Monitor to load data into target Oracle database.
• Worked with mapping variables, Mapping parameters and variable functions like set variable, Count variable, set minvariable and set maxvariable.
• Wrote functions, triggers and stored procedures in PL/SQL.
• Created test plans for the various modules, integrated and tested during package release
• Developed UNIX shell scripts as part of the ETL process to schedule tasks/sessions.

Environment: Informatica PowerCenter 8.1, Oracle 10g, SQL, PL/SQL, UNIX, SQL, Toad, Remedy (Handling CRs and TTs). Microsoft VSS