ETL DEVELOPER

SAI KIRAN REDDY

Toronto, Canada

Contact No: 647-***-****; Email: ********************@*****.***

PROFESSIONAL SUMMARY:

Around 3 years of IT experience in analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehousing/Data mart design, ETL, OLAP client /server applications with excellent communication skills.

Extensively worked on Informatica power center Designer components Source Analyzer, Target Designer, Transformation Developer, Mapping Designer and Mapplet Designer.

Experience in translating business rules into ETL mappings by creating transformations (Expression, Aggregate, Unconnected and Connected Lookup, Router, Update Strategy, Filter, Joiner, Union), and developing Mappings.

Experience with all phases of Software Development Life Cycle (SDLC) such as developing, testing, migrating, administrating, and production supporting on various platforms like UNIX, Window XP/7.

Strong knowledge on Data warehousing modelling, Data mart, Star Schema and Snow Flake Schema.

Involved in discussions related to developing technical documents like source to target mapping, design document and as such.

Experience in performance tuning and optimization of the Sessions, Mappings, Sources and Targets.

Experience in writing complex SQL queries, PL/SQL, T-SQL stored procedures and Unix Shell Scripting.

Experience in Data warehouse environment working with Fact Tables, Dimensional Tables, handling Slowly Changing Dimensions and Surrogate Keys.

Strong knowledge on relational databases like Oracle 9i/10g/11g, SQL SERVER on different platforms like Windows/Unix Linux using GUI tools like TOAD, SQL DEVELOPER and SSMS.

Experience with scheduling tools such as Autosys for scheduling jobs and setting dependencies.

Knowledge on Informatica Data Quality (IDQ).

Strong Knowledge on BI tools like SSRS, developing reports, report templates and bar graphs.

Strong critical and analytical thinking, demonstrated ability to leverage data and draw meaningful conclusions and recommendations.

Self-starter with the ability to work independently and take initiative with very good communication skills.

Passionate about data and exploring new technologies by welcoming new challenges.

TECHNICAL SKILLS:

ETL Tool

Informatica PowerCenter 9.x/8.x, SSIS.

Operating Systems (OS)

WINDOWS 7/Vista/XP/2003/2000/NT/98/95, MS-DOS, Unix

RDBMS

Oracle 11g/10g/9i, Microsoft SQL Server.

Office Applications

Microsoft Word, Excel, Outlook, Access, Visio, Project, Power Point (2003/2007/2010).

Browsers

Internet Explorer, Mozilla Firefox, Google Chrome, Safari.

Languages

PL/SQL, T-SQL, C++, Python, C #.

BI Tools

SSRS

Scheduling Tools

Autosys

PROFESSIONAL EXPERIENCE:

Title: ETL Developer

Client: Shoppers Drug Mart

Project: BIDW (Rx and Sales)

Toronto Duration: May 2015 to June 2016

Description:

Worked on different initiatives of SDM’s BIDW project. Shoppers Drug Mart (SDM) has implemented a BI architecture as part of its BI program initiative. A key component in this BI architecture is the creation of a data staging area which will implement the key design principals of “dependent data marts” and “one extract per source system”.

Responsibilities:

Develop, test, and implement Data Warehouse EDS for SDM.

Participate in requirement gathering discussions and interact with solution architects

Developed source-to-staging and staging-to-target jobs which includes data cleansing and data validation logics.

Build, tuned and optimized complex ETL code as part of evolution of the Enterprise Data Warehouse.

Design, develop, test, and implement UNIX scripts to automate the process.

Developing automated extracting, transforming, and loading data from multiple source systems.

Analyzing data in source systems to identify data cleanliness issues.

Developed various mappings using different Transformations including Router, Aggregator, Joiner, Lookup, Update Strategy, Stored Procedure, Sorter, Filter, Source Qualifier, Expression, Union and Sequence Generator to store the data in target tables.

Analyze business and system requirements, manage development of specifications to create and execute detailed test plans, and verify bug fixes.

Used workflow manager to create workflows, sessions, and also used various tasks like command, email.

Developed JIL files in autosys to schedule and set dependencies between workflows.

Developed stored procedures in PL/SQL where necessary.

Developed and implemented unit test plan, unit test results and code walkthroughs.

Migration of objects between environments, from Local (DEV) to SIT (System Integration Testing).

Provide SIT, UAT and also on call production support.

Developed reports using SSRS.

Designed and created Report templates, bar graphs and pie charts.

Environment:

Informatica Power Center 9.5.1 used as ETL tool, Oracle 11g as Database

UNIX shell scripting

Autosys scheduler tool, SSRS.

Title: JR ETL Developer

Client: Bell

Projects: Payment System

Toronto Duration: April 2014 to September 2014

Responsibilities:

Extensively used Informatica Client tools – Power Center Designer, Workflow Manager,

Workflow Monitor and Repository Manager.

Created Source to Target mapping from design and requirement documents.

Provide estimates for ETL development and Testing.

Analyse document/develop and test new changes to existing mappings.

Designed and developed mappings using Source qualifier, Aggregator, Joiner, Lookup, Router, Sequence generator, Expression, Filter and Rank transformations.

Designed and developed test cases for unit testing.

Recommend defect resolution.

Environment:

Informatica PowerCenter 8.6 used as ETL tool.

Oracle 11g as Database.

UNIX shell scripting.

Title: Jr ETL Developer

Vendor: A and U IT Consultancy Private Limited

Client: Bank of America

Hyderabad Duration: May 2012 - Aug 2013

Bank of America is an American multinational banking and financial services corporation headquartered in Charlotte, North Carolina. This project is on Mortgage Data Integration. Goal of this project is to build a data warehouse with company’s mortgage data which is stored in different sources. Data is pulled from sources like Oracle and flat files.

Responsibilities:

Developed and Maintained ETL (Data Extract, Transformation and Loading) mappings to extract the Data from multiple source systems like Oracle and Flat Files.

Used Informatica Designer tools like Source Analyzer, Mapping Designer, Target Designer, Transformation Developer, Mapping Designer and Mapplet Designer.

Worked extensively on Lookup, Router, Filter, Aggregator, Expression and Update Strategy Transformations.

Implemented data cleaning and data profiling logics.

Implemented Performance Tuning at mapping, session, source and target level as well as writing complex SQL Queries.

Developed stored procedures using PL/SQL.

Developed mappings involving slowly changing Dimensions Type 1 and Type 2.

Execute unit tests to ensure the accuracy of code changes, and to verify that data integrity and performance requirements are met.

Involved in developing jobs and setting dependencies between jobs in autosys level

Created email tasks in workflows to send post session and suspension emails as per user requirements

Performing Ad-hoc queries using SQL to check for consistency of the data in the tables and to update the tables as per the requirements.

Environment:

Informatica PowerCenter 8.6 used as ETL tool.

Oracle 11g, UNIX shell scripting.

Autosys Scheduler tool

EDUCATION:

Master of Engineering – Carleton University (Sep 2013 -May 2015)

Electrical and Computer Engineering

Bachelor of Technology – JNTU (Hyderabad) (Sep 2008- May 2012)

Electronics and Communication Engineering

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate