SUMMARY

• Over 7+ years of IT experience in the Analysis, Architecture, Design, Development, Testing and Implementation of Database Applications, Business Intelligence solutions using Data Warehousing & ETL tools.
• Excellent knowledge of Software Development Life Cycle (SDLC) with industry standard methodologies like Waterfall and Agile including Requirement analysis, Design, Development, Testing, Support and Implementation.
• Expertise and hands on experience in RDBMS, Data Warehouse Architecture, Inmon and Ralph Kimball Technologies and thorough understanding and experience in data warehouse and data mart design.
• Good understanding of Data Models (Dimensional & Transactional), Conceptual/Logical & Physical Data Models, DWH Concepts, ER diagrams, Data Flow Diagrams/Process Diagrams.
• Knowledge in designing and developing Data marts, Data warehouse using multi - dimensional Models such as Snow Flake Schema and Star Schema using Facts & Dimension tables.
• Expertise in development and design of ETL methodology for supporting data transformations and processing,in a corporate wide ETL Solution using Informatica Power Center 9.5/9.1/8.6/8.5/8.1.1/7.1.3/7.1.1/7.0 (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer).
• Experienced in creation of reusable objects Mapplets & Transformations using Mapplet Designer and Transformation Developer.
• Experience in Performance Tuning of Sources, Targets, mappings and using Push Down Optimization, different Session Partitioning techniques like Round robin, Hash-Key,Range & Pass Through.
• Business Intelligence experience using Cognos, and Working knowledge of Business Objects XI R2.
• Experience in setting up Workflows for Concurrent execution.
• Experience in UNIX Shell scripting for high volume data warehouse instances
• Proficiently rendered services on Oracle 11g/10g/9i/8i, SQL Server, SQL, PL/SQL
• Expertise in utilizing Oracle utility tool SQL Developer and expertise in Toad for developing Oracle applications.
• Involved in setting up the standards for Architecture, design and development of database applications
• Expertise in Database development skills using SQL, PL/SQL, Stored Procedures, Functions, Views, Triggers and complex SQL queries. Proficient using TOAD, SQL Developer for system testing of the reports.
• Worked in 24/7 production support of ETL and BI applications for large Life Sciences & Healthcare data warehouses for monitoring, troubleshooting, resolving issues.
• Experience reviewing Test plans, Test cases and Test case execution. Understanding business requirement documents and functional specs and then writing test cases using Quality Center. Also played an active role in User Acceptance Testing (UAT) and unit, system & integration testing.
• Highly motivated team player with ability to lead, manage and work in all environments to meet deadlines.
• Quick Learner with strong problem solving skills and excellent in communication, presentation and interpersonal skills.

TECHNICAL SKILLS

Environment: UNIX, Sun Solaris 5.8/5.6,AIX5.3/4.3, HP-UX, DOS, Linux, Windows 98/NT/2000/XP/Vista/7, SOAP.

Database: Oracle 11g/10g/9i/8i/, SQL Server, IBM DB2.

Languages: XML, UML, UNIX, Shell Scripting (Bourne, Korn), SQL, PL/SQL, T-SQL

Tools: Putty, SQL* Plus, TOAD, SQL*Loader.

ETL Tools: Informatica 9/8.x/7.x

Reporting Tools: Business Objects, Cognos

Data Modeling: ERwin, Star Schema, Snow Flake Schema, Extended Star Schema, Physical And Logical Modeling, Ralph-Kimball Methodology, Bill-InmonMethodology, MS Visio.

PROFESSIONAL EXPERIENCE:

Confidential, IL

Sr. ETL Informatica Developer

Responsibilities:

• Responsible for Requirement Gathering from the client and Analysis of the same
• Responsible for converting Functional Requirements into Technical Specifications
• As a Sr ETL developer provided suggestions and improvements to adhere to the standards
• Prepared the Code Review Checklist, Standards document and Reusable components to be used across multiple projects
• Used Push Down Optimization and Partitioning to improve the performance on Informatica
• Developed mappings using Filter, Router, Expression, Source Qualifier, Joiner, Connected & Unconnected Look up, Update Strategy, Stored Procedure, Sequence Generator and Aggregator Transformations.
• Wrote SQL-Overrides and used filter conditions in source qualifier thereby improving the performance of the mapping.
• Implemented complex business rules in Informatica Power Center by creating Re-usable Transformations, and working with Mapplets.
• Implemented performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks.
• Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
• Used Session Logs, and Workflow Logs for Error handling and Troubleshooting in the development environment
• Good understanding of various lookup caches like Static Cache, Dynamic Cache, and Persistent Cache
• Responsible for Unit Testing of mappings and workflows
• Extensively worked on UNIX Shell scripting and BTEQs to extract the data from the warehouse
• Experienced in using Workload Manager(WLM) for scheduling and running the on-demand or scheduled jobs.
• Involved in Performance Tuning (Both Database and Informatica) and there by decreased the load time
• Involved in Design review, code review, Performance analysis.
• Effectively communicated with the Business Partners and team members, the problem and the expected time of resolution.
• Responsible for providing timely feedback and necessary help/cooperation to meet client expectations

Environment: Informatica Power center (v9.1), Teradata 13.1, Oracle 11g, UNIX AIX-V6, Workload Manager(WLM)

Confidential, WI

Sr ETL Informatica Developer

Responsibilities:

• Developed and supported the Extraction, Transformation, and load process (ETL) for data migration using Informatica power center.
• Responsible for Requirement Gathering Analysis and End user Meetings.
• Responsible for converting Functional Requirements into Technical Specifications.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, DB2 and Flat Files.
• Developed Re-usable Transformations and Re-Usable Mapplets.
• Used various transformations like Lookup, Filter, Normalizer, Joiner, Aggregator, Expression, Router, Update strategy, Sequence generator and XML Generator Transformations in the mappings.
• Used XML spy tool to validate the input source XML files.
• Worked on XML Parser transformation to read the XSD file and build the source definition and accordingly to read the XML source file.
• Worked with Shortcuts across Shared and Non Shared Folders.
• Conceptualized and developed initial and incremental data loads in Informatica using Update strategy transformation.
• Developed Mappings for Type 1 and Type 2 Slowly Changing Dimensions.
• Responsible for Performance Tuning at the Source, Target, Mapping and Session Level.
• Created Pre and Post Session Scripts for checking file existence.
• Responsible for Unit testing and Integration testing of mappings and workflows.
• Documented existing mappings as per standards and developed template for mapping specification document.
• Provided excellent customer service to the internal functional team by pro-actively following up with the issues on hand (through detailed emails and by setting up short meetings).
• Bugs found during testing were analyzed (root cause analysis) beyond their obvious reason to extrapolate various errors that can occur in future.

Environment: Informatica Power Center 9.5.1, SQL Server 2012/2008, T-SQL, Oracle 11gShell Scripts, UNIX, Quality Center, Zena scheduling tool.

Confidential, GA

ETL Developer

Responsibilities:

• Involved in the Design, Development, Testing phases of the Check, ATTF & Billing Interfaces.
• Worked on XML files and Structured and CSV files.
• Converted Mappings existing in the Informatica B2B to Informatica Powercenter.
• Actively involved in requirements gathering, creating design specifications and ETL design documents
• Created Informatica Mappings to load data and used transformations like Stored procedure transformation,
• Scheduled Power Center workflows through the Informatica Scheduler.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings,
• Created Pre and Post Session Scripts using Unix for checking file existence
• Responsible for Unit testing and Integration testing of mappings and workflows
• Involved in Design review, code review, Performance analysis.
• Troubleshooted the defects encountered in SIT & UAT and provided resolutions.
• Involved in the development of Informatica mappings and also performed tuning for better performance
• Monitor, troubleshoot batches and sessions for daily,weekly and monthly extract data loads
• Worked with the Informatica Admin team for smooth and successful deployments to higher environments.

Environment: Informatica 9.0.1, Oracle 11g, Toad,XML,Unix

Confidential, CA

ETL Developer

Responsibilities:

• Worked on complex mappings and always guided the team when stuck and ensured timely delivery of the ETL components.
• Created STM’s (Source to Target Mappings) for data files into the PTY model.
• Worked on Subversion SVN for maintaining documents and code.
• Involved in the Design and Implementaton of the Data Quality framework for Error handling and file validations
• Troubleshooted and Debugged Macros in excel to run SQL queries using macros on Oracle to check for validations before the loads.
• Cleansed and migrated HCO & HCP data, Integrated Medpro licensing data to enable sampling processes and compliance reporting, processing of sales data from WKHLTH and IMS (prescriber master, customer master, payor master and DDD outlet master) through informatica.
• Built reusable mappings,transformations using Informatica Designer
• Involved in performance tuning of Informatica and optimizing the performance by identifying and eliminating Target, Source, Mapping, and Session bottlenecks while loading into Sales Force
• Involved in Design review, code review, Performance analysis.
• Involved in migration of the Informatica components for multiple releases
• Involved in Testing of all the Interfaces with huge amount of data and fixed bugs accordingly within the Mappings/ Workflows
• Used Redwood to schedule UNIX shell scripts and Informatica jobs

Environment: Informatica 8.6 ETL, Oracle 11g Database, Redwood Scheduling, Subversion code control, Mercury Quality Center, Salesforce.com

Confidential, OH

ETL Developer/Database Developer

Responsibilities:

• Involved in analysis of database schemas and design of star schema models for Complaints, Sales and Inventory modules.
• Maintained documentation for every process including the Mapping and Transformation Rules, Source and Target definitions, Output Flat file locations, Shell Scripts and Template files directories
• Created a test plan and a test suite to validate the data extraction, data transformation and data load and used SQL and Microsoft Excel.
• Importing source/target tables from the respective databases and created reusable transformations and mappings using Designer Tool set of Informatica.
• DevelopedInformaticamappings by usage ofaggregator, SQL overrides in lookups, source filterandsource qualifierand data flow management into multiple targets using router transformations.Creating sessions and work-flows for the Informatica mappings.
• Used various transformations of Informatica, such as Source Qualifier Transformation, Expression Transformation, Look-up transformation, Update Strategy transformation, Filter transformation, Router transformation, Joiner transformation etc., for developingInformaticamappings
• Loading of Data to Staging Area
• Created Informatica mappings to load the data from staging to dimensions and fact tables.
• Created new Shell Scripts for File Renaming, Moving files from one directory to another etc... All these Scripts were used in the Post Session Command within the Informatica Workflow
• Used Pmcmd to run Informatica workflows and automated the processes using UNIX Shell scripts.
• Interacted with the business clients to resolve their issues/concerns post production implementation
• Created and maintained Migration documentation and Process Flow for mappings and sessions.
• Involved in migrating Power Center folders from Development to Production Repository using Repository Manager.
• Troubleshooted production defects and fixed Cognos reports
• Used Maestro to schedule UNIX shell scripts and Informatica jobs
• Changed the load schedules after a through testing with changes on job dependencies and reduced the daily load duration from 18 hours to 12 hours.

Environment: Kalido 8.2/8.3, Oracle 9i, Informatica 7.1.3,Maestro Scheduling, Mercury Quality Center, Cognos, PHP