SUMMARY

• Around 5 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 with Oracle, SQL Server, DB2 databases.
• Involved in complete software development life cycle (SDLC) of project with experience in domains like Finance, 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 on Teradata V2R6, 12.0, 13.0, Teradata SQL Assistant.
• 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 9.x/8. 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, flat files, XML files, DB2.
• Used Metadata Manager(MDM) to extracts metadata from application, business intelligence, data integration, data modeling, and relational metadata sources.
• Experience in Data profiling and data cleansing using IDQ.
• 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

ETL Tools: Informatica Power Center 9.x/8.x, Data stage

Databases: Oracle 8i/9i/10g/11g, DB2, MS SQL Server 2000/2005/2008 & Teradata

Modeling Tools: Erwin 3.x/4.x, Visio, IBM Rational Rose

Scheduling Tools: Autosys

Languages: C++, SQL, PL/SQL, Unix Shell Scripting

Operating System: Windows 9x/NT/2000/XP, UNIX, Solaris

Web Skills: HTML, VBScript, JavaScript, XML

Office Applications: MS-Office 97/2000/XP/2007

Other Tools: SQL *Loader, TOAD 7.6, SQL Plus

PROFESSIONAL EXPERIENCE

Confidential, NJ

ETL/Informatica Developer

Responsibilities:

• Worked on all phases of this implementation, from gathering requirements to testing, implementation, and support.
• Involved in Preparing the High Level Design (HLD) and Low Level Design (LLD) documents for ETL Informatica process.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica.
• Developed several generic Informatica jobs which can be reused for several processes.
• Extensively used Teradata Utilities like Tpump, Fast-Load, MultiLoad, BTEQ and Fast-Export, TPT (Teradata Parallel Transporter).
• 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.
• Experienced in troubleshooting Teradata scripts, fixing bugs and addressing production issues and performance tuning.
• Prepare ETL specification, creating mappings, Teradata scripts for extraction, transformation and loading of data to data warehouse.
• 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.
• Extracted sources from flat-files, Oracle, SQL Server and load them into Oracle using Oracle Warehouse Builder.
• Worked with ETL Migration Team and Migrated Informatica folders from Dev to Test repository and from Test to Prod Repository.
• Performed Informatica Folder/Object Level Migration using Repository Manager.
• Designed, developed and tested data conversion/data integration modules to support large scale system migrations and implementations.
• 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.
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Experience in using Data profiling using IDQ.
• Configured ODBC connectivity to various source/target databases.
• Tuned performance of Informatica session for large data files by using partitioning, increasing block size, data cache size, sequence buffer length and target based commit interval.

Environment: Informatica Power Center 9.1x, UNIX, Oracle 10g, Flat Files, DB2, Windows, SQL Developer, PL/SQL. Teradata.

Confidential, NJ

ETL Informatica Developer

Responsibilities:

• Involved in Analysis, Requirements Gathering and documentation of Functional & Technical specifications.
• 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.
• Designed, developed and tested data conversion/data integration modules to support large scale system migrations and implementations.
• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Configured ODBC connectivity to various source/target databases.
• Tuned performance of Informatica session for large data files by using partitioning, increasing block size, data cache size, sequence buffer length and target based commit interval.
• Identified the Bottlenecks, removed them and implemented performance tuning logic on targets, sources, mapping, sessions to provide maximum efficiency and 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.
• Used Workflow Monitor to monitor the jobs, review error logs that were generated for each session, and resolved them.
• Created high-level Technical Design Document and Unit Test Plans.
• 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 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.
• Performed Informatica Folder/Object Level Migration using Repository Manager.
• Performed Code review of mappings of various applications.

Environment: Informatica PowerCenter 9.1x/8.x, UNIX, Oracle 10g, Flat Files, Batch script, Windows, PL/SQL, Erwin.

Confidential

ETL Informatica Developer

Responsibilities:

• Involved in gathering Business requirements and technical aspects for development.
• Developed Logical and physical database designs for the transaction system.
• Extract the XML file from source transform it with multiple transformation including XML Transformation.
• Performance tuning on sources, targets, mappings and SQL queries in the transformations.
• Used PL/SQL Views, Triggers, Procedures and Functions.
• Designed and developed complex ETL mappings making use of transformations like Source
• Qualifier, Expression, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Router, Filter, Aggregator and Sequence Generator transformations.
• Created reusable transformations and mapplets based on the business rules to ease the development.
• Developed mappings to implement type 2 slowly changing dimensions.
• Developed and implemented the UNIX shell script for the start and stop procedures of the sessions.
• Used various Informatica Error handling technique to debug failed session.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision
• Used various debugging techniques to debug the mappings.
• Created Test cases for Unit Test, System Integration Test and UAT to check the data quality.

Environment: Informatica PowerCenter 9.1x/8.x, UNIX, Oracle 10g, Flat Files, Batch script, Windows, PL/SQL, Erwin, SQL Server 2005/2008.

Confidential

Database Developer

Responsibilities:

• Analyzed the system, discussed with end users and business units in order to define the requirements.
• Framing requirements from business information in technical terms and put that information into single document and getting it approved from the customer.
• Maintaining the data coming from the OLTP systems.
• Tuned the database queries to improve the performance of the query and indexing strategies.
• Coded database triggers to record the changes made to the database objects.
• Coded functions and stored procedures to perform the user defined functions and execute the required query whenever needed.
• Document the work performed each day.
• Helped coding shell scripts for database scripting.
• Establishing an application's security measures during development of Application in collaboration with DBAs.
• Involved in Physical schema implementation, objects like table-space, table rollback segments.
• Created database structures, objects and their modification as and when needed.
• Managed users & roles for database security.
• Assigned predefined profiles and roles to the users to maintain database security, CPU activity, idle time and quota management on table-spaces.
• 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.
• 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: Oracle 10g, PL/SQL, UNIX, Toad, Flat Files, Windows, SQL Developer.