SUMMARY

• Over 7+ years of total IT experience and technical proficiency in Data Warehousing teamed with Data Analysis, BI, Data Modeling, and ETL Development & ETL Design with full life cycle Implementation of Data Warehouse using Business Intelligence Development Studio (SSIS), SQL, and Informatica Power Center.
• Strong knowledge and experience in various sectors including banking, finance, health care, pharmacies and Insurance.
• Strong Data Warehousing experience in ETL Application using Informatica Power Center, Power Exchange and SSIS.
• Extensive work experience in ETL Design and development of CDC process using time - stamping method and Implemented SCD methodology including Type 2 to keep track of historical data.
• Strong understanding of performance tuning in SSIS, Informatica and Databases with Oracle and SQL server stored procedures, triggers, sources, mappings and target.
• Designed databases, stored procedures, reports, and data input interfaces using SQL Server.
• Developed and deployed quality SQL codes, stored procedures, views, functions, triggers and jobs
• Strong Experience in extracting data from various sources including Oracle, DB2, Flat files, SQL Server, XML files, Teradata and loaded into Teradata, Oracle database and SQL Server.
• Extensive experience in using SQL Development tools including SQL Plus, TOAD, SQL Developer, SQL Server Management Studio and SQL Loader.
• Experience in creating batch/cmd scripts to execute SSIS ETL jobs.
• Experience in SSIS error handling.
• Directly involved in gathering requirements and analysis. Deriving testable functional / non-functional system requirements, providing strategic and tactical inputs and coordinating with business functions and technical project teams from conception through deployment.
• Involved in data modeling, ETL development, ETL implementations and data quality in a variety of data warehouse projects.
• Experience in both integration and reporting areas of data warehouse using Informatica, SSRS and SSIS.
• Strong experience in working with on-shore teams, off-shore teams and production support, to meet implementation dates and allow smooth transition throughout the development life-cycle.
• Familiar with Agile development and Waterfall methodologies.
• Strong presentation, verbal and written communication skills.

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

ETL Developer

Responsibilities:

• Involved in requirement analysis, ETL design and development for extracting from the source systems and loading it into database.
• Involving in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment.
• Interacted with the source system to gather the requirements.
• Gathered requirement and prepared mapping documents and the data flow documents.
• Extensively used ETL to load data from multiple sources to Staging area using Informatica PowerCenter 10.1 Worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Fact and Dimension tables.
• Worked with Power Center Tools; Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Worked on Designer tools; Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Experience analyzing user requirements and translating them into system data structure designs.
• Extensively used Informatica Transformation such as Source Qualifier, Rank, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties.
• Solid Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with various Lookup caches such as Static cache, Dynamic cache and Persistent cache.
• Involved in writing T-SQL Procedures Using SQL Server.
• Involved in the developing & debugging of Sybase and SQL server procedures.
• Extensively worked with Joiner functions such as normal join, full outer join, master outer join and detail outer join in the Joiner transformation.
• Developed Reusable Transformations and Reusable Mapplets.
• Worked extensively with Session Parameters, Mapping Parameters, Mapping Variables and Parameter files for incremental data loading.
• Created reusable transformations and mapplets and used them in different mappings.
• Tuned sources, targets, mappings and sessions to improve the performance of data load.
• Involved in performance tuning for sources, targets, mappings, and sessions.
• Expertise in using Power Exchange in conversion of files and creating data maps.
• Performed unit testing on the Informatica code by running it in the Debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for optimum performance.
• Provided production support.

Environment: Informatica PowerCenter 10.1, Mainframes, Oracle 12g, UNIX, WINSCP, PUTTY and MS Visio.

Confidential

ETL Developer

Responsibilities:

• Worked with SSRS to help develop various reports for multiple clients.
• Prepared complete data mapping and report definitions for over 50 reports.
• Involved in creating multiple parameterized stored procedures.
• Worked on formatting SSIS packages using variables and expressions.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouses.
• Involved in the migration of databases from SQL Server 2005 to SQL Server 2008.
• Prepared complete data mapping for migrated jobs across environments using SSIS.
• Created databases and schema objects including tables, indexes, constraints, functions, stored procedures and triggers.
• Designed SSIS packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Lookup, derived column, data conversion, aggregate, conditional split, SQL task, script task and send mail tasks.
• Used execution plan, SQL profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
• Creating source and target table definitions using SSIS. Source data was extracted from Flat files, SQL Server and DB2 Database
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments
• Scheduled the SSIS packages to run at different intervals to load the data.

Environment: Windows 2007 Enterprise, SQL Server 2008/2005, SQL Integration Services (SSIS), Informatica, Business Intelligence Development Studio, Visual Studio 2008/2005, OLE DB and Toad.

Confidential, New Orleans, Louisiana

ETL Developer

Responsibilities:

• Responsible for ETL design & implementation to source.
• Involved in requirement analysis, ETL design and development for extracting data from the source systems such as Oracle, flat files, XML files and loading into data mart by making new ETL designs.
• Analysis of Data using IDQ.
• Developed complex mapping logic using various transformations including Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Router, Update strategy and SQL Sequence generator.
• Converted functional specifications into technical specifications (design of mapping documents).
• Developed Packages by using SSIS.
• Developed new data models.
• Created deployment groups to deploy objects.
• Responsible for design and implementations that are needed for loading and updating the warehouse.
• Worked with session logs and work flow logs for error handling and troubleshooting in dev environment.
• Created scripts for better handling of incoming source files such as moving files from one directory to another and extracting information from file names, such as date, for continuously incoming sources.
• Wrote scripts to ensure e-mails were sent to respective people on failure/success, error handling, control auditing of different processes.
• Involved in Performance Tuning of existing mappings as well as new ones.
• Wrote complex SQL scripts to avoid Informatica joiners and Look-ups.
• Migrated code/objects from the development environment to the QA/testing environment to facilitate the testing of all objects developed and check their consistency end to end on the new environment.
• Involved extensively in unit testing, integration testing, system testing and UAT.
• Solution the data quality and data cleansing tracks for the MDM project.
• Supervision of data quality, ETL development, data-integration and testing.
• Conduct business and requirements analysis workshops.

Environment: Informatica Power Center 9, Power Exchange, Oracle 11g, SQL server 2012, Mainframes, UNIX, Power Exchange, Data Quality, SSIS, SSRS.