Professional Summary

• Over 9 years of IT experience as specialist in performing Analysis Design Development Testing Deployment and Maintenance for various software applications.
• Extensive knowledge on the SDLC development life cycle. Involved in different phases starting from Requirement Gathering to Production Deployments.
• Extensive experience in ETL design development and maintenance using SQL PL/SQL Informatica Power Center 9.x/8.x/7.x on UNIX and Windows platforms.
• Proficient in the development of solutions using Informatica Siperian MDM Hub.
• Expertise in Data Warehousing Data Migration Data Integration using Business Intelligence BI tools such as Informatica Power Center Power Exchange CDC B2B Data Transformation Informatica Data Quality Informatica Data Explorer MDM SSIS OBIEE Cognos etc.
• Worked with various source systems such as Relational Sources Flat files XML Mainframe COBOL and VSAM files CSV files SAP Sources/Targets and Web Services etc.
• Expertise in Informatica MDM Hub Match and Merge Rules Batch Jobs and Batch Groups.
• Extensive experience in Oracle DB2 Teradata SQL server Netezza Sybase Greenplum etc.
• Extensive knowledge of various Performance Tuning Techniques on Sources Targets Informatica Mappings Sessions and Data Base Tuning.
• Expertise on integration mappings including dynamic cache lookup shared and persistent cache for mappings of Type I Type II and Type III Slowly Changing Dimensions and implementing update strategies incremental loads and change data capture.
• Strong skills in Data Analysis Data Requirement Analysis and Data Mapping for ETL processes
• Expertise in defining and documenting ETL Process Flow Job Execution Sequence Job Scheduling and Alerting Mechanisms using command line utilities.
• Extensive experience in implementing Error Handling Auditing and Reconciliation and Balancing Mechanisms in ETL process.
• Knowledge of various Data Modeling techniques such as E-R modeling and Dimensional modeling Star/Snow flake Schema .
• Strong Expertise in Database Design development of SQL Scripts Stored Procedures Functions Packages Triggers using Oracle PL/SQL T-SQL Teradata SQL DB2 SQL PL etc.
• Knowledge of Informatica Administration complete installation and upgrade of Informatica 8x.
• Working knowledge of other integration tools such as SSIS Data stage Abinitio etc.
• Worked on creating reports using OBIEE Oracle Analytic functions Business Objects and Congo s.
• Experience in UNIX Shell Scripting for applying data fixes and automation of ETL jobs.
• Committed individual with excellent interpersonal analytical and communication skills.
• Ability to work simultaneously on multiple projects work independently as well as a team member.

TECHNICAL EXPERIENCE

PROFESSIONAL EXPERIENCE

confidential

Informatica Developer

Project Details

This project involves designing of ETL for integrating data from Transactional systems along with facts from legacy source systems.

Responsibilities

• Documented User Requirements translated requirements into system solutions and developed implementation plan and schedule.
• Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer.
• Involved in data modeling and designed the Data Warehouse using snowflake Schema methodology. Also responsible for all ongoing data model design decisions and database implementation strategies.
• Extracted data from different source systems such as Oracle DB2 and Flat Files.
• Designed and developed complex mappings by using Lookup Expression Update Sequence generator Aggregator Router Stored Procedure etc. transformations to implement complex logics while coding a mapping.
• Developed and maintained ETL Extract Transformation and Loading mappings to extract the data from multiple source systems like Oracle SQL server and Flat files and loaded into Oracle.
• Used Metadata Manager to manage the Metadata associated with the ETL processes.
• Troubleshooted PL/SQL and UNIX shell scripts Tuned SQL statements Partitioning/Indexing.
• Used error handling mapplets to capture error data into PMERR tables for handling nulls analysis and error remediation process.
• Identified slow running ETL jobs and reduced the run time drastically by applying performance tuning techniques.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Performance tuned existing ETL processes at the Informatica mapping session and database level.
• Experience with BTEQ scripts
• Used Mload Fload and Tpump Teradata utilities.
• Environment Informatica Power Center 9.5/9.1 Oracle 11g SQL server DB2 PL/SQL TOAD IC for code migration XML T-SQL Shell Scripts Control-M Teradata SQL assistant Aginity Netezza.

confidential

Informatica Developer

Project Details

• The project involved the creation of a Membership Data Warehouse MDW that
• supported all Membership related data marts and reporting by providing an accurate view of core
• Customer member information across all regions.

Responsibilities

• Documented User Requirements translated requirements into system solutions and developed implementation plan and schedule.
• Involved in data modeling and designed the Data Warehouse using Star Schema methodology. Also responsible for all ongoing data model design decisions and database implementation strategies.
• Extracted data from different source systems such as Oracle SQL Server DB2 Mainframes XML and Flat Files.
• Developed Complex transformations Mapplets using Informatica to Extract Transform and Load Data into Data marts Enterprise Data warehouse EDW and Operational data store ODS .
• Used Informatica Data explorer IDE and Data Quality IDQ to implement Data rule taxonomy repository managing data rules to standardize and remove duplication of customer data and reporting on the execution of rules against data.
• Used Metadata Manager to manage the Metadata associated with the ETL processes.
• Troubleshooted PL/SQL and UNIX shell scripts Tuned SQL statements Partitioning/Indexing/compressing terabyte tables.
• Used error handling mapplets to capture error data into PMERR tables for handling nulls analysis and error remediation process.
• Identified slow running ETL jobs and reduced the run time drastically by applying performance tuning techniques.
• Advocated best practices for ETL Processes and conducted Data Integration COP meetings.
• Created slice and dice and drill down Reports Dashboards and Scorecards using OBIEE 11g for various subject areas.
• Performance tuned existing ETL processes at the Informatica mapping session and database level.
• Used Tpump utilities configured with Informatica external loaders.
• Read data from SAP sources and SAP targets.

Environment

Informatica Power Center 9.5/9.1.1/8.6 Power Exchange CDC Oracle 11g PL/SQL Teradata Sybase Netezza SAP TOAD ERwin Quality Center SQL SERVER 2005/2008 XML T-SQL Shell Scripts Control-M.

confidential

Informatica ETL Developer

Project Details

The database was upgraded and an enterprise data warehouse was implemented for the MCO reps. Distributed data is coming from the heterogeneous sources like SQL server Oracle and in flat files from the clients. This Enterprise Data Warehouse EDW was used to deliver reports and information to sales and marketing management.

Responsibilities

• Interacted with Business Analysts to understand business and functional specifications.
• Involved in dimensional modeling Star Schema of the Data warehouse and used Erwin 3.5 to design the business process grain dimensions and measured facts.
• Participated in the Design Meetings and prepared technical and mapping documentation.
• Extensively migrated data from different source systems such as flat files relational and XML sources to ODS Data marts and Data warehouse and worked on Data partitioning.
• Used Type 1 and Type 2 SCD mappings to update slowly Changing Dimension Tables using Informatica changed data capture CDC .
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Used Meta Data Manager to created lineage report for source/target objects and connected business terms with actual implementation and prepared a final report.
• Performance tuned the Mappings Tasks Sessions SQL and Scripts to optimize Data-Load performance.
• Used Multiload FastLoad and Tpump utilities to load to Teradata database.
• Read from SAP source using Power Exchange and also loaded data into SAP targets.
• Worked on IDQ tool to identify data duplication and understand the quality of data. Used IDE tool for profiling the data prior to Data migration.
• Created Financial Forecast reports for the top management/business users using Micro Strategy 8.1.
• Worked with testers and participated in Unit Integration system and performance testing of ETL applications.
• Used Informatica web services - consumer and provider.
• Read data from SAP BCI and full extract and loaded data to SAP targets through IDOC prepare transformation.

Environment Informatica Power Center 8.6.1 Metadata Manager MDM Informatica Power Exchange CDC IDQ Oracle 11g SQL Server SAP R3 Micro Strategy 8.1 SQL Server 2005 Teradata Windows NT/2003 UNIX Autosys.

confidential

Informatica Developer

Project Details

confidential is an American provider of cable TV broadband Internet and VOIP telephone services in the U.S. In this project after Data Discovery and Data Cleansing of legacy data the master data was moved to an interim database. ETL tools were used to transform legacy data into required formats. Then the master data was loaded to the production systems and the reports were updated.

Responsibilities

• Analyzed the functional specs provided by the data architect and created Technical System Design Documents and Source to Target mapping documents.
• Converted the data mart from Logical design to Physical design defined data types Constraints Indexes generated Schema in the Database created Automated scripts defined storage parameters for the objects in the Database.
• Designed Installed and Configured the Informatica MDM Multi domain. Hub Server Cleanse Cleanse Adaptor Resource Kit
• Defined Business rules in Informatica Data Quality IDQ to evaluate data quality by creating cleanse processes to monitor compliance with standards and also identified areas for gaps and assisted in resolving data quality issues.
• Hands on executing MDM hub Batch Jobs Stage Load Tokenize and Match Processes and Batch Groups
• Involved in designing Staging and Data mart environments and built DDL scripts to reverse engineer the logical/physical data model using Erwin.
• Informatica Power Exchange for Mainframe was used to read/write VSAM files from/to the Mainframe.

Designed Audit table for ETL and developed Error Handling Processes for Bureau Submission.

• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and automated execution of workflows.
• Managed Change Control Implementation and coordinating daily monthly releases and reruns.
• Responsible for Code Migration Code Review Test Plans Test Scenarios Test Cases as part of Unit/Integrations testing UAT testing.

Environment Informatica MDM Informatica Power Center 8.1/8.6 Power Exchange SAP Oracle 10g/11g PL/SQL Teradata Sybase XML source/target TOAD SQL SERVER 2005/2008 XML UNIX Windows XP BO OBIEE.

confidential

Informatica Developer

Project Details

During this project I have worked closely with the data warehouse development team customers business analysts and other colleagues in the ITS department to analyze operational data sources determine data availability define the data warehouse schema and develop ETL processes for the creation maintenance and overall support of the data warehouse.

Responsibilities

• Involved in Dimensional Modeling Star Schema of the Data Warehouse and used Erwin 3.5 to design the business process grain dimensions and measured facts.
• Migrated data from different source systems such as Flat Files Relational SAP and XML sources to ODS Data Marts and Data Warehouse running on Teradata using utilities like Multi Load and Fast Load.
• Used Type 1 and Type 2 SCD mappings to update Slowly Changing Dimension tables using Power Exchange Change Data Capture CDC .
• Involved in extraction of data from Teradata and writing to flat files using BTEQ and Fast Export and loading data into Teradata from flat files using Multi load.

Using Informatica Power Exchange for Siebel to extract and integrate customer relationship management CRM data stored in Siebel.

• Informatica Data Quality IDQ was used to identify Data Duplication and understand the quality of data. Used Informatica Data Explorer IDE tool for profiling the data prior to migration.
• Used Shell Scripts to schedule PMCMD to interact with Informatica Server from command mode.
• Designed and developed UNIX scripts for creating dropping tables which are used for scheduling the jobs.
• Worked with testers and participated in Unit Integration Regression and Performance testing of ETL applications.

Environment Informatica Power Center 8.6.1 Informatica Power Exchange CDC Informatica Data Quality IDQ Oracle 11g Teradata AIX PL/SQL TOAD HP-UX Autosys DB2.

Confidential

Informatica ETL Developer

Project Details

This eQUOTE and SSQ Data warehouse provides data of surgical support systems infection prevention systems and contamination prevention technologies. eQUOTE is the main system for sending quotes to a potential customer prospect or current customer.

Responsibilities

• Designed multi dimensional Star schema Generated the database scripts E-R diagrams using ERWIN.
• Participated with the Data Architect in the dimensional modeling of the Market Quality Data warehouse
• Involved in the creation of universes for the data warehouse project.
• Wrote Shell scripts for the daily maintenance operations of the Database like backup procedures checking the space allocations and table space analysis.
• Generated reports of Multidimensional analysis slice and dice and drill down reports.
• Involved in the configuration of Business Objects for 2 tier and 3-tier architecture using Web Server.

Environment Informatica Power Center 7.1/8.1 Oracle 10g Mainframes DB2 Netezza MS SQL Server 2005 Toad PL/SQL SQL XML AIX.

confidential

Informatica ETL Developer

Project Details

Confidential is one of the leading automotive parts and Heavy Engineering Products Company in India. I Worked as a Database Developer in MIS Reporting Team.

Responsibilities

• Involved and Designed the System Development Life Cycle i.e. such as conducting the preliminary
• Investigation and technical specs.
• Involved in creation of tables writing stored procedures Triggers PL/SQL Libraries.
• Created facts and dimensions according to the business requirements.
• Performed Normalization and Logical Database Design Unit Testing of the modules.
• Developed user-friendly forms for easy data entry.
• Created UNIX shell scripts to invoke the SQL scripts that were run daily.

Environment Oracle Database 8i SQL PL/SQL Sun Solaris V5.8 Windows 2000 Toad Test Director.