SUMMARY

• 8+ Years of experience in which 6+ years of experience in IT - Data warehouse implementations using Informatica PowerCenter 9.x/8.x/7.x, Oracle 11g/10g/9i, Netezza, MS SQL SERVER 2008/2005
• Extensive experience in Analysis, Design, Development, Implementation, Enhancement and Support of BI applications which includes strong experience in Data Warehousing (ETL & OLAP) environment as a Data Warehouse Consultant.
• Proficiency in utilizing ETL tool Informatica Power Center 9.x/8.x/7.x for developing the Data warehouse loads with work experience focused in Data Acquisition and Data Integration.
• Expertise in designing confirmed and traditional ETL Architecture involving Source databases Main Frame systems (COBOL files), Oracle, Flat Files ( fixed width, delimited ),DB2, SQL server, XML and Target databases Oracle, SQL server, XML and Flat Files ( fixed width, delimited ).
• Have Good understanding of ETL/Informatica standards and best practices, Slowly Changing Dimensions (SCD1, SCD2, and SCD3).
• Strong knowledge of Dimensional Modeling, Star and Snowflake schema. Designed Fact and Dimension Tables as per the reporting requirements and ease of future enhancements.
• Extensive Experience in designing and developing complex mappings applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter joiner and sorter transformations.
• Extensive experience in developing the Workflows, Worklets, Sessions, Mappings, and configuring the Informatica Server using Informatica Power Center.
• Excellent knowledge in identifying performance bottlenecks and also in tuning the Mappings and Sessions by implementing various techniques like partitioning techniques and pushdown optimization.
• Experience in creating Sessions, Workflows and Worklet by using the Workflow Manager tools like Task Developer, Worklet and Workflow Designer.
• Experience in optimizing query performance, session performance and fine tuning the mappings for optimum performance.
• Created reusable transformation and mapplets in the designer using transformation developer and mapplet designer.
• Experience with pre-session and post-session SQL commands to drop indexes on the target before session runs, and then recreate them when the session completes.
• Extensively worked for monitoring scheduled, running, completed and failed sessions. Involved in debugging the failed mappings and developing error handling methods.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• Provided 24/7 Active Data Warehouse Production Support as part of on-call rotation for both Incremental and Complete refresh.
• SME for application, provide assistance to support team during issues in production
• Lead and provided guidance to both on-site and off-shore teams for various EDW initiatives with design and coding standards and best ETL practices for using normalized data structures, de-normalized structures, and dimensional structures, best practices for the design, development, deployment, change management, support and successfully present the ETL Data Integration efforts to external departments to influence, appreciate and gain support for the projects from client departments.
• Provided extensive Production Support for Data Warehouse for internal and external data flows to Netezza, Oracle DBMS from ETL servers via remote servers.
• Experienced as point of contact to client for enhancement and support related activities
• Support for code deployment in QA and PROD environment and also responsible for code validation
• Responsible for Production support activities like Jobs monitoring, log the load statistics, analysis and resolve in case of any production issues, coordinate with business to fix any source file issues, coordinate with DBA to resolve any table space or file system related issues.
• Responsible for deliverables out of monthly/Quarterly/Half Yearly/Yearly jobs
• Very strong SQL skills, under Windows and Unix shell script environment including use of nested table expressions, unions, multi-table joins, scalar functions, outer joins, derived columns and creative use of the EXISTS operator.
• Excellent communication skills, Business interaction skills and strong interpersonal skills to deal effectively with customer groups and clients to the top management.
• Knowledge in ETL techniques Analysis and Reporting tools.
• Having Experience with working with Insurance, Banking and Telecom domain clients.
• Excellent team player and self-starter with good ability to work independently and possess good analytical, problem solving and logical skills.

TECHNICAL SKILLS

ETL Tools: Informatica 9.x/8.x//7.x SQL Server Integration services.

OS: Sun Solaris 2.x/7/8, HP-UX, IBM AIX, Unix, Linux, MS-DOS, Windows ME/ 2000/ 2003/ NT/ XP, Exceed (Editor)

Databases: Netezza, Oracle (6.x/7.x/8.0/8i/9i/10g), SQL Server 2008/2005/2000 (T-SQL, Stored procedures, Triggers, DML, DDL, DTS), Sybase 11.5, Informix (XPS, 7.x/8.x), MS-Access, XML, DB2, VSAM, Teradata.

Programming Skills: C++, Shell Scripting (K-Shell, C-Shell), PL/SQL, PERL, FORTRAN, JAVA (Eclipse IDE and Net Beans IDE), HTML,JCL, JAVA Script, J2EE, CSS

DB Tools: SQL*PLUS, SQL*LOADER, SQL*NET, Quest TOAD, SQL Navigator, Oracle Enterprise Manager, Oracle WSGL/Web Tool kit

DM Tools: Toad, SQL Developer, Star-Schema, Snowflake-Schema

PROFESSIONAL EXPERIENCE

Confidential - Milwaukee, WI

Informatica / ETL Developer

Responsibilities:

• Involved in requirement analysis, ETL design and development for extracting data from the source systems like Netezza, DB2, Oracle, flat files and loading into sales force application.
• Implemented ETL Informatica designs and processes for loading data from the sources to target warehouse.
• Designed mappings from scratch and also did performance tuning of the mappings that were previously implemented and were having bottleneck.
• Worked on Power Center Tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Worked on Designer Tools like Source Qualifier, Aggregate, Lookup, Expression, Normalizer, Filter, Router, Rank, Sequence Generator, Update Strategy and Joiner.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Developed Re-usable Transformations and Mapplets.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning using Netezza Database.
• Worked with Index Cache and Data Cache in cache using transformation like Rank, Lookup, Joiner, and Aggregator Transformations.
• Created Netezza Sql scripts to test the table loaded correctly
• Wrote SQL scripts to verify row counts and validate the data.
• Extensive experience in debugging and troubleshooting Sessions using the Debugger and Workflow Monitor
• Worked with Session Logs and Workflow Logs for Error handling and troubleshooting in DEV environment.
• Involved in preparing ETL design documents and Unit Test Plans for Mappings.
• Prepared the code migration document and worked with release team in Migrating the code (Informatica Objects, Unix Scripts) from Development to Test and Production environments
• Involved in answering the change request as part of the interaction testing
• Deployed ETL components code into multiple environments as per the approval received
• Provided Production Support by executing the sessions, diagnose problems and fix the mappings for changes in business logic.
• Responsible for Unit testing and Integration testing of mappings and workflows.
• Followed the required client security policies and required approvals to move the code from one environment to other.
• Attended daily status call with internal team and weekly calls with client and updated the status report.

Environment: Informatica Power Center 9.5/9.5.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Repository Administration Console), Netezza, Oracle Developer, Oracle 11g, SQL Server 2012, T-SQL, TOAD, UNIX, HP Quality Center, Autosys, MS Office Suite .

Confidential - Richmond, VA

ETL/Informatica Lead / Developer

Responsibilities:

• Worked as a Senior ETL Lead for onsite/offshore model and leading a team of 6 members.
• Key Player in the team, assigned with designing, extracts/mappings having millions of data and complex logics.
• Technical consultant for the team to provide optimal solutions, design reviews, code reviews and for any Informatica related issues.
• Worked with Informatica power center, DB2, oracle 10g, Flat files and other sources to integrate data and also worked in Data warehouse Development life cycle.
• Worked with different mappings like getting data from Oracle tables and flat files, getting data from dimension and fact tables in 2 separate data marts and loading to oracle target tables. Also used pre-loaded stored procedures.
• Used Informatica features to implement Type I, II changes in slowly changing dimension tables and also developed complex mappings to facilitate daily, weekly and monthly loading of data.
• According to transformation logic, we used various transformations like sorter, aggregator, lookup, Expression, filters, Update Strategy, Joiner, Router etc in Mappings.
• Configured the Reusable command task for sending the triggers, invoking different scripts and Reusable Email tasks for sending failure mail along with session details and appending logs with it and success mails. Also used Event wait, Event Raise, Scheduler options in the workflows.
• Created Mapplet for error handling process to deal with null records.
• Developed code for landing environment and then for staging and finally developed Incremental load populate the target tables for atomic model.
• Loaded Historical data for specific period of time to the Atomic model.
• Developed code for backload and Incremental load.
• Tuned various sql queries, mappings, targets and sources to improve the performance.
• Used session and workflow logs for debugging the session.
• Used debugger wizard to remove bottlenecks at source level, transformation level, and target level for the optimum usage of sources, transformations and target loads.
• Configured the workflows for running concurrently, used various types of migration techniques for moving code to Test environment from Development environment.
• Coordinate and helped in testing the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects
• Performance tuning on sources, targets mappings and SQL (Optimization) tuning.
• Provided 24/7 Active Data Warehouse Production Support as part of on-call rotation for both Incremental and Complete refresh.
• SME for application, provide assistance to support team during issues in production
• Lead and provided guidance to both on-site and off-shore teams for various EDW initiatives with design and coding standards and best ETL practices for using normalized data structures, de-normalized structures, and dimensional structures, best practices for the design, development, deployment, change management, support and successfully present the ETL Data Integration efforts to external departments to influence, appreciate and gain support for the projects from client departments.
• Worked with the QA team to resolve and fix the defects found.

Environment: Informatica Power Center 9.1, Oracle 11g/10g, SQL Server 2008, PL/SQL, DB2, Windows XP, UNIX.

Confidential - Dublin, OH

Sr. ETL/Informatica Developer

Responsibilities:

• Involved in the Data warehouse data modeling based on the client requirements
• Developed Logical and physical database designs for the transaction system.
• Responsible for migrating the folders or mappings/workflows from development to production environment, Created shortcuts to share the repository objects.
• Responsible for configuring the Workflow manager, Repository Server Administration Console, PowerCenter Server, Database Connection
• Performance tuning on sources, targets, mappings and SQL queries in the transformations
• Created reusable transformations and mapplets based on the business rules to ease the development
• Used various Informatica Error handling technique to debug failed session
• Done various optimization techniques in Aggregator, Lookup, Joiner transformation
• Developed mapping to implement Type 2 SCD\'s
• Used various debugging techniques to debug the mappings
• Created Materialized view for summary data to improve the query performance
• Responsible for scheduling the workflow based on the nightly load.
• Supported Oracle 9i databases running mission critical 24*7 systems.

Environment: Informatica Power Center 8.6.1, Oracle 9i, SQL, HP/UX, Erwin Data Modeler, SFTP, Windows XP.

Confidential

ETL Developer

Responsibilities:

• Designed & developed ETL processes based on business rules, job control mechanism using Informatica Power Center 7.1.
• Re-engineered on existing Mappings to support new/changing business requirements.
• Used Mapping, Sessions Variables/Parameters, and Parameter Files to support change data capture and automate workflow execution process to provide 24x7 available data processing.
• Tuned SQL Statements, Mappings, Sources, Targets, Transformations, Sessions, Database, Network for the bottlenecks, used Informatica parallelism options to speed up data loading to target.
• Extensively worked on Expressions, Source Qualifier, Union, Filter, Sequence Generator, sorter, Joiner, Update Strategy Transformations.
• Developed SFTP/FTP re-usable processes to pull the files from External Systems.
• Developed Informatica Mappings to populate the data into dimension and Fact tables for data classifications to end developers.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions and workflows.
• Created synonyms for copies of time dimensions, used the sequence generator transformation type to create sequences for generalized dimension keys, stored procedure transformation for encoding and decoding functions and Lookup transformation to identify slowly changing dimensions (SCD).
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, and Update Strategy for Designing and optimizing the Mapping.
• Created various tasks like Pre/Post Session, Command, Timer and Event wait.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Prepared SQL Queries to validate the data in both source and target databases.
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache, and Persistent Cache.
• Prepared the error handling document to maintain the error handling process.
• Validated the Mappings, Sessions & Workflows, Generated & Loaded the Data into the target database.
• Monitored batches and sessions for weekly and Monthly extracts from various data sources to the target database.

Environment: Informatica Power Center 7.1.2, Oracle, Mainframe, DB2, COBOL, VSAM, SFTP, SQL, PL/SQL

Confidential

Data warehouse/ETL Developer

Responsibilities:

• Involved in the requirement definition and analysis in support of data warehousing efforts.
• Involved in Designing the Data warehouse using Informatica ETL tool by using Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet and Transformations.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements into ETL procedures.
• Developed almost all Transformations such as Filter, Aggregator, Expression, Router, Lookup, Joiner, Update Strategy and Rank.
• Extensively involved in Performance Tuning issues.
• Involved in Creating tasks, Worklets, workflows and Schedule, Run, Monitor sessions by using workflow manager and workflow monitor.
• Migrated Mappings, Sessions and Workflows from Development to Test and then to Production environment.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues.
• Involved in developing ad-hoc and business reports according to the requirement.

Environment: Informatica Power Center 7.1.2, Oracle, SQL loader, UNIX, Windows NT

Confidential

Outbound Customer Care Executive

Responsibilities:

• Supporting Client and Customer with their requirements.
• Making calls to customers and identifying customer needs.
• Presenting appropriate company product and service offerings.
• Ability to gain customer trust and provide exceptional follow-up.
• Forwarding the queries of customers to concern department.
• Explain the status offers & features of the different cards and loans.
• Raising the ticket for the issues regarding bills and payments.

Confidential

Inbound Customer Care Executive

Responsibilities:

• Supporting Client and Customers with their requirements.
• Receiving calls from customers with a target of 180 calls per day.
• Handling queries and complaints of the customers and provide them solutions.
• Solving the queries of customers in supporting the client.