Bala Krishna

Informatica Certified Developer

Ph: 512-***-****

Email: acxlci@r.postjobfree.com

PROFESSIONAL SUMMARY:

8+ Years of IT experience in development and design of ETL methodology for Implementations of Data warehousing Applications, supporting data transformations & processing in a corporate wide ETL Solution using Informatica, SQL Server and Oracle10g/11g.

Worked in all phases of the Software Development Life Cycle (SDLC).

Good experience on design & development of Informatica PowerCenter ETL code which includes mappings, mapplets, reusable transformations, shared objects, sessions and workflows. Also worked on advanced concepts like SQL transformation, dynamic lookup, Normalizer, Reusable sessions using parameters, Event Raise and Event Wait,..etc.

Experience on working with Business Intelligence data visualization tools with Specialization on Tableau.

Expert in creating SSIS packages for ETL (Extracting, Transforming and Loading) of data.

Worked on SQl Server database which includes creating and executing complex SQL queries, Functions, creating/maintaining stored procedures, Performance tuning of tables by partitioning and by creating appropriate indexes.

Worked on Oracle database which includes creating and executing SQL queries, PLSQL procedures, Functions, DDL, DML, Performance tuning of tables by partitioning and by creating appropriate indexes.

Worked in Healthcare, Finance, Manufacturing and Banking domains.

Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, and Flat Files into the staging area, ODS, Data Warehouse and Data Mart

Knowledge of deploying SSIS project in Integration Services Catalog, Deploying SSIS package with File System and SQL server.

Excellent capabilities in integration mappings including static cache lookup, dynamic, and persistence mappings for fact table mappings.

Expertise in working with Control M, Autosys and Tidal scheduling tools.

Experience in using TOAD, and SQL Developer.

Worked on Performance Tuning by identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.

Strong experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.

Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ)

Proficient in all phases of the Software development lifecycle (SDLC), including requirements definition, for Analysis, Design, System Implementation, Performance Tuning, Testing and Support.

Expertise in developing overall Test Methodology, Document, Test Plans, Test-Cases execution.

TECHNICAL SKILLS:

Databases : Oracle 8i/9i/10g/11g, SQL Server 2008/2005, Teradata, MS Access

Tools/Technologies : Informatica PowerCenter, IDQ, SSIS, SQL Loader

Operating Systems : UNIX, Linux, Windows 2000, Windows XP/9X/NT, VISTA, MS-DOS

Languages : SQL, PL/SQL, T-SQL, C, Java

GUI Tools : Visual Basic, Visual C#.Net

Internet Tools : ASP.Net, JavaScript, XML, HTML, CSS

Data Modeling Tools : Erwin, ER Studio

EXPERIENCE SUMMARY:

Project 4:

ETL Developer

Volkswagen Credit Inc, Libertyville, IL Jun 2014 - Till Date

Objective of Cloverleaf project is to bring all legacy IT systems of VCI into single IT platform using FIS Auto suite. With this, VCI can become Auto industry finance leader. Maintenance of IT systems becomes easy and resolution cost & time of issues can be reduced drastically.

Responsibilities:

Created detailed Technical specifications for Data Warehouse and ETL processes.

Developed ETL mappings to Extract data from source system and load to staging area.

Developed ETL mappings to Extract data from staging area and perform required transformations as per business requirements and load into ODS and Data Warehouse tables.

Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer.

Involved in all phases of SDLC from requirement gathering, design, development, testing, production, user training and support for production environment.

Researched and Analyzed complex SSIS packages which are used to populate Staging, Mapping and Datawarehouse Databases.

Created dashboards in tableau using the various sources of data from Excel sheets, Teradata.

Created and Published Tableau Dashboards into Tableau Server.

Analyzing the data from the source and creating mappings as per the HLD documents

Developed BTEQ's and customized SQL's as per mapping documents to fetch data from source and populate to the eCDW datawarehouse.

Used most of the transformations such as the Source Qualifier, Expression, Aggregator,

Filter, Connected and Unconnected Lookups, Joiner, update strategy and stored procedure.

Involved in Performance Tuning logic on sources, targets, sessions, mappings to provide maximum efficiency and performance.

Actively involved in issues of 'Performance Improvement of the SSIS packages for Staging, Mapping and Datawarehouse build.

Deployed SSIS packages using Project Deployment Model.

Created different Mapping for loading the data into targets using various transformations like Source Qualifier, Joiner transformation, Router, Update Strategy, Lookup transformation, Expressions, Aggregator, and Sequence Generator.

Developed test case documents and specification documents with standards to be followed across all the mappings.

Involved in Code migration to different Repositories (Dev/Test/Prod).

Created Informatica database connections,

Worked with DB links, SQL joins, cardinalities, loops, aliases, views, aggregate functions, analytical functions and stored procedures.

Created UNIX shell scripts to automate ETL jobs.

Involved in daily standup and scrum meetings to discuss the project progress and plan accordingly.

Environment: Informatica Power Center 9.5, Oracle, SQL Server, Tidal, ER Studio, SQL server 2012, SDLC, Visual Studio 2010 shell for SSIS

Project 3:

ETL / Informatica Consultant

Deluxe Inc, Shoreview, MN Aug 2012- Jun 2014

DELUXE Enterprise Data Warehouse gives the consolidated and summarized information to provide a strategic view of the data for decision-making purposes. The data warehouse is collection of divisional information derived from different data sources across their global locations. Data warehouse provide timely information on the company, the customers, orders and the market to the business.

Responsibilities:

Interacted with Business Users to understand the Business requirements and prepared technical documents for implementing the solutions as per Business needs.

Analyze the source systems data and the current reports at the client side to gather the requirements for the Data Warehouse Data Model.

Developed Tableau reports & dashboards using Tableau desktop.

Working with various active transformations in Informatica PowerCenter like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation

Implemented Slowly Changing dimensions Type 1 &Type 2 methodology for accessing the Transaction history of accounts and transaction information.

Developed and designed Data marts extensively using Star Schema.

Designed and Developed the Informatica workflows/sessions to extract from different Data Bases, transform and load the data into oracle.

Involved in full SDLC from requirements gathering and data model requirements, development, testing and migration of data and Production support.

Used Lookup Transformation to access data from tables, which are not the source for mapping and also used Unconnected Lookup to improve performance.

Migrating the workflows from development to testing and UAT environment.

Scheduled Work flows on the Informatica Server using Informatica workflow Manager.

Responsible for testing the mappings and ensure that the mappings do the transformations as proposed.

Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance

Scheduled, Run and Monitored sessions using workflow manager and workflow monitor.

Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.

Designed SSIS flow to pull source data into staging to perform data quality and cleansing before pushing into target database using SSIS 2012.

Extensive use of SSIS for loading and transferring data like Sequence containers, Query tasks with T-SQL queries and Data flow tasks in Control flow tasks.

Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures

Used PMCMD commands for stopping and starting workflows and tasks.

Developed UNIX scripts to automate different tasks involved as part of loading process and scheduling.

Involved in maintaining effective relations with co-workers and business People.

Implemented exception handling using event handlers in SSIS 2012 and identified critical exceptions to be notified and logged in database.

Take part in daily standup and scrum meetings to discuss the project lifecycle, progress and plan accordingly, which is the crux of Agile SDLC

Environment: Informatica Power Center 9, Oracle, SQL Server, SQL server 2012, SDLC, Visual Studio 2010 shell for SSIS, SSRS and SSAS, Unix.

Project 2:

Client: Magna Infotech, Bangalore, India

Duration: Sep 2009- Aug 2012

Role: Informatica Consultant

Description:

PCMBI is sales Data warehouse and consist of sales data about the Cummins Engines and parts. The data is consolidated and summarised to provide a strategic view of the data for decision-making purposes. The data warehouse is collection of divisional information derived from different data sources across their global locations. Data warehouse provide timely information on the company, the customer and the market to the business in terms of sales.

Responsibilities:

Responsible for development and support of ETL routines and designed Informatica loads required for populating the data warehouse and Experience in loading high-volume data, Tuning and troubleshooting of mappings and Created documentation to support for the Application.

Extensively used various Data Cleansing and Data Conversion Functions in various transformations.

Involved in Dimension modeling of Data warehouse designed the business process, grain, dimensions and measured facts.

Created necessary repositories using repository manager to handle the metadata in the ETL process.

Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, duplicate elimination and exception handling and monitoring capabilities of IDQ

Used IDE to identify data duplication, understand the quality of data and report generation.

Migrated the code into QA (testing) and supported QA team and UAT (User).

Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner, and Stored procedure transformations.

Implemented data warehousing techniques for Data cleansing, Slowly Changing Dimension Phenomenon's (SCD) and Change Data Capture (CDC)

Developed SSIS packages to extract data from different sources like OLTP databases, Excel files, Flat files, from FTP servers about Time Warner's usage data.

Applied various SSIS transformations like look-up, conditional-split, derived column data conversion extensively.

Responsible to collaborate with DBA and Data Architects on implementation of database changes.

Developed the control files to load various sales data into the system via SQL*Loader.

Worked on database links, SQL joins loops, aliases, views, aggregate conditions and also wrote various stored procedures, Functions and Triggers for processing business logic in the database.

Assisted in design and maintenance of Metadata environment.

Extensively worked with multi-dimensional expression data.

Involved in scheduling the Informatica jobs and UNIX scripts and Oracle procedures.

Resolving if any issues in transformations and mappings during the development.

Interacted with end users, regularly in order to generate the reports required.

Designed and created an Autosys job plan to schedule our processes.

Created Partitions through the session wizard in the Workflow Manager to increase the performance.

Environment: Informatica Power Center 8, UNIX, SQL Server, OBIEE, Business Objects, Visual Studio 2010 shell for SSIS, SSRS and SSAS

Project 1:

Client: Aurobindo pharma LTD, Hyderabad

Duration: May 2008- Sep 2009

Role: ETL Developer

Description:

Objective of Item Master project is to consolidate the Items data that are being used to manufacture various Cummins Engines in Cummins Engine Manufacturing plants across the world. This project helped Cummins, to have a global contact of Item information in Engine Business unit. The Item data that has been loaded by this project will be used by many projects that are in EBU DWH (Engine Business Unit Data Warehouse). It also reduces the Infrastructure and operational costs for Cummins in maintaining all Items Information that are being used in Cummins Engine manufacturing plants.

Responsibilities:

Developed various mappings, tasks and workflows in informatica.

Migrated the code into QA (testing) and supported QA team and UAT (User).

Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner, and Stored procedure transformations.

Scheduled, Run and Monitored sessions using workflow manager and workflow monitor.

Developed and validated SSIS package to load data in data warehouse using SSIS 2008 R2.

Involved in configuring monitoring for various ETL jobs and providing help document for support team to take action.

Worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.

Involved in Unit Testing and Integration Testing.

Involved in IQA and EQA.

Utilized Package Configurations and Event handlers in SSIS to make a package more portable and to handle errors in package.

Involved in the migration of the code.

Worked on Defects analysis and fix.

Worked on performance improvement.

Environment: Informatica Power Center 8, UNIX, SQL Server, OBIEE, Business Objects, SQL server 2008/ 2008r2, Visual Studio for SSIS, SSRS and SSAS

Contact this candidate