SUMMARY

• 8+ years of IT experience with special emphasis on Analysis, Design, Development and Testing of ETL methodologies in all the phases of the Data Warehousing.
• Strong ETL experience using Informatica Power Centre 9.5.1/9.1.0/8.6.1 (Repository Manager, Designer, Workflow Manager, Workflow Monitor), Mappings, Mapplets, Transformations and worklets.
• Extensive experience in Extraction, Transformation and Loading (ETL) of data from multiple sources into Data Warehouse and Data Mart.
• Well versed with Star - Schema & Snowflake schemas for designing the Data Marts.
• Experience in database design, entity-relationship modeling and dimensional modeling.
• Extensive work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading using Informatica.
• Extensive experience in implementation of transformations, shell Scripts, Stored Procedures and execution of test plans for loading the data successfully into the targets.
• Experience in working withQuality Centerto document test cases and track defects.
• Designed, Developed and Deployed UNIX shell scripts.
• Experience in all phases of SDLC including Requirements Gathering, Design, Development, Unit Testing, On-going support and Maintenance.
• Experience in Developing detailed ETL specifications based on business requirements.
• Exposure in informatica server configuration.
• Experience in Migrating repositories and connections to different environments and worked on complex flat files using logic to transform data for mapping.
• Experience in basic informatica admin activities.
• Experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
• Excellent communication skills, good organizational skills, self-motivated, positive attitude, ability towork independently or co-operatively in a team.
• Exposure on OBIEE reporting tool.
• Extensive experience in Oracle 11g/9i/10g, SQL Server 2005/2008 and Mainframe DB2.
• Excellent with PL/SQL Stored Procedures, Packages, Database Triggers, materialized Views.
• Expertise in implementing complex Business rules by creating mappings, mapplets, reusable transformations, and Partitioning.
• Experience in source systems analysis and data extraction from various sources like Flat files, ORACLE 11g/10g, SQL Server and XML files.
• Proficient in using Informatica workflow manager, workflow monitor, server manager
• Involved in the Performance/ Query tuning. Generation /interpretation of explain plans and tuning SQL to improve performance.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Experience in creatingUnit Testcases and development of testing methods and test logs, which are used for QA team and validate loaded data to ensure data quality.
• Detail oriented with good problem solving, organizational, analysis and requirement gathering skills. Self-motivated and able to work independently and in groups.
• The Real Challenging Phase of Data warehouse i.e. working with the Dimensional Load for the Fact Table by understanding the Dimensional Data Modeling at the functional level.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5.1/9.1/8.6.1/8.6/8.5/8.1/8.0/ Repository Manager, Source Analyzer, Designer, Server manager, Work Flow Monitor Mapplet Designer, Mapping Designer, Workflow Manager

Data Modeling: Star Schema Modelling, Snow Flake Modelling

Databases: Oracle 11g/10g/9i/8i,Mainframe DB2, MS SQL Server 2005/2000, DB2, Teradata, Netezza4.6.8,SQL Server 12.0/11.x

Languages: SQL, PL/SQL, TOAD, UNIX Shell Scripting, MLOAD, TPT, TPUMP, Fast Load, Fast Export, XML

Tools: Microsoft Office - Word, Excel, Access, Visio, PowerPoint, SQL* Plus, Autosys, SQL Navigator, TOAD, ISQL, AppWorx

Operating Systems: Windows 2003/2000/NT/XP, AIX, UNIX

Reporting Tools: OBIEE, Micro Strategy 8.2,Cognos

PROFESSIONAL EXPERIENCE

Confidential, MA

Sr ETL Developer / Informatica Developer

Responsibilities:

• Develop, design and analyze complex data extract, transform and load (ETL) programs in a data warehouse environment.
• Develop ETL mappings, transformation, define workflows and task, monitor sessions using Informatica Power Center.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup & Expression transformation, Expressions and Sequence Generator for loading the data into target table.
• Assist with the monitoring, maintenance and sustainability of Enterprise Data Warehouse (EDW) implementation.
• Provided technical support services to ETL and Data warehouse team.
• Involved in coding, testing, implementing, debugging and documenting the complex programs
• Wrote the shell scripting for accessing the flat files from the FTP location and archiving the files.
• Responsible for the up gradation of Informatica from 9.1 to 9.5.1 version and extensively done the testing.
• Understand the business needs and designs programs and systems that match the complex business requirements and records all the specifications that are involved in the development and coding process.
• Extensively used an Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Involved in the testing the ETL modules, plans, deploys and tests the ETL mappings etc., to ensure that the clients remain satisfied.
• Identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Created unit test plans andETLcode documentation
• Worked on the production area using Informatica tools to move maps from development to system test environments.
• Provided excellent support during QA/UAT testing by working with multiple groups
• Manage and perform data load during the UAT process, Participate and contribute in the enhancements, design discussions (result of UAT feedback) plan and complete the initial data load Production after Prod migration.
• Worked with Session Logs and Workflow Logs for Error handling and troubleshooting in DEV environment.
• Worked with Business Managers, Analysts, Development, and end users to correlate Business Logic and Specifications for ETL Development.
• Worked as team lead for Offshore and Coordinate with the team, to ensure support tickets are resolved in a timely manner through the remedy system and ensure quality code is delivered to the client on time.
• Worked with Reporting team to build tables to optimize reporting performance
• Assist with project management and provide technical leadership to in corporate new aspects of the EDW implementation as the needs arise.
• Interacted with client to make necessary modifications to the existing reports.
• Ensure the quality of the deliverables by planning one to one and peer reviews
• Provide weekly status report on support tasks, monthly reports and metrics for monitoring and support initiatives and quarterly reviews on existing processes and recommended improvements to Confidential Management.

Environment: Informatica Power Center 9.. 5.1/9.1, UNIX, Windows server 2003, Windows server 2008 R2, Cygwin, Unix shell programming, Oracle 11g/10g,AppWorx, SQL, PL/SQL, TOAD.

Confidential, Nashua, NH

Senior ETL Developer / Informatica Developer

Responsibilities:

• Studied the existing environment and accumulating the requirements by querying the Clients on various aspects.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Used informatica power center 9.1 to Extract, Transform and Load data into Data Warehouse from various sources like Oracle and flat files.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router etc., transformations to implement complex logics while coding a mapping
• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Created Logical & Physical models and used ER win for data modeling and Dimensional Data Modeling.
• Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
• Used version mapping to update the slowly changing dimensions to keep full history to the target database
• Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informatica debugger to identify issues in mapping execution.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
• Involved in the development of Informatica mappings and also performed tuning for better performance.
• Extensively worked on tuning (Both Database and Informatica side) and there by improving the load time.
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Created and Scheduled sessions & Worklets using workflow Manager to load the data into the Target Database
• Automated the entire processes using UNIX shell scripts.
• Monitored sessions that were scheduled, running, completed or failed.
• Perform debugging and tuning of mapping.
• Prepared migration document to move the mappings from development to testing and then to production repositories. Designed and developed various kinds of reports based on user requirement.
• Maintained outstanding relationship with Business Analysts and Business Users to identify information needs as per business requirements.
• Attended daily status call with internal team and weekly calls with client and updated the status report.

Environment: Informatica Power Center 9.1/8.6, Windows NT, Oracle 9i/10g, DB2, SQL, PL/SQL, XML, TOAD, OBIEE.

Confidential, Scranton, PA

Sr ETL Developer / Informatica Developer

Responsibilities:

• Working with the Data Warehouse Architect to perform source system analysis and identification of key data issues via analysis of the data profiling results and queries Assistance in the creation of ETL design specifications.
• Involved In On-site/ Offshore coordination.
• Involved in direct discussion with the Functional/End-Users to study the system requirement and develop Functional and Technical specifications to meet their requirements.
• Involved in Sql scripts Macros, stored procedures in Teradata to implement business rules.
• Understanding existing business model and customer requirements. Used Source Analyzer and Warehouse Designer to import the source and target database schemes, and the mapping designer to map source to the target.
• Worked with Informatica Power Center client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
• Development of Informatica mappings, mapplets, workflows and worklets.
• Worked with various look up cache like Dynamic Cache, Static Cache, Persistent Cache, Re Cache from database and Shared Cache.
• Design and development error handling processes.
• Worked on Data Profiling, Cleansing, Matching, Reporting and Monitoring of data quality
• Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer.
• Extensively used expression, lookup, sequence generator, update and router transformations.
• Create and Monitor the sessions using workflow manager and workflow monitor.
• Configured session properties and target options for better performance.
• Configured sessions with email when failure, command task and decision task.
• Defined the program specifications for the data migration programs, as well as the necessary test plans used to ensure the successful execution of the data loading processes.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Perform debugging and tuning of mapping.
• Interacted with client to make necessary modifications to the existing reports.
• Tested all applications and transported data to target Warehouse tables, schedule and run extraction and load process and monitor sessions and batches by using Informatica Workflow Manager.
• Working with business partners to review prototypes and develop iterative revisions.
• Analyzed/modeled current information flows and recommended solutions.
• Participated in testing in preparation of test plans and test cases to ensure the requirements are testable.

Environment: Informatica Power Center 8.6, Auto Sys, HP UNIX, Windows NT, Oracle 9i/10g, Teradata, SQL, PL/SQL.

Confidential, Atlanta, GA

Sr ETL Developer / Informatica Developer

Responsibilities:

• Interacted with Business Analyst / Line of Business and translate business requirements into Technical design specification.
• Created data modeling for staging area as well as Data warehouse (Star Schema and Snow Flake Schema) database.
• Data from Operational Source System is extracted and loaded into data warehouse Using Teradata.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads
• Identifies, researches, and resolves ETL root cause of production issues or system problems.
• Imported Metadata from Teradata tables.
• Responsible for upgrade Informatica from 8.1 to 8.5
• Performance tune ETL programs, Maintenance and enhancements of ETL code.
• Taken part of Informatica administration. Migrated development mappings to production environment.
• Involved in gathering and documenting business requirements from end clients and translating them into report specifications for the MicroStrategy platform.
• Validated report results with the source data and sanctioned the reports to production environment.
• Used Informatica designer for designingmappings and mappletsto extract data fromSQL Server, Sybase and Oracle sources.
• Worked on Teradata SQL Assistant querying the source/target tables to validate the BTEQ scripts.
• Responsible for preparing test cases and technical unit testing for the developed reports.
• Written SQL overrides in source Qualifier according to business requirements.
• Interacted with client to make necessary modifications to the existing reports.
• Created and Developed re-usable transformations, mappings and mapplets confirming to the Interacted with client to make necessary modifications to the existing reports.
• Responsible for to analyze and apply new requirements to existing reports.
• Continuously monitor the accuracy of the data and the content of the delivered reports.
• Responsible for to provide production support and resolve issues.
• Designed and developed a strategy for a specific and vital reporting need. Emphasis was on a design to support current and historic reporting. Data loading mappings were developed in Informatica.

Environment: Informatica 7.x, Oracle, Flat files, Teradata, Micro Strategy, Autosys, Oracle 9i, DB2, SQL server, PL/SQL.

Confidential, Waukesha, WI

ETL Developer / Informatica Developer

Responsibilities:

• Designed and implemented ETL using Informatica from source ERP
• Involved in Analysis, requirements gathering, technical specification, development, deploying and testing.
• Worked on Informatica Power Center 7.1.1 tool - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformations.
• Extracted data from various heterogeneous sources like DB2, SQL Server, and Flat Files.
• Worked with Informatica Power Center client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
• Worked with Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Developer, and Mapping Designer.
• Various kinds of the transformations were used to implement simple and complex business logic. Transformations used are: stored Procedure, connected & unconnected lookups, Router, Expressions, source qualifier, aggregators, filters, sequence Generator, etc.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Worked extensively on Oracle database 9i and flat files as data sources.
• Performed integrated testing for various mappings. Tested the data and data integrity among various sources and targets.
• Generated various kinds of reports (Daily, monthly etc) in Cognos ReportNet.
• Responsible for creating Ad hoc reports for business users.
• Scheduled and distributed reports through schedule management in Cognos Connection maintaining files through file management.
• Developed standard templates. Developing standard reports, charts, drill through reports, master detail reports, bursting reports and multilingual reports using Report Studio and Query Studio.
• Experience of using 3rd party scheduler tool like Autosys
• Created Power Play cubes using Transformer.
• Migrated and Developed Master Detail Reports and List Reports using Report Studio.
• Integrated the reports to Web and customized the rights to user.
• Wrote SQL Statement, Database Triggers, Stored Procedures and Views using SQL Server 2000.
• Extracting, Transforming and Loading the data from Source to Staging and Staging to Target according to the Business requirements.
• Designed and Created data cleansing, validation and loading scripts for Oracle data warehouse using Informatica ETL tool.

Environment: Informatica Designer, Informatica Server Manager, Informatica Repository Manager, SQL Server 2000, Teradata, UNIX AIX, Oracle 9i,Cognos

Confidential

Data Warehouse Developer

Responsibilities:

• Involved in design & development of operational data source and data marts in Oracle
• Reviewed source data and recommend data acquisition and transformation strategy
• Involved in conceptual, logical and physical data modeling and used star schema in designing the data warehouse
• Designed ETL process using Informatica Designer to load the data from various source databases and flat files to target data warehouse in Oracle
• Used Power mart Workflow Manager to design sessions, event wait/raise, and assignment, e-mail, and command to execute mappings
• Created parameter based mappings, Router and lookup transformations
• Created mapplets to reuse the transformation in several mappings
• Used Power mart Workflow Monitor to monitor the workflows
• Optimized mappings using transformation features like Aggregator, filter, Joiner, Expression, Lookups
• Worked extensively on Oracle database 9i and flat files as data sources.
• Performed integrated testing for various mappings. Tested the data and data integrity among various sources and targets.
• Created daily and weekly workflows and scheduled to run based on business needs
• Created Daily/weekly ETL process which maintained 100GB of data in target database
• Created complex stored procedures/functions/triggers/query tuning in MS Access 97

Environment: Oracle, Web logic server, XML, JSP, JavaScript, EJB, Windows NT, Informatica Power Center 5.1, Oracle 8i, Erwin, Cognos 6.5 (Impromptu), Erwin 3.5, Responsible for requirement analysis of the application