SUMMARY

• Over 9 years of experience in Information Technology with a strong background in Database development and Data warehousing and ETL process using Informatica Power Center 9.x/8.x/ 7.1.3/7.1.1/6.2. Repository Manager, Repository Server, Workflow Manager & Workflow Monitor.
• Experience working with Power Center Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Proficiency in developing SQL with various relational databases like Oracle, SQL Server.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Strong understanding of OLAP and OLTP Concepts.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Proficient in Oracle Tools and Utilities such as TOAD and SQL*Loader.
• Experience in SQL performance tuning.
• Efficient in creating SSIS Packages. Created packages to extract data from flat files, TeraData, Oracle and DB2 and transform the data according to the business requirements and load the data in SQL server tables.
• Experience in maintaining Data Concurrency, Replication of data.
• Thorough Knowledge in creating DDL, DML and Transaction queries in SQL for Oracle database.
• Performed SAP Data Migration by using Business Objects Data Services as the ETL tool.
• Experience in using SQL developer, SQL*Plus, Procedures/Functions and Performance tuning.
• Extensive experience with Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Normalizer, Union and XML Source Qualifier.
• Responsible for the Data Cleansing of Source Data using LTRIM and RTRIM operations of the Expression Transformation.
• Expertise in RDBMS concepts, with hands on exposure in the development of relational database environment using SQL, PL/SQL, Cursors, Stored Procedures, Functions and Triggers.
• Experience in working with Perl Scripts for handling data coming in Flat files.
• Experience working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files.
• Strong with relational database design concepts.
• Extracted data from various heterogeneous sources likeOracleandSAP.
• Used Teradata Utilities like fast load, multi load and fast export.
• Performed data validation by Unit testing, integration testing and System Testing.
• Extensive experience in managing teams/On Shore - Off Shore Coordination/Requirement Analysis/Code reviews/Implementing Standards.
• Experienced in performing Incremental Loads and Data cleaning in SSIS. Expert in handling errors, logging using Event Handlers using SSIS.
• Experience with managing ODBC connections.
• Good experience with Informatica Performance Tuning.
• Good knowledge of Data modeling techniques like Dimensional/ Star Schema, Snowflake modeling, slowly changing Dimensions using Erwin.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
• Able to work independently and collaborate proactively & cross functionally within a team.
• 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.

TECHNICAL SKILLS

Tools: Informatica Power Center 9.6/9.5/9.1, 8.6.1/8.5/8.1.1, Power Exchange 9.6/9.5/9.1/8.6, Informatica IDQ,Informatica Data Replication Console,SSIS, Talend.

Databases: Oracle 11g/10g/9i, MS SQL Server 2008/2012, MS Access, DB2, Teradata 14/13/12/V2R6, V2R5, Sybase, Control-M.

Reporting Tools: Business Objects XIR2, SAP BI 7.0, OBIEE 11g/10g

Languages: C, C++, SQL, PL/SQL, HTML, PHP, JAVA, UNIX Scripting

Other Tools: Toad, Harvest, SCM, Putty, Tidal, Autosys, ESP,Informatica MDM Hub Console, Informatica Hierarchy Manager (HM).

Operating Systems: LINUX, SUN Solaris, Windows7/XP/2000/98

PROFESSIONAL EXPERIENCE

Confidential, CA

ETL/Informatica Tech Lead

Environment: Informatica Power Center 9.6.1/9.5.1, (Repository Manger, Designer, Server Manager, Workflow Monitor, SQL Server Integration Services(SSIS), Workflow Manager) Erwin 4.5, RDBMS, Oracle, 11g10g/9i, PL/SQL, Toad, UNIX scripting,Windows XP.

Responsibilities:

• Extensively used Informatica Client tools - Power Center Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Developed complex mapping using Informatica Power Center tool and configured Informatica with DAC.
• Extracting data from Oracle and Flat file, Excel files and performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
• Used concept of staged mapping in order to perform asynchronous Web Services request and response as part of Informatica Mappings.
• Working with various sources such as Flat files, Relational, XML and Web services as part of Informatica Mappings.
• Highly skilled in creating dynamic and customized packages for ETL from various data sources using SSIS.
• Extracted the data from various data source systems into the Landing Zone area by creating the Informatica mappings using the Teradata fast Loader Connections.
• Designed SQL Server Integration Services (SSIS) packages to extract data from JDE to SQL Server Data Warehouse following the JDE specs and SQL Server standards.
• Designed Mappings using B2B Data Transformation Studio.
• Extensively used Informatica Client tools - Power Center Designer Cloud, Work flow Manager, Work flow Monitor and Repository Manager
• Developed complex mapping using Informatica Power Center Cloud.
• Created Sessions, Tasks, Workflows and worklets using Workflow manager.
• Worked with Data modeler in developing STAR Schemas
• Involved in performance tuning and query optimization.
• Experience in converting SAS scripts to Informatica.
• Worked on utilities like FLOAD, MLOAD, FEXP of Teradata and created batch jobs using BTEQ.
• Extracting data from Oracle and XML,SAP, MS SQL, Confidential -SQL and performed Delta mechanism using Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategy transformations to load data into the target systems.
• Responsible for Configuration and administration of Meta data Manager.
• Used TOAD, SQL Developer to develop and debug procedures and packages.
• Involved in developing the Deployment groups for deploying the code between various environment (Dev, QA).v
• Experience developing and supporting complex DW transformations.
• Build OBI Metadata Repository (.rpd) using OBIEE Administrator tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool.
• Developed physical and logical star schema using OBIEE administration tool.
• Excellent understanding of Star Schema Data Models; Type 1 and Type 2 Dimensions.
• Created pre sql and post sql scripts which need to be run Confidential Informatica level.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, XML,XSD’s,Flat Files, Teradata.
• Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Monitored and improved query performance by creating views, indexes, hints and sub queries
• Extensively involved in enhancing and managing Unix Shell Scripts.
• Developed workflow dependency in Informatica using Event Wait Task, Command Wait.

Confidential, CA

Sr. ETL/ Informatica Developer

Responsibilities:

• Identified data source systems integration issues and proposing feasible integration solutions/
• Partnered with Business Users and DW Designers to understand the processes of Development Methodology, and then implement the ideas in Development accordingly.
• Worked with Data modeler in developingSTARSchemas andSnowflakeschemas
• Responsible for the design, development and implementation of dynamic SSIS packages for ETL (extract, transform, and load) development following company standards and conventions.
• Created Oracle PL/SQL queries and Stored Procedures, Packages,Triggers, Cursorsand backup-recovery for the various tables.
• Identifying and tracking theslowly changing dimensions (SCD).
• Extracting data fromOracle and Flat file, Excel filessources and performedcomplex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformations and Update strategytransformations to extract and load data into the target systems.
• All SSIS standards are followed to maintain reliability and scalability in the extraction.
• Created reusableMailing alerts, events, Tasks,Sessions,reusable worklets andworkflowsin Workflow manager.
• Created UNIX shell scripts for Informatica ETL tool to automate sessions.
• Scheduled the workflows Confidential specified frequency according to the business requirements and monitored the workflows using Workflow Monitor.
• Worked on the script components in SSIS using VB script for getting latest files and ETL logging areas.
• Fixinginvalid Mappings,Debuggingthe mappings in designer,Unit and Integration Testingof Informatica Sessions, Worklets and Workflows.
• Extensively usedTOADfor source and target database activities.
• Involved in the development and testing of individualdata marts, Informatica mappings and update processes.
• Worked on data cleansing by creating SSIS packages against the Flat Files.
• Created repository, users, groups and their privileges using Informatica Repository Manager.
• Involved in writing UNIX shell scripts for Informatica ETL tool to run theSessions.
• Generated simple reports from the data marts usingBusiness Objects.

Environment: Informatica Power Center 8.6.1, Oracle 10g, Power Exchange 8.6, MS SQL Server 2008, UNIX(Sun Solaris5.8/AIX), SSIS, SSRS, UltraEdit-32, Data Marts, Erwin Data Modeler 4.1, FTP, MS-Excel, MS-Access, IDQ, DB2, UNIX Shell Scripting, Data Modeling, PL/SQL, Autosys

Confidential, Norwood, MA

Informatica Developer

Responsibilities:

• Extracted data from various heterogeneous sources like Oracle, SQL Server, MS Access and Flat files.
• Experience on working with complete Software Development Life Cycle of the application.
• Involved in monitoring and maintenance of the Unix Server performance.
• Involved in creating database tables, views, triggers.
• Worked with PL / SQL to create new stored procedures and also modify the already existing procedures as per the change requirements from users.
• Created many PL/ SQL batches and executed them through Unix Shell scripts.
• Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• 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 Workflow logs for Error handling and troubleshooting in Dev environment.
• Optimized SQL queries for better performance.
• Created pre SQL and post SQL scripts which need to be run Confidential Informatica level.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.

Environment: Informatica Power Center 8.6, Oracle 10g, PL/SQL, PL/SQL Developer, MS Access, Data Flux, BPM (Business Process Management), Win CVS, Window XP, DB2, UNIX

Confidential

Application ETL Developer

Responsibilities:

• Responsible for design and development of Sales Data Warehouse.
• Worked with Business Analyst and application users to finalize Data Model, functional and detailed technical requirements.
• Extracted data from heterogeneous sources like Oracle, SQL Server
• Created detailed Technical specifications for Data Warehouse and ETL processes.
• Conducted a series of discussions with team members to convert Business rules into Informatica mappings.
• Used Transformations like Look up, Router, Filter, Joiner, Stored Procedure, Source Qualifier, Aggregator and Update Strategy extensively.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• CreatedMapplets and used them in different Mappings.
• Involved in doing error handling,debugging and troubleshooting Sessions using the Session logs, Debugger and Workflow Monitor.
• Monitoring the Data Quality, Generating weekly/monthly/yearly statistics reports on production processes - success / failure rates for causal analysis as maintenance part and Enhancing exiting production ETL scripts.
• Worked with SAP and Oracle sources to process the data.
• Worked on SAP for data migration Human Resources and Finance and converted various objects on Organizational Structure, Addresses, Time, Basic Pay, Bank Details, Recurring Payments, Tax assignment, Insurance Plans, Payroll etc., to generate report from SAP BI system.
• Worked with Pre and Post Session SQL commands to drop and recreate the indexes on data warehouse using Source Qualifier Transformation of Informatica Power center.
• Created Unix Shell Scripts to automate sessions and cleansing the source data.
• Implemented pipeline partitioning concepts like Round-Robin, Key-Range and Pass Through techniques in mapping transformations.
• Involved in Debugging and Performance tuning of targets, sources, mappings and sessions.
• Worked on the data masking activities for cloning the GDW for several buyers

Environment: Informatica Power Center 8.6, Oracle9i,Teradata v2r6, SAP, SAP BI 7.0, SQL Server, Sun Solaris.

Confidential

ETL Developer

Responsibilities:

• Creating dimensions and facts in the physical data model.
• Involved in designing the Data Mart model with Erwin using Star Schema methodology.
• Used aggregate, expression, lookup, update strategy, router, and rank transformation.
• Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.
• Created ftp connections, database connections for the sources and targets.
• Loading Data to the Interface tables from multiple data sources such as MS Access, SQL Server, Text files and Excel Spreadsheets using SQL Loader, Informatica and ODBC connection.
• Wrote stored procedure to check source data with Warehouse data if it not present written that records to spool table and used spool table as Lookup in Transformation.
• Implemented Variables and Parameters in Transformations to calculate billing data in billing Domain.
• Modified the existing batch process, shell script, and Pl/Sql Procedures for Effective logging of Error messages into the Log table.
• Generated weekly and monthly report Status for the number of incidents handled by the support team.
• Improved Performance of the workflows by identifying the bottlenecks in targets, sources, mappings, sessions.
• Designed a mapplet to update a slowly changing dimension table to keep full history which was used across the board.

Environment: Oracle 9i, Shell Scripting, TOAD for SQL, TOAD, UNIX, Windows NT, Windows 2000.