PROFESSIONAL SUMMARY:

• Around 5 years of IT experience in Analysis, Design, Development and Deployment of technical solutions to business requirements.
• Extensively worked on Data Warehouse Full Life Cycle Projects for Health Care, Financial, and Retail industries.
• 4+ years of Strong Data Warehousing ETL experience using Informatics Power Center 9.6.1/9.5/9.1/9.0/8.6 (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer, Informatica Server, Repository Manager)
• Experience in all the phases of ETL such as Extraction, Cleaning, Transformation and Loading using Informatica.
• Experience in using Oracle 11g/10g for performing ETL functions using stored procedures.
• Extensive experience and exposure on several areas of the data warehousing and Business including requirements gathering, data warehouse architecture design, development, quality planning & assurance, data analysis and implementation.
• Working knowledge with Informatica CDC for daily loads.
• Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Excellent understanding of the System Development Life Cycle. Involved in analysis, design, development, testing, implementation, and maintenance of various applications.
• Extracted data from various sources ranging from various RDBMS like Oracle, MS SQL Server, DB2, Teradata and Sybase, and Flat Files to load data into data marts and data warehouse.
• Expertise in working with TOAD for creation of Tables, Materialized views and normal views.
• Proficiency in working with PL/SQL stored procedures, packages, and triggers.
• Actively involved in Performance Tuning, maintaining Staging area, Backup and Recovery process, product support on various platforms.
• Implementations of change data capture using Power Exchange for daily loads.
• Performed data quality checks using data quality tools.
• Experience in UNIX environment, file transfers and job scheduling.
• Experience in doing Tuning of Teradata Queries using Explain plan.
• Good experience working with large databases and performance tuning.
• Efficient in Optimizing, Debugging and testing SQL queries and stored procedures.
• Excellent working knowledge of Shell Scripting and job scheduling on platforms like UNIX.
• Good experience on FACETS CTP (Claims Test Pro) and FACETS Testing.
• Able to interact effectively with other members of the Business, Quality Assurance, Users and other teams involved with the System Development Life cycle.
• Automation of the business process using Control M, Autosys and Tidal.
• Designed and coded application components in an Agile environment utilizing a test driven development approach.
• Excellent analytical, functional, design and development skills with excellent communication skills and the ability to interface with the executives and perform independently as well as team environments.
• Resolving production issues for any scheduled jobs failures and reporting issues to the concerned teams.

TECHNICAL SKILLS:

ETL TOOL: Informatica 8.6, 9.1, 9.5.1, 9.6.1,10.1

DATABASES: Oracle 9i/10g/11g, SQL Server 2008, My SQL, Teradata

PROGRAMMING LANGUAGES: UNIX Shell Scripting, SQL

SCHEDULING TOOLS: Control M, AutoSys

ENVIRONMENT: Windows XP/2000, UNIX, LINUX/Perl

OTHER SOFTWARE: TOAD, Putty, WinSCP, SQL Developer, Tera data/BTEQ, HTML, Java Script

OTHER APPLICATION: HP Quality Center 9/10, Citrix, SOAP and REST Services

METHODOLOGIES: E-R Modeling, Star Schema, Snowflake Schema

PROFESSIONAL EXPERIENCE:

ETL/Informatica Developer

Confidential, Baltimore, MD

Responsibilities:

• Requirement Gathering and Data Analysis of all supporting systems.
• Designed Informatica mappings and data flows.
• Understand Business Requirements and translate into Technical Specifications.
• Developed Informatica processes to facilitate Daily, Weekly and monthly loading of data.
• Maintained staging area between source and target, performed all cleansing operations, aggregations etc.
• Extracted data from different source systems - Oracle, Teradata, DB2, My SQL, Flat Files and XML Files.
• Developed ETL programs using Informatica Power center 9.6.1/9.5.1 to implement the business requirements.
• Involved in enhancements and maintenance activities of the Enterprise Data Warehouse.
• Communicated with business customers to discuss the issues and requirements.
• Used most of the Transformations available in Informatica - Source Qualifier, Filter, Router, Lookup (Connected & Un Connected), Expression, Update Strategy, Transaction Control and Sequence Generator.
• Prepared mapping specification document, which gives the data flow and transformation logic for populating each column in the data warehouse table.
• Developed complex mappings using Lookup, SQL, Stored Procedure, and Filter while always striving to achieve the best performance.
• Used Debugger wizard to troubleshoot data and error conditions.
• Developed an ETL strategy to integrate disparate legacy sources to eliminate redundancy and create a single view of the Customer data for accurate business analysis.
• Using Informatica Power Center created mappings, sessions and workflows to load data from multiple Source databases and flat files into target Oracle.
• Used Parameters, Variables and Parameter Files for various Database Relational Connections to eliminate migration issues.
• Extensively worked on all the transformations like Filter, SQL, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence generator, Rank, Union, Joiner, Source Qualifier, etc.,
• Used different transformations for Extraction/Transformation, data cleansing and loading data into staging areas and Presentation Tables.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Has a very good knowledge of FACETS tool and Healthcare domain, Worked on the various modules like Subscriber/Member, Groups, Enrollment, Claims, Billing, Accounting, Provider, MTM and Utilization Management.
• Good experience on FACETS CTP (Claims Test Pro) and FACETS Testing.
• Translated business requirements into data warehouse design.
• Developed and scheduled the Jobs using Autosys Scheduler.
• Used UNIX Shell Scripts to automate daily and weekly runs and execute post session commands.
• Created sessions and workflows for processing and to populate the dimensions and facts in the star schema.
• Wrote and maintained numerous system utilities and web based applications with Perl.
• Worked on Perl templates which delivered content to various sites for customers.
• Worked with connected and unconnected look-up for implementing complex logic.
• Designing ETL strategy for both Initial and Incremental & CDC Loads.
• Worked extensively on SQL, PL/SQL and UNIX shell scripting.
• Expertise in using Teradata Utilities BTEQ, M-Load, F-Load, TPT and F-Export in combination with Informatica for better Load in to Teradata Ware House.
• Involved in the scrum discussions and agile methodology of development of the process of the project.
• Developed unit test cases and ensured that the results are right before moving to QA and Production.
• Worked with QA team on daily basis to follow up on the bugs and made sure the code is bug free before migrating to Production.
• Worked on Ruby scripting language.
• Developed and tested features in an Agile environment using Ruby.

Environment: Informatica Power Center 9.6.1/9.5.1 , Oracle 11g, PL/SQL, Teradata, UNIX, Shell Scripting, XML, Erwin r9.5.2/9.6, TOAD v12.0., AutoSys, BTEQ, Control M, FACETS, Perl, Ruby

ETL/Informatica Developer

Confidential

Responsibilities:

• Worked with various transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router transformations.
• Involved in the development of Informatica mappings and tuned for better performance.
• Extensively used ETL to load data from flat files to Oracle.
• Prepared mapping specification document, which gives the data flow and transformation logic for populating each column in the data warehouse table.
• Adjusted in Data Model and SQL scripts to create and alter tables.
• Worked extensively on SQL, PL/SQL and UNIX shell scripting.
• Analyzed the source system of ETL Maps.
• Designed and developed the fact/dimension entities.
• Co-ordination with Client Business & Systems team for QA.
• Performed the tuning of ETL SQLs, Designed ETL mapping based on Existing ETL logic.
• Compared actual results to expected results and suggested changes to mappings owned by others.
• Worked on new data model to form the single security master for all the Data Marts and retrofit the existing and new securities in the FACT tables.
• Designed and developed IDQ mappings for address validation / cleansing, doctor master data matching, data conversion, exception handling, and report exception data.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Used Type 1 and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Worked as a fully contributing team member with independent planning & execution responsibilities.

Environment: Informatica Power center 9.5/9.1, Netezza 7.1, Oracle 10g, SQL, PLSQL, Oracle SQL Developer, HP Quality center, MS Office, Oracle OBIEE 10g 10.1.3.4.1/11 g, and Linux.

Jr Informatica Developer

Confidential

Responsibilities:

• Translated business requirements into data warehouse design.
• Designed and maintained logical and physical enterprise data warehouse schemas using Erwin
• Used Star Schema approach for designing of Data Warehouse.
• Integrated different systems using Informatica server configuration. Extracted data from Flat files, Oracles Server, MS-Access and Loaded data into Oracle database using Informatica.
• Created Source definitions, Target definitions, Mappings, Transformations, Reusable Transformations, mapplets using Informatica Designer tool which includes Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and mapplet Designer.
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, and sequence generator, joiner Transformation.
• Created sessions, database connections and batches, Scheduled and monitored transformation processes using Informatica Server Manager.
• Used Informatica repository manager to backup and migrate metadata in development, test and production systems.

Environment: Informatica Power Center 9.5.1/9.1.1/8.6 , Business Objects, UNIX, SQL, PL/SQL, TOAD v11.6/ v12.0, Oracle 10g.