SUMMARY

• 7 years of experience in designing, developing, maintaining and building large business applications such as data migration, integration, conversion, data warehouse and Testing.
• Strong knowledge of Software development life cycle SDLC Project Analysis, Requirements, Design Documentation, Development, Unit Testing, User Acceptance Testing, Implementation, Post Implementation Support and Maintenance.
• Business Requirements review, assessment, gap identification, defining business process, deliver project roadmap including documentation, initial source data definition, mapping, detailed ETL development specifications and operations documentation.
• Expertise in data warehousing, ETL architecture, Data Profiling.
• Experience in working with various versions of Informatica Powercenter 9.1/8.6/8.5/8.1 Client and Server tools.
• Extensively used Informatica Warehouse Designer to create and manipulate Source and Target definitions, Mappings, Mapplets and Transformations.
• Experience in creating pre-session and post-session scripts to ensure timely, accurate processing and ensuring balancing of job runs.
• Experience in integration of various data sources like SQL Server, Oracle, Tera Data, Flat files, DB2 Mainframes.
• Experience in complex PL/SQL packages, functions, cursors, triggers, views, materialized views, T-SQL.
• Expert in troubleshooting/debugging and improving performance at different stages like database, workflows, mapping.
• Extensively worked on Informatica Powercenter Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator.
• Strong knowledge in Data Warehousing concepts, Teradata utilities BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD , SQL Assistant UNIX scripting, Data Modelling.
• Worked with ET, UV and WT Tables and MLoad, Fast Load and Error handling and restarting of jobs.
• Worked on Informatica Cloud application creating Data Replication and Data Synchronization tasks, Task Flows and schedules.
• Intense Knowledge in designing Fact Dimension Tables, Physical Logical data models using ERWIN 4.0 and Erwin methodologies like Forward Reverse Engineering.
• Involved in writing Unit test cases for complex scenarios.
• Experience in creating UNIX shell scripts and Perl scripts.
• Expertise in developing slowly Changing Dimensions process using Change Data Capture: Type 1, Type 2, Type 3.
• Knowledge in design and development of Business Intelligence reports using BI tools Business Objects, Cognos and knowledge in microstrategy.
• Experience includes thorough domain knowledge of Business Financial system, Banking, healthcare information technology, Insurance Reinsure, Pharmacy claims systems, Telecom Industry.
• Enthusiastic and goal-oriented team player possessing excellent communication, interpersonal skills and leadership capabilities with high level of adaptability.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Sr. ETL Developer

Description: Confidential, is an Confidential direct broadcast satellite service provider and broadcaster based in Confidential. I was part of BI Data Warehousing team implementing ETL solutions. I have been involved in various projects including Supply Chain Management, Customer Experience and Billing.

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs.
• Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.
• Assisted in designing Logical/Physical Data Models, forward/reverse engineering using Erwin 4.0.
• Developed mappings to extract data from SQL Server, Oracle, Teradata, Flat files and to stage them into tables using the PowerCenter.
• Made use of mapping variables, mapping parameters and variable functions.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations.
• Developed BTEQ scripts to perform the ETL data loads to EDW from staging layer to the Facts and Dimensions.
• Developed UNIX shell scripts for event waits, wait for files, looping and schedules.
• Developed Slowly Changing Dimension for Type 1 2 SCD
• Used mapplets for use in mappings thereby saving valuable design time and effort
• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, worklets and workflows.
• Worked on Informatica Cloud application to retrieve the Sales related data from SFDC.
• Created Data Replication and Data Synchronization tasks, task flows and scheduled them in Informatica cloud.
• Written shell scripts in UNIX to execute the workflow.
• Collected Statistics on indices, join index columns, other columns to improve the Teradata optimizer performance and executing the explain plan for the queries.
• Written SQL Queries, PL/SQL Procedures/Packages to apply and maintain the Business Rules.
• Troubleshooting database, workflows, mappings, source, and target to find out the bottlenecks and improved the performance.
• Written Indexes, primary keys and checked other performance tuning at data base level.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Created testing metrics using MS-Excel
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, Workflows and database tuning.
• Was part of 24/7 On-Call support for release and production environment.
• Created ETL Design documents, Test Results documents for all the workflows.
• Migrated Informatica mappings/sessions /workflows from Development to Test to Production environment.

Environment: Informatica PowerCenter 9.1, Informatica Cloud, Teradata, BTEQ, MLOAD, OLE Load, FASTLOAD, FASTEXPORT, TPUMP, Oracle 11g, SQL,UNIX, Shell Scripts, Autosys, SQL Assistant, SQL Developer, Toad 10.1, Salesforce Dotcom, Microsoft Outlook.

Confidential

ETL Developer

Description: Confidential. is the largest for-profit managed health care company in the Confidential Association. The primary objective of this project was to load the data into staging and then into Confidential coming from various sources using complex Informatica mappings and Teradata Utilities.

Responsibilities:

• Developed mappings to extract data from Oracle, sql server, Flat files, XML files, Excel and load into EDW using the PowerCenter.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD
• Developed BTEQ scripts to perform the ETL data loads to EDW from staging layer to the Facts and Dimensions.
• Developed UNIX shell scripts for event waits, check for files, check for record counts, looping and schedules.
• Worked with outside vendors to send out files from warehouse using Teradata utilities.
• Written Queries, procedures, created Indexes, primary keys and data bases testing.
• Defects were tracked, reviewed and analyzed.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Worked with Reporting team to Generate reports using Cognos.
• Collaborated with Informatica Admin in process of Informatica Upgradation from PowerCenter 8.1 to PowerCenter 8.6.
• Identified sources, targets, mappings and sessions and tuned them to improve performance
• Actively participated in data base testing like checking the constraints, correctness of the data, stored procedures, field size validation, etc
• Used command line mode to embed pmcmd commands in to shell scripts and used pmcmd, pmrep commands in Interactive mode to access repository and workflows.

Environment: Informatica Power Center 8.6/8.1, Oracle, Teradata, PL/SQL, SQL Server 2000, Flat files, Sql loader, UNIX Shell Scripts, SQL Assistant, Microstrategy 8, Cognos, Erwin.

Confidential

Informatica Developer

Description: Confidential is one of the largest publicly traded global asset management firms in the world. The primary objective of the project was to construct an aggregated data warehouse Confidential for analytics and reports used by business, risk management, asset management groups.

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs. Incorporated identified factors into Informatica mappings to build Data Warehouses.
• Developed a standard ETL framework to enable the reusability of similar logic across the board. Involved in System Documentation of Dataflow and methodology.
• Identified all the dimensions to be included in the target warehouse design and confirmed the granularity of the facts in the fact tables.
• Assisted in designing Logical/Physical Data Models, forward/reverse engineering using Erwin 4.0.
• Developed mappings to extract data from SQL Server, Oracle, Teradata, Flat files, DB2, Mainframes and load into Data warehouse using the PowerCenter, power exchange.
• Developed common routine mappings using different transformations like Filter, Router, Connected Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Made use of mapping variables, mapping parameters and variable functions.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD
• Export/Import data from different data bases, flat files using DTS package and BCP by defining source and target.
• Written SQL Queries, Triggers, PL/SQL Procedures, Packages and UNIX Shell Scripts to apply and maintain the Business Rules.
• Checked performance tunning/debugging at different levels like workflows, mappings, database etc.,
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Created testing metrics using MS-Excel
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Performed Configuration Management to Migrate Informatica mappings/sessions /workflows from Development to Test to production environment.
• Generated reports using cognos.
• Performed System Testing, Regression Testing, Acceptance Testing, Functional Testing and Stress Testing.
• Created reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports

Environment: Informatica Powercenter 8.5, Informatica Power Exchange, SQL Server, Teradata, Oracle 10g, DB2,SQL, PL/SQL, Mainframes, Sun Solaris, UNIX Shell Scripts, Business Cognos 8, Erwin, Autosys, Remedy.

Confidential

ETL Developer

Description: Confidential is a research-based company engaged in the discovery, development, manufacturing and marketing of pharmaceutical products worldwide. The project primarily dealt with building sales data warehouse, creating sales reports.

Responsibilities:

• Designed technical layout considering Standardization, Reusability, and Scope to improve if need be.
• Documented the purpose of Data Warehouse including transformations, mapplets, mappings, sessions, and batches so as to facilitate the personnel to understand the process and incorporate the changes as when necessary.
• Developed complex mappings to extract source data from heterogeneous databases Tera Data, SQL Server Oracle and flat files, applied proper transformation rules and loaded in to Data Warehouse.
• Involved in identifying bugs in existing mappings by analyzing data flow, evaluating transformations using Debugger.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Worked closely with Production Control team to schedule shell scripts, Informatica workflows and pl/sql code in Autosys.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Defects were tracked, reviewed and analyzed.
• Conducted UAT User Acceptance Testing with user community
• Developed K-shell scripts to run from Informatica pre-session, post session commands. Set up on Success and on Failure emails to send reports to the team.

Environment: Informatica PowerCenter 8.5, Oracle9i, SQL Server 2000, Erwin, XML, TOAD, HP Unix 11.11, Cognos Report Net.

Confidential

ETL Developer

Description: Confidential is one of the largest IT services and Outsourcing Company in Confidential. This project is to develop the Confidential to store the data collected from different database sources through Informatica and generating reports for business analysis's to improve the business.

Responsibilities:

• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, worklets and workflows.
• Created mappings based on business rules to extract data from different sources, transform and load target databases.
• Debugged the failed mappings and fixed them.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Defects were tracked, reviewed and analyzed.
• Modified the mappings according to the new changes and implemented the persistent cache in several mappings for better performance.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Involved in writing stored procedures and shell scripts for automating the execution of jobs in pre and post sessions to modify parameter files, prepare data sources.
• Identified the issues in sources, targets, mappings and sessions and tuned them to improve performance.
• Created and used reusable mapplets and worklets to reduce the redundancy.

Environment: Informatica power center, Oracle, SQL, PL/SQL, Solaris, MS Vision, Ms-Access