SUMMARY

• Over 6+ of professional experience in Design, Development, Debugging and Implementation of Data Warehousing applications using Informatica.
• Experienced in Healthcare, Telecom and Banking and extensively worked on teh analytics system
• Experience in Data Warehouse/Data Mart development life cycle with thorough knowledge in Star schema, Snowflake schema, Dimension and Fact tables.
• Strong Data Warehousing experience using Informatica with extensive experience in designing teh Workflows, Worklets, Mappings, Configuring teh Informatica Server and scheduling teh Workflows and sessions using Informatica PowerCenter 9.x/8.x/7.x/6.x/5.x
• Performed all phases of development including Extraction, Transformation, Loading (ETL) data from Heterogeneous sources into Data Warehouses and Data Marts using Power Center (Repository Manager, Designer, Workflow Manager, and Workflow Monitor).
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer
• Good knowledge in Data Modeling (Physical & logical data modeling) using data Modelers.
• Good expertise in Data Analysis, Data Cleansing and Data Validation
• Good experience in writing SQL Queries and Stored procedures, functions, cursors and packages using SQL Programming.
• Experience in Integration of various data sources like Oracle, Teradata, SQL Server, DB2 and Flat Files.
• Hands on experience in Informatica performance tuning, identifying and resolving performance bottlenecks at sources, targets, mappings, and sessions level.
• Gatheird business requirements, translated them to design specifications. Involved in Product development, generating test plans and cases for unit and system testing based on requirements.
• Extensive experience in using tools like SQL Plus, TOAD, SQL Loader, PL/SQL Developer and Knowledge in databases and operating systems like MS Access, MS SQL Server 2000/2005, IBM DB2 7.2/8.0,and Windows 2000/XP.
• Extracted data from various sources like Oracle, Flat file, SQL SERVER, and loaded into Flat File and Oracle database.
• Experience in migrating application code from one Environment to another like Dev to QA to PROD.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.1/8.6/7.1, Repository Manager, Designer, Workflow Manager, Workflow Monitor, Informatica Developer, SQL *Plus, Toad .$universe

Databases: Oracle 10g/9i/8i, MS SQL 2000/2005, MS Access 2000

Programming: SQL, PL/SQL, Unix

Environment: Windows 95/98/NT/2000/XP, UNIX(AIX 5.2), Linux, MS-Dos

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling

PROFESSIONAL EXPERIENCE

Confidential, PA

Informatica Developer

Responsibilities:

• Conducted Project Kick-off with all stakeholders and business/functional-leads.
• Define Project Scope, high-level Project Plan, time-lines, roles and responsibilities.
• Analyzing teh requirement and understanding teh functional specifications
• Facilitate project build, unit testing, integration test cycles, bug fixing and UAT sign-off.
• Writing code to fetch data from database and applying ETL logic to prepare result in required format.
• Used Oracle, Flat files, and SQL server sources and Oracle as target
• Extensively worked with Repository Manager, Designer, Workflow Manager and Monitor.
• Worked with Lookup, Aggregator, Expression, Router, Filter, Update Strategy, Stored Procedure transformations.
• Configured and ran teh Debugger from within teh Mapping Designer to troubleshoot teh mapping before teh normal run of teh workflow
• Used TOAD to evaluate SQL execution.
• Performance monitoring and tuning
• Integration of various applications
• Bug Fixing of teh application in various areas
• Conducting code review.
• Prepare Deployment, Roll-back and Communication Plan and ensure smooth deployment on Production Environment.

Environment: Informatica Power Center 9.1 (Workflow Manager, Workflow Monitor, Mapping Designer, Mapplet Designer, Transformations), Oracle 10g, SQL, PL/SQL, UNIX, $Universe (For scheduling)

Confidential, NY

Informatica Developer

Responsibilities:

• Extensively used source analyzer, transformation developer, mapping designer, workflow manager and workflow monitor for loading and monitoring data.
• Designed reusable transformations and mapplets.
• Used transformations such as teh Source Qualifier, Expression, Normalizer, Aggregators, Connected & Unconnected lookups, Filters, Sorter, Stored Procedures, Router, Sequence generator and others.
• Implemented ETL Informatica designs and processes for teh load of data from teh sources to teh target warehouse.
• Implemented Slowly Changing Dimension type2 methodology for accessing teh full history of risk limits and transaction information
• Tuned existing Informatica mappings for performance optimization.
• Responsible for Unit Testing and preparing unit test cases and peer review documents.
• Interacting with system testing team and resolve teh issue reported by teh testing team.
• Created database scripts for creating/dropping tables, synonyms, views, indexes, stored procedures and gathering stats.
• Responsible for creating shared and reusable objects in Informatica shared folder.
• Used Tidal for scheduling jobs and for batch processing.
• Associated with Production support team in various performances related issues.
• Used debugger to test thedata flowbetweensource and targetand to fix teh invalid mappings.
• Developed some reports/dashboards Analytic views (Pivot Tables, Charts, Column Selector, and View Selector).

Environment: Informatica 9.1, Oracle 10g/11g TOAD, Flat files and SQL shell scripts for scheduling, Started Aginity and netezza

Confidential, Atlanta, GA

DWH/ETL Developer

Responsibilities:

• Implemented ETL Informatica designs and processes for teh load of data from teh sources to teh target warehouse.
• Interacting with teh Informatica Middleware team to migrate teh code from teh 7.4 Production Environment to 8.6 Development.
• Responsible for performance tuning at various levels like mapping level, session level, and database level.
• Worked with Shortcuts across Shared and Non Shared Folders.
• Responsible for determining teh bottlenecks and fixing teh bottlenecks with performance tuning.
• Worked with Index Cache and Data Cache in cache using transformation like Rank, Lookup, Joiner, and Aggregator Transformations.
• Extensive worked on debugging and troubleshooting teh Sessions using teh Debugger and Workflow Monitor.
• Worked with Session Logs and Workflow Logs for Error handling and troubleshooting.
• Involved in setting up teh environment for teh new version.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy
• Responsible for Unit Testing and creating unit test plans and preparing unit test cases.
• Interacting with system testing team and resolve teh issue reported by teh testing team.

Environment: Informatica Power Center 7.4/ 8.6, Oracle 10g, PL/SQL, SQL Server, Flat Files, UNIX, Windows XP, Teradata, Control M, Unix Shell Scripting.

Confidential, NY

Informatica Developer

Responsibilities:

• Gatheird functional requirements from clients, documenting requirements and incorporating them in Informatica.
• Designed ETL mappings, sessions and workflows using Informatica for loading data from Oracle, Flat files into teh target Oracle 9i database.
• Created Mappings using Mapping Designer to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Normalizer, Filter and Router transformations.
• Created Workflows in teh Workflow designer and executed tasks such as Sessions and Commands and monitored transformation processes using Workflow monitor.
• Developedmapping parametersandvariablesto support SQL override.
• Handled release management, Worked on applying labels to teh components, Deployed code for user acceptance testing (UAT) and production environments.
• Created different documents like Impact Analysis, design document, Unit Test Case, Review report, Production move checklist in Informatica.
• Developed mappings to load teh data in Slowly Changing Dimensions.
• Coordinated with Database administrator team to make sure database gets executed correctly at stage and production instances before loads can start.
• Involved in data modeling activities, worked on maintaining and enhancing existing data models.
• Involved in Performance tuning and improvements for several jobs in Informatica.
• Worked with Session Logs and Workflow Logs for Error handling and troubleshooting.

Environment: Informatica Power Center 7.3.1, Oracle 9i, PL/SQL Developer