SUMMARY

• 7+ years of experience in designing and developing solutions in Data warehousing.
• Experience in Banking domains and Finance Industry Healthcare and Retail.
• Analyzed, designed and developed Extraction, Transformation and Load (ETL) processes for Data Warehousing using Informatica Power Center 9.5/9.1/9.0.1/8.6/7.1 including Designer, Repository Manager, Server Manager, Workflow Manager and Workflow Monitor.
• Good knowledge of Data warehouse concepts and principles (Kimball/Inman) - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.
• Knowledge in design of Extract, Transform, Load environment using Informatica Power Center.
• Expert in Scheduling tool BMC Control-M 8/7.3/7.1.
• Skilled in Planning, Designing, developing and deploying Data warehouses/Data Marts.
• Strong experience in designing and developing Business Intelligence solutions in Data Warehouse/Decision Support Systems using ETL tools, Informatica Power Center 9.5/9.1/9.0.1/8.6.1/7.1 for OLTP, OLAP.
• Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server and Worked on integrating data from flat files like fixed width and delimited.
• Data sources worked on include Flat Files, Excel files and Databases.
• Worked with different Databases like Oracle 11g/10g/9i and SQL Server 2000/2005/2008.
• Skilled in performance tuning of ETL processes and SQL queries.
• Developed PL/SQL packages, shell scripts to execute the packages and PL/SQL blocks to debug the package in production environment and migrated bulk data.
• Improved performance by using Explain Plan, Creating appropriate indexes, queries optimization.
• Hands on experience in tuning ETL, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings/jobs, and sessions.
• Familiar with other reporting tool MS SQL Server Reporting Services 2005/2008. Experienced in interacting with business users, business analysts.
• IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.
• Excellent communication, presentation and interpersonal skills and ability to prioritize and coordinate work across different geographic locations.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i, MS SQL Server 2012/2008/2005/2000 , MS Access

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimension Tables, Forward Engineering and Reverse Engineering.

ETL Tools: Informatica Power Center 9.5/9.1/8.6/8.1/7.1.4 , Control M 8/7.1, SSIS

Environment: s: UNIX, Windows 7/XP/2000, Windows server 2003/2000, HP-Unix, Linux.

Languages: SQL, PL/SQL, T-SQL, Windows Batch Scripting

Reporting Tools: SQL Server Reporting Services (SSRS) 2008.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SR. ETL/INFORMATICA DEVELOPER

RESPONSIBILITIES:

• Converted historical data into the new streamlined standards. Created new mappings for different business report needs.
• Collaborated with Business Analysts to ascertain the issues with the existing data warehouse. Modified mappings to conform to business requirements
• Developed complex mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Router, Lookup - Connected & Unconnected, Sequence Generator, Filter, Sorter, Source Qualifier, Stored Procedure transformation etc.
• Develop Control-m Workflows and Schedule workflows for a daily, Weekly monthly schedules based on business requirements.
• Involved in preparing detailed ETL design documents.
• Prepared the code migration document and worked with release team to migrate the code from one environment to other.
• Tuned performance of Informatica sessions for large data files by increasing block size, data cache size and sequence buffer length.
• Created various Data Models using MS Visio.
• Involved in fixing invalid Mappings, testing of Stored Procedures and Functions, Testing of Informatica Sessions, Worklets and Workflows.
• Developed shell scripts to perform the target testing.
• Responsible for creating the parameter files in order to connect to the right environment and database.
• Provided production support and Conceived unit, system, integration, functional, and performance test plans.
• Developed Reports on SSRS for performing data checks and balances for all the User communities

Environment: Informatica Power Center 9.5/9.1, Oracle 11g, Toad, SQL Server 2008, SSRS, Flat Files, and Windows.

Confidential

SR. ETL/INFORMATICA DEVELOPER

RESPONSIBILITIES:

• Interacted with End Users for gathering requirements.
• Developed standards for ETL framework for the ease of reusing similar logic across the board.
• Used Repository manager to create Repository, User groups, Users and managed users by setting up their privileges and profile.
• Developed mappings to extract data from different sources like SHAWSTORE (Xerox), Oracle, FLAT files, COBOL files are loaded into Data Mart.
• Created complex mappings by using different transformations like Filter, Router, Connected and Unconnected lookups, and Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart.
• Made use of Informatica Workflow Manager extensively to create, schedule, execute and monitor sessions, worklets and workflows.
• Developed Slowly Changing Dimension for type I and type II (flag, version and date).
• Involved in designing Logical/Physical Data Models reverse engineering for the entire subject across the schema’s using Erwin.
• Scheduled the workflows using Control M 7.3/7.1.
• Used Windows Batch scripting to perform file based operations.
• Creating Informatica Development Standards. This document describes the general guidelines for Informatica developers, the naming conventions to be used in the Transformations and also development and production environment structures.
• Wrote SQL Queries, Triggers and PL/SQL Procedures to apply and maintain the Business Rules.
• Troubleshoot database, workflows, mappings, source, and target to find out the bottlenecks and improved the performance.
• Used SQL developer to run SQL queries and validate the data in warehouse and mart.

Environment: Informatica Power Center 9.1, Control-M, COBOL files, SHAWSTORE, Info Advantage, Toad, Oracle, PL/SQL, Flat Files, and Windows.

Confidential

ETL/INFORMATICA DEVELOPER

RESPONSIBILITIES:

• Documented user requirements, Translated requirements into system solutions and developed implementation plan and schedule.
• Extracted data from relational databases DB2, Oracle and Flat Files.
• Developed Complex transformations, Mapplets using Informatica to Extract, Transform and load data into Datamarts, Enterprise Data warehouse (EDW) and Operational data store (ODS).
• Developed data Mappings, Transformations between source systems and warehouse
• Performed Type1 and Type2 mappings.
• Managed writing test cases and test scenarios from requirement for newly added features and executing test scripts.
• Adding requirements into Quality Centre, Mapping Requirements with Test cases.
• Documenting defects in Quality center uploading all necessary information into Share point.
• Worked closely with UAT team.
• Preparation of test cases/scenarios and execution of the same
• Recording, tracking and closing of defects/bugs in a systematic manner into a Defect Tracking System and preparation of bug report with bug severity and bug priority.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.
• Implemented Aggregate, Filter, Join, Expression, Lookup and Update Strategy transformations.
• Used debugger to test the mapping and fixed the bugs.
• Created sessions, sequential and concurrent batches for proper execution of mappings using server manager.
• Used Power Center Data Masking Options (Random Masking, Blurring, SSN, Credit Card) in mappings.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Responsible to design, develop and test the software (Informatica, PL/SQL,) to maintain the data marts (Extract data, Transform data, Load data).
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Included data from different sources like Oracle Stored Procedures and Personal data files in the same report.
• Responsible for daily verification that all scripts, downloads, and file copies were executed as planned, troubleshooting any steps that failed, and providing both immediate and long-term problem resolution.

Environment: Informatica Power Center 8.6.1/8.1.1 , Oracle, Flat Files,Windows

Confidential, NYC, NY

DATA WAREHOUSE/INFORMATICA DEVELOPER

RESPONSIBILITIES:

• Analyzed business process and gathered core business requirements, interacted with business analysts and end users.
• Analyzed business requirements and worked closely with the various application teams and business teams and developed ETL procedures that are consistent across all application and systems.
• Developed Mappings and Mapplets using PowerCenter Designer to extract data from Mainframe Flat files to load into Oracle DBs.
• Created different Parameter files and changed Session parameters, Mapping parameters and Variables during run time.
• Extensively used Source Qualifier Transformation and created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Normalizer, Stored Procedure, Update Strategy and Sequence Generator.
• Used Debugger to test the dataflow and fixed the mappings.
• Created and monitored Workflows and Tasks using Informatica Power Center and Workflow Manager.
• Partitioned Sessions for concurrent loading of data into the Target tables.
• Tuned the Workflows and Mappings.
• Involved in identifying the bottlenecks and tuning to improve the Performance.
• Coordinated and handled Bridge Line calls during production issues
• Created workflows using Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs and sessions to run a mapping.
• Executed Workflows and Sessions using Workflow Monitor.
• Worked with Teradata as sources as well as targets.
• Used Fast Load Teradata utility for Initial loads.
• Actively coordinated with testing team in the testing phase and helped the team to understand the dependency chain of the whole project.
• Developed SQL scripts to fix historical data and to do end to end testing.

Environment: Informatica 7.1, SQL Server 2005, SQL, PL/SQL, Oracle, TOAD, Windows Server 2003.