SUMMARY

• Over 8 years of total IT experience and technical proficiency in building Data warehouses, Data Marts, Data Integration, Operational Data Stores and ETL Processes for clients in major industry sectors like Health, telecom, and finance.
• Strong Data Warehousing ETL experience of using Informatica 9.6/9.5/9.1/8.6.1/7.1/6.2/6.0/5.1 - Power Center Client tools - Designer, Repository manager, workflow manager/monitor and Server tools - Informatica Server, Repository Server manager.
• Extensively worked with large Databases in Development, Testing and Production environments.
• Experience with advanced ETL techniques including staging, reusability, data validation, change data Capture (CDC), Real time
• Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Expertise in Data Warehouse/Data mart, ODS, OLAP and OLTP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using Erwin, MS Visio.
• Extensively worked on Data Cleansing, Data Profiling, and Data Quality using Informatica Products.
• Strong Working Experience of Informatica Repository Administrator console, Repository Manager, Workflow Manager and Designer.
• Expertise in using various Active/Passive transformations like Joiner, Expression, -Aggregate, Filter, Router, normalizer, Update Strategy, Sequence Generator, Source Qualifier and Stored Procedure transformations,mapplets,connected/unconnected Lookups/procedures
• Designed and Implemented Workflows, Worklets and various tasks like Session, Email, Command, Control, Event & Timer for Incremental and Historical data loads using InformaticaPowerCenter, Unix shell scripts, Control-M, Autosys, ESPX etc.
• Extensive experience in handling multiple data sources including Internal, External and from third party sources.
• Proficient in working on relational database management systems and extensively worked on Data extraction, transformation, loading with Oracle 11g/10g/9i/8i, MS SQL server 2005/2008/2012 , Teradata 14/13/12 and DB2 UDB 9.5 and also extracted data from XML, Flat Files.
• Good Knowledge in Data Warehousing concepts, Teradata Utilities (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD).
• Used Teradata Queryman and Query Analyzer to check the data consistency in the tables and for performing Adhoc Queries.
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
• Experience in managing the project in Onsite/Offshore model.
• Ability to handle multiple tasks and work independently as well as in a team.
• Have Strong analytical skills with ability to follow project standards and decision-making capability.
• Exceptional ability to quickly master new concepts and applications.
• Self-motivated and have excellent Communication and interpersonal skills.

TECHNICAL SKILLS

ETL/Data Modeling Tools: Informatica Power Center 9.5/9.1/8.6/8.1.1/7. x/6.x(Designer, Work flow Manager &Work Flow Monitor) Power Mart 6.2/5.1/4.7 Power Connect and Power Exchange,Ascential Data Stage, ERwin r8.x/r7.x/4.x. Dimensional Data Modeling(Star Schema Modeling, Snowflake Schema Modeling, FACT and Dimensions Tables), Informatica MDM Multi-Domain.

BI/OLAP Tools: Business Objects XI/6.5,Cognos8 BI, ReportNet1.1/1.0 (Report studio, Query studio, Analysis studio, Framework Manager), Cognos EPSeries5.2/6.0/7.x (Impromptu,Powerplay,PowerPlay Transformer)

Databases: Oracle 11i/10g/9i/8i,MS SQL Server 2008/2005/2000 , DB2, MS Access 2003,Transact SQL,Teradata V2R5/V6/V12/V13/V14, DB2 UDB, MS-SQL Server 2000/2005/2008 , Sybase 10,My SQL and MS-Access

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

Operating Systems: Windows 2010/2007/2003/2 K/XP/NT//98, IBM AIX 5.1, HP Unix

Packages/ Other: Toad 11.6/12.0/8.6.1/8.5.3 SQL * Loader,Teradata SQL Assistant, SQL Query Analyzer, Enterprise Manager, MS Office, lotus 123,EXCEL CNTRL M,Autosys, Tivoli & TFS, SQL developer

PROFESSIONAL EXPERIENCE

Confidential, Tampa, Florida

Sr. ETL/Informatica Developer

Responsibilities:

• Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Extensively worked on Power Center 9.1 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Worked on Teradata and oracle 11g databases.
• Develop and execute load scripts using Teradata client utilities MULTILOAD, FASTLOAD and BTEQ.
• Extensively worked on Transformations like Lookup, Joiner, SQL and Source Qualifier Transformations in the Informatica Designer.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Modify and develop new ETL programs, transformations, indexes, data staging areas, summary tables, and data quality routine based upon redesign activities.
• Worked Extensively on Teradata SQL Assistant to analyze the existing data and implemented new business rules to handle various source data anomalies.
• Worked on performance tuning of the ETL processes. Optimized/tuned mappings for better performance and efficiency.
• Defined Target Load Order Plan and to load data correctly into different Target Tables.
• Used Informatica debugger to test the data flow and fix the mappings.
• Loaded data to and from Flat files and databases like Oracle, Teradata and DB2.
• Modified existing and developed new ETL programs, transformations, indexes, data staging areas, summary tables, and data quality routine based upon redesign activities.
• Moved the mappings, sessions, workflows, maplets from one environment to other.
• Worked on UNIX Shell scripting and called several shell scripts using command task in Workflow manager.
• Developed UNIX Shell scripts to archive files after extracting and loading data to Warehouse.
• Used Informatica Power exchange 9.1 for Change Data Capture(CDC).
• Monitored sessions using the workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions.
• Involved in Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Involved in Designing, document and configure the Informatica MDM Hub to supportloading, cleansing, matching, merging, and publication of MDM data.

Environment: Informatica Power Center 9.5/9.6, Power Exchange 9.5, Oracle 11g, Teradata 13, Win7, SQL * Plus, Toad, AS 400, UNIX

Confidential, Collegeville, PA

Informatica Developer

Responsibilities:

• The prime responsibility of the team is to develop a Patient Care Data Warehouse (PCDW).
• This data warehouse is used to access detailed clinical data on a platform and also to facilitate the enterprise-wide data analysis within the health care environment.
• Analysis, Design and Development, test and implementation of Informatica transformations and workflows for extracting the data from the multiple legacy systems.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Connected & unconnected lookups, Filter, Router, Sequence Generator, Sorter, Joiner, and Update Strategy.
• Attended meetings to finalize strategies for handling various concepts like Error Handling and Slowly changing dimension
• Troubleshoot problems by checking sessions/error logs in the Workflow Monitor and also used debugger in Mapping Designer to debug complex mappings.
• Performance tuned the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.
• Enhanced performance for Informatica session using large data files by using partitions, increasing block size, data cache size, sequence buffer length and target based commit interval.
• Developed UNIX Shell scripts for data extraction and file transfers.
• Assist operation support team for transactional data loads.
• Performed Unit and System Testing of developed mappings.
• Documented program development, logic, coding, testing, changes and corrections.
• Worked with pmcmd to interact with Informatica Server from command mode and execute the shells scripts
• Used Cognos to generate reports.

Environment: InformaticaPowerCenter 8.6, ERwin, Cognos, Oracle 10g/9i, TOAD, Unix Shell Scripting.

Confidential, CA

Informatica Developer

Responsibilities:

• Interacted with business sponsors and users to analyze the business process and to prepare and publish the deliverables.
• Designed and developed a new process to improve the loading of the TAXL Parsing using Informatica to verify the data to support decision-making and anlysis.
• Participated in all phases such as Business Requirements gathering, technical design,high level design, detail design, specifications, devlopment, review, testing and support.
• Analyzed data issues to provide input to the Technical Review Document during the high level design.
• Designed and documented the data flow from different souces to targets validating the business rules and error conditions.
• Performed technical data analysis, design and development for multiple transactional and warehousing initiatives.
• Working on Informatica Power Center tool-Source Analyzer, Warehouse designer, Mapping and Mapplet Designer, Transformations, Informatica Repository Manager andInformatica Workflow Manager.
• Experience in extracting data from wide range of sources such as flat files, ORACLE, DB2, VSAM, EXCEL, and XML.
• Developed PL/SQL packages consist of procedures, functions, and error handling to load the data.
• Scheduled Informatica workflows (daily, weekly and/or monthly based on the requirement) using DIS Scheduler.
• Created complex Informatica mappings to load the data mart and monitored them.
• The mappings involved extensive use of transformations like Aggregator, Filter, Router, Expression, Joiner, Sequence generator.
• Developed ETL processes for loading the warehouse and backend data retrieval logic for ad-hoc querying and batch reporting.
• Implemented performance tuning techniques so as to increase the performance of the loading process in nightly batch runs.
• Setting up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager and DIS Scheduler.
• Extensively used the debugger in Informatica Power Center Designer to debug and fix any logical errors in the connections between the transformations in the mappings.

Environment: Microsoft SQL Server 2000/2005/2008 , Windows NT, 2000, XP, Microsoft IIS, SSRS, Integration Services, Informatica Power Center 8.1.1, ETL, DIS Scheduler.

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Worked with power center tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Worked on Designer tools like Source Analyzer, Warehouse Designer, Debugger, Transformation Developer, Mapplet Designer and Mapping Designer.
• Implements reporting and analytics projects aligned with overall Business Objects vision.
• Extensively used Informatica Transformation for most optimized mapping and faster performance on server.
• Optimization through SQL Override to avoid bottle-neck on Source Qualifier.
• Solid Expertise in using both connected and unconnected Lookup Transformations.
• Unconnected Look-up for more than 1 pipe in a mapping, to avoid large volumes of data buffer on Server.
• Used dynamic look-up for an incremental load process, for optimized load performance.
• Extensively worked with Joiner functions like normal join, full outer join, master outer join and detail outer join in the Joiner transformation.
• Worked with Session logs and Work flow logs for Error handling and troubleshooting.
• Batching of sessions, for a clean work-flow and making sure dependencies are taken care of in a load process.
• Used Debugger wizard to troubleshoot data and error conditions.
• Responsible for Best Practices like naming conventions, Performance Tuning and mapping document for further reference and knowledge transfer.
• Developed Reusable Transformations and Reusable Applets.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for migration of work-flows and consistency in connectivity.
• Responsible for migrate the code using deployment groups across various Instances.
• Optimized SQL queries for better performance.
• Created pre SQL and post SQL scripts which need to be run at Informatica level.
• Responsible for Unit Testing of Mappings and Workflows.
• Developed Slowly Changing Dimension Mappings for Type 2 SCD.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.

Environment: Informatica Power Center 8.6/ 8.1, windows XP, Oracle 10g, Flat Files, SQL, TOAD.

Confidential, IL

Informatica Developer

Responsibilities:

• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer &Mapplet, and Transformation Developer.
• There were two kinds of data loading processes (Daily and Weekly) depending on the frequency of source data.
• Imported data from various sources transformed and loaded into Data Warehouse Targets using Informatica.
• Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Extensively used Transformations like Router, Aggregator, Source Qualifier, Joiner, Expression, Aggregator and Sequence generator.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Worked with pmcmd to interact with Informatica Server from command mode and execute the shells scripts.
• Worked with different sources such as Oracle, MS SQL Server and flat files.
• Solved common name and address data problems by Informatica Data Quality’s (IDQ) address cleansing and identity matching rules, which reduce project risk and make the quick.
• Knowledge of slowly changing dimension tables and fact tables.
• Writing documentation to describe program development, logic, coding, testing, changes and corrections.
• Optimizing the mappings by changing the logic to reduce run time.

Environment: Informatica Power Center 8.1 (ETL),Oracle 9i, SQL, PL/SQL, SQL*Loader, SQL Navigator, SQL Server 2000, Windows NT/2000, HP-Unix.

Confidential

Informatica Developer

Responsibilities:

• Interacted with business representatives for requirement analysis and to define business and functional specifications.
• Analyzed source data, extracted, transformed, and loaded data in to target data warehouse based on the requirement specification using InformaticaPowerCenter.
• Developed data Mappings between source and target systems using Mapping Designer.
• Worked with various heterogeneous sources such as Oracle10g and Flat Files to load the data into the target Oracle data warehouse.
• Developed complex Informatica mappings using Filter, Sorter, Aggregator, Look up, stored procedure, Joiner, Router transformations for populating target table.
• Written PL/SQL stored procedures in Oracle and used in mapping to extract the data.
• Used debugger to test the mapping and fixed the bugs and identified the bottlenecks in all levels to tune the performance.
• Worked with Workflow Manager Tasks such as Email, Command, Event raise, Event wait, Decision, Assignment.
• Supported post-production maintenance.
• Worked on SQL tools like TOAD to run SQL queries to validate the data.
• Analyzed the session, event and error logs for troubleshooting mappings and sessions.
• Developed schedules to automate the update processes and Informatica sessions and batches.

Environment: InformaticaPowerCenter 8.0 and PowerExchange/PowerConnect, TOAD,Oracle 10g, SQL, PL/SQL, Flat files, TOAD 7.3, Erwin, UNIX, Shell scripts, Windows NT.