Data Developer

SUMMARY

Around * years of experience in all phases of Analysis, Design, Development, Testing, Implementation and support of Data Warehousing applications.

Experienced in complete Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC), SDLC methodologies (Waterfall and Agile)

Implemented Slowly Changing Dimensions in Dimension tables as per the requirements

Expert usage knowledge in Informatica Power Center for Extraction, Transformation and Loading of data using heterogeneous source & target systems like Flat files (fixed width and delimited), Oracle, SQL Server, Teradata etc.

Extensively worked on Informatica Designer Tools (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer) and Workflow Manager Tools (Task Developer, Worklet and Workflow Designer), Workflow Monitor and Informatica Power exchange.

Experienced in implementing Change Data Capture (CDC) using Informatica Power Center.

Experienced in debugging mappings by analyzing the data flow and evaluating transformations.

Experienced in Performance tuning of data flow through source, target, sessions and mappings, identifying and resolving performance bottlenecks at various stages using techniques like Database tuning and Session Partitioning.

Proficient in using TOAD, SQL* PLUS for developing stored procedures, functions, views, triggers and complex queries using Oracle PL/SQL

Involved in supporting and performing Unit testing, System Integration testing, UAT and production support for issues raised by application users.

Experienced in writing UNIX Shell Scripts

Experienced in preparing ETL Specifications and Technical Design documents.

Experienced in preparing test strategy, developing test plan, detailed test cases, and writing test scripts by decomposing business requirements, and developing test scenarios to support quality deliverables.

Excellent communication skills, good organizational skills, self-motivated, hardworking, ability to work independently or cooperatively in a team, ability to grasp quickly and learn fast and open to new technologies.

Excellent team member with problem solving, troubleshooting skills and interpersonal skills.

TECHNICAL SKILLS

ETL Tools - Informatica 8.x/9.x/10.x, Informatica Power Exchange 9.5

Scheduling Tools – Autosys

Databases - Oracle11g/10g, MS SQL Server 2012/2005/2000, Teradata, SQL Plus, TOAD

Testing Tools – Mercury Quality Center (HP ALM)

Operating Systems – Windows, UNIX

Programming Languages – SQL, PL/SQL, UNIX Shell Scripting

Methodologies - E-R Modeling, Star Schema, Snowflake Schema, SDLC (Waterfall and Agile)

PROJECT SUMMARY

QDOBA Mexican Eatery May 2017 – current Denver, CO

Informatica Developer

QDOBA Mexican Eatery is a chain restaurant and caterer that specializes in customizable Mexican food. Their Data Warehouse extracts data from a sales analytics solution which consumes data from different POS files. The data coming in from these POS files had multiple issues with data inconsistencies, performance and excessive space utilization. This project was to solve these issues by optimizing the solution at all three levels: Database, ETL and Reporting System. .

Responsibilities:

Involved in understanding the business requirements, designing and loading the data into the data warehouse

Worked extensively with Informatica Power Center

Worked with both Active and Passive Transformations

Worked on loading data from multiple sources like Flat Files, Oracle DB

Extensively worked with Slowly Changing Dimensions

Created SQL queries, Indexes, Packages, Functions, Procedures, Views, and Database Triggers.

Involved in Performance Tuning of new and existing mappings/sessions at the Mapping Level and Session Level

Extensively worked on performance tuning of Lookups

Worked with reusable objects like Re-Usable Transformation and Mapplets

Extensively worked with aggregate functions and performance tuning of Aggregator Transformation

Involved in handling various loads and troubleshooting of errors that were encountered

Extensively worked with the Debugger for handling the data errors in the mapping designer

Environment: Informatica Power Center 9.x/10.x, Informatica Power Exchange 9.5, Oracle 11g/10g, SQL Server Management Studio, UNIX, Autosys

Sony Electronics Inc. Feb 2014 – Feb 2015 San Diego, CA

Informatica Developer

Sony Electronics is a leading provider of audio/video electronics and information technology products for the consumer and professional markets. The main objective of the project was to implement a warehouse Billing and Freight Billing Data and Sales data mart. Used ETL Informatica PowerCenter 9.x for loading data from Oracle/Flat Files into target Data Mart

Responsibilities:

Performed major role in understanding the business requirements, designing and loading the data into data mart

Used Informatica PowerCenter to load data from multiple sources like Flat Files and Oracle DB

Created complex mappings using various Active and Passive transformations for populating target table.

Implemented slowly changing dimensions for Change data capture.

Created SQL queries, Indexes, Packages, Functions, Procedures, Views, and Database Triggers.

Worked with Informatica Power Center and it’s client tools and their components

Involved in Performance tuning of the Informatica mappings

Designed and Developed ODS to Data Mart Mappings/Sessions/Workflows.

Involved in Debugging and Troubleshooting Informatica mappings.

Populated error tables as part of the ETL process to capture the records that failed the migration.

Worked with Scheduling team in creating and scheduling jobs in Autosys

Developed test cases for Unit, Integration and system testing

Involved in Maintaining the Repository Manager for creating Repositories, user groups, folders and migrating code from Dev to Test, Test to Prod environments.

Extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.

Developed UNIX Shell Scripts

Environment: Informatica PowerCenter 9.5, Oracle 11g, Teradata, SQL, PL/SQL, Flat Files, UNIX, Windows XP

United Components, Nov 2012 – Dec 2013 Evansville, IN

Informatica Developer

The project was to build a data warehouse for operational and strategic reporting. The objective was to integrate different source systems into homogeneous environment to build Enterprise Data Warehouse. The four subject areas were Membership, Claims, Capitation and Provider.

Designed and developed ETL Processes based on business rules using Informatica PowerCenter

Worked extensively on complex mappings using Active and Passive Transformations

Was part of scripting team for shell script to automate and migrate data from ODS to Data

warehouse

Compared actual results to expected results and suggested changes to mappings owned by

others

Developed PL/SQL procedures for processing business logic in the database and use

them in a Stored Procedure Transformation

Involved in designing the mappings and also their performance tuning

Developed a number of Complex Informatica Mappings, Mapplets and Reusable Transformations

Migrated Mappings, Sessions and Common Objects from Development to Test and to Production

Environment: Informatica PowerCenter 9.x, Oracle 10g, SQL, PL/SQL, Windows, UNIX, Toad

TATA CONSULTANCY SERVICES Feb 2010 to Jun 2012 Mumbai, India

iCALMS (Internal Project) - ETL Tester

iCALMS is a Learning Management software (LMS) which keeps track of roles, roles history, training and competency records of employees. It has different access types for users and is integrated with the company ERP system.

Responsibilities

Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document

Tested design strategy of the Extract, Transform and Load for various ODW tables

Tested mappings with the Design Documents and also performed testing for various sample data

Promoted Unix/Informatica application releases from development to QA and to UAT environments

Worked on writing SQL queries as per the mapping document rules and validate them against the tables.

Created test suites for functional and regression testing.

Worked with all Teradata load utilities.

Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata

Used Quality Center for all test phases as a repository, test management, test execution, and test reporting activities

Environment: Informatica PowerCenter 9.x, Microsoft Word, XML, Mercury QC 9.0, Oracle 9i/10g, Agile, SQL Server, HTML, Toad 7, Windows XP

TATA CONSULTANCY SERVICES Nov 2008 – Jan 2010 Mumbai, India

iCALMS (Internal Project) - QA Manual Tester

iCALMS is a Learning Management software (LMS) which keeps track of roles, roles history, training and competency records of employees. It has different access types for users and is integrated with the company ERP system.

Responsibilities:

Generated Test Scenarios, Test Cases, and Test data based on technical specifications and BRD

Responsible for Functional Test execution, Smoke, Sanity and, Regression, exploratory testing, creating and maintaining the Traceability Matrix

Involved in Defect management using Mercury QC along with coordinating with the development team to follow through the bug life cycle

iCalms being a web tool, was involved in Browser Compatibility testing

Performed data Validation using SQL queries

UAT -involved in the User Acceptance Testing (UAT), coordinated with different teams involved for test data.

Involved in documenting QA procedures

Environment: Mercury Quality Center 8.0, TOAD, XML, Oracle 9i

Contact this candidate