Sr ETL Informatica Lead

Sanath K Vijaya Kumar **** N **th street, Unit *

414-***-**** Scottsdale, Arizona 85250

Senior ETL Informatica Lead

Summary

Over 10+ years of experience as IT Professional with proven experience in Business Intelligence (BI)/Data Warehouse systems, provided BI expertise, designed and developed data models by translating user requirements into data flows and data mapping.

Strong experience in developing ETL mappings and scripts using Informatica Power Center with client tools like Designer (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplets Designer and Mapping Designer), Repository Manager, Workflow Manager and Workflow Monitor.

Hands on experience in various transformation techniques such as Filter, Sorter, Router, Normalizer, Rank, Sequence generator, Source Qualifier, Expression, Aggregator, Joiner, Lookup, Update strategy, XML and custom transformations.

Expertise and working experience in establishing the process, Waterfall and Agile development methodology standards at all phases of an Enterprise Data warehouse.

Worked on relational database - Oracle 9i/10g/11g and DB2 : Hands on experience in SQL, PL/SQL, creating indexes, developing stored procedures, functions and packages using PL/SQL.

Extensive experience in the areas of Systems Analysis, Fit-Gap Analysis, Business Process Reengineering, Product Configuration & Implementation, Configuration Management, Development & Deployment ETL tools & Reports, conducting testing and validations, conducting user training, documentation and Production Support.

Experienced in filtering and loading only the data that is changed into the data warehouse which is also known as change data capture (CDC).

Very strong analytical, technical and business skills in architecting and designing using ETL applications.

Technical leadership, mentoring and managing senior designers, developers and development teams.

Experience in all the phases of Data warehouse life cycle involving Requirement gathering, Implementation & Design, Development, Testing and Deployment and production support.

Designed complex ETL mappings like slowly changing dimensions, performed critical performance tweaking stages with partitioning, persistent cache and extensive use of mapplets.

Good knowledge of Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Schema Modeling, FACT and Dimensions Tables.

Experience in integration of various relational and non-relational data sources like Oracle, SQL Server, MS Access, VSAM and Flat Files into data warehouse.

Developed several testing strategies – unit, integration, system, and high-availability and disaster recovery – which constituted to more than 30% of overall project effort and worked with the other developers in the project to maintain the Informatica code standardization and document with naming conventions standards.

Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.

Have good knowledge of integrating with Informatica Cloud Services through connectors and APIs

Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Event Wait, Event Raise, Timer etc).

Experience in Performance Tuning of sources, targets, mappings, transformations and sessions, by implementing various techniques like partitioning techniques and pushdown optimization, and also identifying performance bottlenecks.

Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.

Good understanding of Relational Database Management Systems (RDBMS) like Oracle 11g/10g and DB2

Involved in Unit testing, Integration testing to check whether the data loads into target are accurate.

Proficient in interaction with the business users by attending meetings with the clients in Requirements gathering phase.

Excellent analytical/ communication skills and good team player.

Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple homogenous and heterogeneous sources into desired target tables / files.

Technical Skills

Environments Windows, UNIX, Linux

ETL Tools Informatica Power Center 9.6/9.1/8.X/7.X

Reporting Tools BI, Microsoft SSRS, QlikView, Tableau, SAS

Databases Oracle 10g/11g, Teradata, SQL server 2008, DB2

Client Tools/Utilities SQL developer, TOAD 9.x, Autosys, Tivoli

Automation Tool Windows PowerShell

Programming Languages PL/SQL, UNIX Shell Scripting,

Education

Bachelor of Engineering, Telecommunications - June 2005

Visveswaraiah Technological University, Karnataka India

Experience

Department of Transport, Madison WI May 2014 – Till date

Sr. Informatica Developer/ Informatica Lead

Currently working as a programmer for various data migration projects from legacy systems to People Soft and couple of other projects. in Enterprise Business Application Service Department.

The Wisconsin Department of Transportation (WisDOT) is a governmental agency of the U.S. state of Wisconsin responsible for planning, building and maintaining the state's highways. It is also responsible for planning transportation in the state relating to rail, including passenger rail, public transit, freight water transport and air transport.

Projects - STAR conversion, FMIS Enhancement project.

Responsibilities:

Collaborating with business users, subject matter experts to gather requirements and closely working with support team to document the requirements, procedures and standards.

Responsible for analyzing the system and creating function specification document for the project and define the scope, tasks for the project.

Designing Informatica complex mappings with transformations such as Aggregator, Expression, Joiner, Filter, Source Qualifier, connected/unconnected Lookups, Normalizer, Union, Stored procedure and Router Transformation to transform and load the data from and in to flat files and relational tables. Mainly involves DB2 and Oracle.

Developing Informatica Workflows, Sessions associated with the mappings using workflow manager.

Identifying and loading only changed data by comparison method.

Identifying and eliminating the bottlenecks for increasing the performance.

Developing BI reports and SAS reports either planned or adhoc as per the user requirements.

Worked on production code deployment activities.

Migration of objects in all phases (DEV and QA) of project and trained other developers in the team on all the perspectives.

Creating mappings using pushdown optimization to achieve good performance in loading data into Oracle.

Work on reusable mapplets, which were used across the applications.

Developing UNIX Shell scripts for processing, extracting and directing the feeds to multiple other Systems/Vendors.

Performing unit tests on the Informatica code using the Informatica Debugger and by manually checking through SQL Queries. Performed regression testing too. Generated testing data for load testing.

Work on implementing the new change requests and performing Release management activities.

Environment: Informatica Power center 9.6, BI Universe, SAS, DB2, UNIX scripts, Oracle 11g, PL/SQL, Informatica Cloud Services.

Northwestern Mutual Insurance Milwaukee, WI Jul 2008 – May 2014

Informatica Developer

Northwestern Mutual is a US financial service mutual organization based in Milwaukee, WI. Its products include life insurance, long term care insurance, disability insurance, annuities, mutual funds and employee benefit services.

Responsibilities:

Collaborated with product owners, stake holders and business clients to understand and define PBIs and provide high level estimation points.

Involved in system solution design and definition of function points, reviewing the said solution with support leads and project manager.

Data transformation Studio components like Mappers, Streamers and Parsers were used in the transformation of Unstructured to Structured formats and XML files to other formats.

Involved in designing the datamart based on the business requirements.

Involved in the data mart fact and dimension tables design using star schema, snowflake schema, OLAP/ROLAP tools.

Worked on production code deployment activities.

Designed and Developed Informatica complex mappings with transformations such as Aggregator, Expression, Joiner, Filter, Source Qualifier, connected/unconnected Lookups, Normalizer, Union, Stored procedure and Router Transformation to transform and load the data from and in to flat files and relational tables.

Extracted, Transformed and Loaded OLTP data into the Staging area and Data Warehouse using Informatica mappings.

Wrote complex SQL scripts on SQL to avoid Informatica joiners and Look-ups to improve the performance as the volume of the data was heavy.

Used stored procedures to create a standard Time dimension, drop and create indexes before and after loading data into the targets for better performance.

Migration of objects in all phases (DEV and QA) of project and trained other developers in the team on all the perspectives.

Performed Tuning by identifying and eliminating the bottlenecks occurred for increasing the performance.

Created mappings using pushdown optimization to achieve good performance in loading data into Oracle.

Developed mappings to load Type 2 and Type 3 data. Worked on mappings to capture filter and read only the data that is changed.

Captured data error records corrected and loaded into target system.

Worked on reusable Mapplets, which were used across the applications.

Configured workflows with Email Task which would send mail with session, log for Failure of a sessions and for Target Failed Rows.

Developed Shell scripting for processing, extracting and directing the feeds to multiple other Systems/Vendors.

Created several reports using SSRS, Microstrategy, Qlikview, Tableu, BI Universe.

Performed unit testing on the Informatica code using the Informatica Debugger and by manually checking through SQL Queries. Performed regression testing too. Generated testing data for load testing.

Used Debugger to troubleshoot the mappings.

Used Autosys Scheduler to schedule unix jobs that kicks of workflows / worklets.

Improved the performance of mappings and sessions.

Developed Event Wait Tasks for the workflow.

Developed the documentation for ETL mappings / ETL unit testing/ETL Integration Testing.

Extensively involved in performance tuning of mappings and SQLs.

Provided End-user training and post implementation support.

Worked on implementing the new change requests and performed release management activities.

Environment: - Informatica Powercenter 9.1, Oracle 10g, PL/SQL, TOAD, SQL server 2008, Microsoft SSRS, Qlikview, Tableu, SAS, BI universe and UNIX shell Scripting, Informatica Cloud Services.

Royal Bank of Scotland, Bangalore India Jan 2008 - July 2008

Informatica Developer

Royal Bank of Scotland (RBS), provides banking facilities throughout the UK and Ireland. It has around700 branches all over Scotland and Ireland.

Responsibilities:

Promote emphasis on tools and process to facilitate analytics

Worked on performance monitor counters for monitoring SQL Server environment.

Created triggers to keep track of changes to the fields of tables when changes are made.

Managed indexes, statistics and optimizing queries by using execution plan.

Performed regular reviews of the database to identify performance problems, inadequate programming, and data duplication problems.

Involved in the development of system test plan which included scope, objectives, resources, timelines etc. of the testing effort.

Developed reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures.

Handled unit and system integration testing

Prepared a help guide to system usage for the convenience of end users.

Analyzed the reporting service tool provided by Microsoft to generate reports using Oracle and SQL as backend and developed a similar application with SharePoint as backend.

Assisted in creation of SQL Server Analysis Services (SSAS) cubes for analysis.

Environment: SQL Server, Oracle, SSRS, Putty, SQL/PLSQL and Windows XP.

Software Engineer, Bangalore India June 2005 - Jan 2008

Informatica Developer

Responsibilities:

Analyzed the business requirements and functional specifications with the help from onsite team.

Created detailed design documents.

Developed and changed mappings as per the design documentation.

Performed unit testing and documented any issues/ defects that needed further discussion.

Developed and executed SQL queries, stored procedures, performed data validation as part of backend testing.

Developed reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures.

Executed more than 30 batch job applications, and was primary support and point of contact during off hour nightly batch cycle, apply rapid / firefight fixes immediately using HP Service Manager in case of production failure.

Created support repository document, knowledge sharing documents.

Actively involved in go live and production release maintained support for post implementation issues.

Environment: SQL Server, Power center, SSRS, SSAS, Putty, SQL/PLSQL and Windows 2000.

Achievements:

Received numerous Client Appreciations for each and every project I was involved in.

Have been flexible at work to take up learning of new languages based on the need in the projects without any formal training.

VISA : H1B VISA valid till Sep 2019.

Contact this candidate