SUMMARY

• Over 8 years of experience with wide range of exposure to Database development, Data Warehousing and ETL methodologies using Informatica Power Center 8.6.1/9.0.1/9.5.1.
• Extensively worked on Informatica Designer components (Source Analyzer, Warehouse Designer, Mapping Designer, Metadata Manager, Mapplet Designer and Transformation Developer), Repository Manager, Workflow Manager and Workflow Monitor.
• Strong Experience in integrating data from various Heterogeneous Sources like Oracle, SQL Server, DB2, UDB, Flat Files (Fixed Width and Delimited) into Data Warehouse and Data Mart.
• Knowledge working with Informatica cloud 9.
• Expertise in UNIX shell scripting, file management in various UNIX environments.
• Strong knowledge on Data Warehousing Concepts likeRalph Kimball Methodology, Bill Inmon Methodology, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Slowly changing dimensions, Logical Data Modeling, Physical Modeling and Dimension Data Modeling.
• Well acquainted using Teradata utilities BTEQ, Fast Load, Multi Load, Fast Export, Tpump, SQL Assistant and SQL Administrator.
• 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.
• Good experience with Data Cleansing, Data Analysis, Data Profiling and necessary Test plans to ensure the successful execution of the data loading processes.
• Experience in retrieving tables with Sales force adapter
• Strong at developing complex mappings with Custom Transformations, XML Sources and Debugging Mappings to Identify performance issues in existing mappings by analyzing the data flow and evaluating transformations.
• Good knowledge in SQL tuning using Hints, Materialized Views.
• Experience in SIT (System Integration Testing) and UAT (User Acceptance Testing).
• Worked on ETL development projects with multiple team members, providing mentoring, technical assistance, troubleshooting and alternative development deployment of the new Telematics capabilities.
• Experience with industry Software development methodologies like Waterfall, Agile within the software development life cycle.
• Good understanding of Business Intelligence tools like Business Objects, Cognos.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Experience working with offshore and onsite co - ordination.

PROFESSIONAL EXPERIENCE

ETL Tools: Informatica 9.x/8.x/7.x/6.x (Power Center/Power Mart/Power Exchange)

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

OLAP Tools: Cognos 7.0/6.0, Business Objects XI R2, SSRS, SSAS

Languages: T-SQL, PL/SQL, Perl, Unix Shell Script, Java, COBOL, XML

Tools: Toad, SQL* Loader, Autosys, TWS(Tivoli)

Operating Systems: Windows 2003/2000/NT, AIX, Sun Solaris, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, North Carolina

Informatica Developer

Responsibilities:

• Extensively worked Teradata utilities BTEQ, Fast Load, Multi Load, Fast Export, SQL Assistant and SQL Administrator.
• Expertise in UNIX shell scripting, FTP, SFTP and file management in various UNIX environments.
• Used Informatica Power Center 9.5 for Extraction, Transformation and Loading data from heterogeneous source systems into the target data base.
• Experience working with Business users and architects to understand the requirements and to pace up the process in meeting the milestone.
• Perform Confidential analysis of the existing process of RRP-verint and designing the solution for automating input and output processes to/from kiran/RRP.
• Designed all the above projects and frameworks and lead the development teams to reach the project timelines within the budget.
• Designed and developed the Informatica processes to send the data to retail web services (RWS) and capturing the response.
• Working with global support technology relationship team to setup VDIs with the required software packages for ETL development for offshore team. On boarding the offshore team with training.
• Effectively communicates with other technology and product team members.
• Work on the performance improved areas. Debug the issues and coming up with the proper solutions which will reduce the process times.
• Created mappings by cleansing the data and populate that intoStagingtables, populating the staging to Archive and then to Enterprise Data Warehouseby transforming the data into business needs & Populating theData Martwith only required information.
• Extensively used Informatica Power Centre tools and transformations such as Lookups, Aggregator, Joiner, Ranking, Update Strategy, Mapplet, connected and unconnected stored procedures / functions / SQL overrides usage in Lookups / Source filter usage in Source qualifiers.
• Created Pre/Post Session and SQL commands in sessions and mappings on the target instance.
• Responsible for Performance tuning at various levels during the development.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Extracted/loaded data from/into diverse source/target systems like SQL server, XML and Flat Files.
• Used stored procedures to create a standard Time dimension, drop and create indexes before and after loading data into the targets for better performance.
• Developed shell scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Responsible for migrating the workflows from development to production environment.
• Worked using Parameter Files, Mapping Variables, and Mapping Parameters for Incremental loading.
• Managed post production issues and delivered all assignments/projects within specified time lines.
• Extensive use of Persistent cache to reduce session processing time.

Environment: Informatica Power center 9.5/8.6.1, Oracle 11/10g, SQL server 2008, LINUX, LSF (Job scheduling), UNIX shell scripting, SAS Enterprise guide and MS Visual studio (TFS) for version control.

Confidential, Sacramento, CA

Informatica Developer

Responsibilities:

• Gathered requirements from Business users and created a Low level technical design documents using high level design document.
• Participated in the Design Meetings, and prepared technical and mapping documentation.
• Extracted data from Salesforce.com (SFDC), Oracle, excel, data files using Informatica ETL mapping/SQL PLSQL scripts.
• Designed, Developed and Supported Extraction Transformation and Load (ETL) Processes usingInformaticaPower Center 8.6 for data migration from source systems into ICD-10 Data warehouse.
• Written Pre and Post Session SQL commands (DDL & DML) to drop and recreate the indexes on data warehouse
• Developed complex Informatica mappings using Unconnected Lookup, Sorter, and Aggregator and Router transformations for populating target table in efficient manner.
• Extensively worked on developing Continuous Change Data (CDC).
• Developed Slowly Changing Dimension Mappings for Type 1 and Type 2.
• Performance tuned the Mappings, Tasks, Sessions, SQL and Scripts to optimize Data-Load performance.
• Used data services for data profiling of sources between SQL Server and Oracle sources.
• Involved in massive data profiling using IDQ (Analyst tool) prior to data staging.
• Developed process for Teradata using Shell Scripting and RDBMS utilities such as MLoad, Fast Load (Teradata).
• Extensively used pmcmd commands on command prompt and executed UNIX Shell scripts to automate workflows and to populate parameter files.
• Provided solution the Data Quality and Data Cleansing tracks for the MDM project.
• Load monitoring the Support Process by failure reporting and failure handling in Teradata.
• Worked on error handling and performance tuning in Teradata queries and utilities.
• Experience in writing Teradata scripts and gave them to DBA’s for implementing in Production database tables.
• Worked in highly structured division across Infra developers/Data Architects (data modeling team)/DBAs/ Change Management etc.
• Conformed to project standards for Unit test/UAT testing. Carried out end - to end testing and supported UAT effort with immediate requirement document change/fixes/resolution for all changes/defects.

Environment: Informatica Power center 8.6/8.1, CDC, Oracle 9i/10g, Teradata, Toad 8.6, Flat Files, UNIX Shell Scripts and Windows 7.

Confidential, NH

ETL Informatica Developer

Responsibilities:

• Experience using Data Warehouse Appliances such as Teradata for data warehousing,business intelligence and Error free Data integration.
• Involved in writing Shell scripts for file transfers, file renaming and several other database scripts to be executed from UNIX.
• Collaborated withBusiness Analystto understand the business and to design the architecture of the data flow.
• Extracted data from various heterogeneous sources like Oracle and SAP.
• Created mappings to perform the tasks such as cleansing the data and populate that intostagingtables, Populating the Enterprise Data Warehouseby transforming the data into business needs & Populating theData Martwith only required information.
• Developed ETL processes for all stages of EDW(Source to staging, Staging to ODS, & ODS to Data mart) and became “go-to” person in organization for any EDW data loading / data availability/ data expertise questions.
• Managed and also actively worked on day to day Production activities.
• Used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Design and Development of ETL routines, using Informatica Power Center within the Informatica Mappings and usage of Lookups, Aggregator, XML, Joiner, Ranking, Mapplet, connected and unconnected stored procedures / functions / SQL overrides usage in Lookups / Source filter usage in Source qualifiers and data flow management into multiple targets using Routers were extensively done.
• Involved in massive data profiling using IDQ (Analyst tool) prior to data staging.
• Created Informatica power center mappings to handle slowly changing dimensions type2 based on the user requirements
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level, and the Target Level.
• Worked with BTEQ to Query, Report and Export the data and produce reports in ETL process.
• Responsible for the Data Cleansing of Source Data using LTRIM and RTRIM operations of the Expression Transformation.
• Worked with re-usable objects like Re-Usable Transformations and Mapplet.
• Responsible for migrating the workflows from development to production environment.
• Worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.
• Used the Command line program to run Informatica jobs from command line and used these commands in shell scripts to create, schedule and control workflows, tasks and sessions.

Environment: Informatica Power Center 8.6/7.1, SAP, Oracle, IBM UDB, DB2, UNIX-AIX, Golden Gate data Replicator, Unix Shell scripting and Teradata Utilities i.e., Multi Load, Fast Load, Fast Export, BTEQ scripting and Atana Suite Enterprise.

Confidential

ETL Informatica Developer

Responsibilities:

• Interacted with business analysts and translate business requirements into technical specifications.
• Designed and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.
• Extensively worked on Informatica to extract data from Flat files, Excel files, and MS Access database to load the data into the target database.
• Implemented the Incremental loading of Dimension and Fact tables.
• Created Stored Procedures for data transformation purpose.
• Created Tasks, Workflows and Sessions to move the data at specific intervals on demand using Workflow Manager.
• Developed the control files to load various sales data into the system via SQL*Loader.
• Developed Unix Shell scripts for maintaining Files.
• Designed and created an Autosys job plan to schedule our processes.
• Created PL/SQL Stored procedures and implemented them through the Stored Procedure transformation.
• Develop, test and implement break/fix change tickets for maintenance.
• Involved in writing test cases, assisting Testing team in testing.

Environment: Informatica 7.1.1, UNIX, TOAD, IBM DB2 8.1, Oracle 9i (SQL/PLSQL), MS Access 2006, Autosys, MS Excel 2006, UNIX, UNIX Shell Script.

Confidential

Data Warehouse Developer

Responsibilities:

• Extraction, Transformation and data loading were performed using Informatica into the database. Involved in Logical and Physical modeling of the drugs database.
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files, XML Files to target Oracle Data Warehouse database.
• Based on the requirements created Functional design documents and Technical design specification documents for ETL.
• Created tables, views, indexes, sequences and constraints.
• Developed stored procedures, functions and database triggers using PL/SQL according to specific business logic.
• Transferred data using SQL Loader to database.
• Involved in testing of Stored Procedures and Functions. Designed and developed table structures, stored procedures, and functions to implement business rules.
• Used legacy systems, Oracle, and SQL Server sources to extract the data and to load the data.
• Involved in design and development of data validation, load process and error control routines.
• Analyzed the database for performance issues and conducted detailed tuning activities for improvement.
• Generated monthly and quarterly drugs inventory/purchase reports.
• Coordinated database requirements with Oracle programmers and wrote reports for sales data.

Environment: Informatica Power Center, Oracle 8i, SQL Server 2005, XML, SQL, PL/SQL, UNIX Shell Scripts.