Summary
Overview
Work History
Education
Skills
Technical Expertise - Skills Tools
Experience Summary
Timeline
Generic

TARUN VENKAT

Kansas City

Summary

Dynamic Programmer Analyst with a strong track record at Cognizant Technology Solutions, specializing in ETL processes with Informatica PowerCenter and Oracle SQL. Recognized for optimizing workflows and boosting performance through innovative solutions. Exceptional analytical and communication skills enable effective collaboration in team settings to achieve project objectives.

Overview

3
3
years of professional experience

Work History

Programmer Analyst

Cognizant Technology Solutions, CTS
01.2022 - 12.2022
  • Created mappings, sessions and workflows to move data from source systems to target systems using Informatica PowerCenter.
  • Optimized existing ETL processes by analyzing performance bottlenecks and implementing best practices in Informatica PowerCenter.
  • Used Performance tuning techniques such as Partitioning technique and Bulk Loader options available within Transformations section while developing Mapping logic .
  • Implemented error handling logic for failed ETL loads using error log tables in Oracle Database or flat files generated by Informatica PowerCenter.
  • Documented all ETL processes created using Informatica PowerCenter.
  • Identified, debugged, and fixed system bottlenecks and problems.

Associate Software Engineer

Accenture Solutions Pvt. Ltd.
11.2019 - 11.2021
  • Comprehensive knowledge and considerable technological expertise in ETL strategies using Informatica PowerCenter, Oracle SQL, and Unix.
  • Involved in SCD Type 1 and SCD Type 2.
  • Worked on the target load plan and mapping parameters and variables.
  • Used to load data into target tables using Normal and Bulk Load.
  • Worked extensively in a team-oriented environment with strong, analytical, interpersonal, and communication skills.
  • Company Overview: Aon Hewitt (formerly known as Hewitt Associates) is a provider of human capital and management consulting services, headquartered in Lincolnshire, Illinois, in the United States.
  • Worked on PowerCenter client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformations Developer.
  • Used the transformations such as the Source Qualifier, Expression, Aggregator, Connected and Unconnected Lookups, Filter, Router, Sequence Generator, Sorter, Joiner, and Update Strategy.
  • Import the source and target to develop mappings by the designer.
  • Worked on the file loading process, including direct and indirect methods of Informatica.
  • Developed all the mappings according to the design document and mapping specs provided, and unit testing.
  • Used a debugger to identify bugs in existing mappings by analyzing data flow, and evaluating transformations.
  • Worked on the Target Load Plan and Mapping Parameters & Variables.
  • Monitored workflows and sessions using Workflow Monitor.

Education

Bachelor of Technology (B. Tech) - Mechanical Engineering

K L University
India

Master of Science - Information Technology

University of The Cumberlands
Williamsburg, KY

Skills

  • SQL
  • C
  • C
  • MySQL
  • Oracle SQL
  • Oracle 10g
  • Putty
  • WinSCP
  • SQL Server
  • Autosys

Technical Expertise - Skills Tools

Informatica Power Center, SQL, C, C++, Oracle 10g, Putty, WinSCP, sql server, Autosys

Experience Summary

Informatica Power Center, Data Warehousing solutions, Client/Server Applications, ETL strategies, Oracle-SQL, Unix, SCD Type1, SCD Type2, Target load plan, Mapping parameter & Variables, Normal & Bulk Load, True, analytical, interpersonal, communication

Timeline

Programmer Analyst

Cognizant Technology Solutions, CTS
01.2022 - 12.2022

Associate Software Engineer

Accenture Solutions Pvt. Ltd.
11.2019 - 11.2021

Bachelor of Technology (B. Tech) - Mechanical Engineering

K L University

Master of Science - Information Technology

University of The Cumberlands

Similar Profiles

CREATE PROFILE
TARUN VENKAT