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 elated 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

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 Confidential. 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.