Summary
Overview
Work History
Education
Skills
Timeline
Generic

Karthik Kumar Gopeneti

Bangalore

Summary

Professional with 11 years of expertise in data warehousing and ETL processes utilizing Informatica PC, CDI-PC, and IICS. Experienced in managing the full project lifecycle from requirements gathering to production support. Demonstrates strong analytical and design skills, with proficiency in Linux Shell, Snowflake DWH, and SQL. As a Lead, effectively monitored team progress to ensure timely project delivery and adherence to deadlines.

Overview

11
11
years of professional experience

Work History

Offshore ETL Lead

Accenture Services Pvt. Ltd. (Brand Managment Project)
04.2020 - Current
  • Designed and supported analytical environment for customer data, enhancing reporting capabilities for business users.
  • Conducted user meetings to gather requirements and translated complex inputs into ETL design documentation.
  • Directed team in analysis, development, and delivery of support and project work.
  • Developed Extract-Transform-Load (ETL) Informatica workflows for data migration using batch and incremental strategies.
  • Trained and mentored team members on job performance, behaviors, and competencies.
  • Identified bottlenecks in ETL code; performed performance tuning and partitioning to enhance efficiency.
  • Organized daily technical discussions with onsite teams and clients to align expectations for offshore delivery.
  • Assigned tasks to team members for incident management, change requests, service requests, and job monitoring.

Senior ETL Developer

Accenture Services Pvt. Ltd. (Customer Data Environment)
01.2016 - 03.2020
  • Designed and supported global analytical environment, integrating online and offline customer data for TWDC.
  • Analyzed data issues during regular refresh cycles, implementing fixes per client specifications within SLA.
  • Identified bottlenecks in mappings and sessions, contributing to performance tuning initiatives.
  • Managed server activities including maintenance, SLA adherence, job monitoring, and user issue resolution.
  • Received and implemented new business requirements, modifying existing code and developing new logic in Informatica.
  • Led complex design changes with comprehensive client communication throughout project lifecycle.
  • Conducted analysis, build, and unit testing for data integration, ensuring timely deliverables.
  • Automated processes with Unix scripts, saving approximately 100 hours monthly.

ETL Developer

Accenture Services Pvt. Ltd. (Symentec Org Clone)
01.2015 - 10.2015
  • Executed data migration for separation of business entities, establishing independent IT infrastructure.
  • Designed ETL specifications to align with project requirements and objectives.
  • Developed source-to-stage and load mappings per ETL design specifications.
  • Created and configured workflows, worklets, and sessions for data transport to Salesforce using Informatica Workflow Manager.
  • Monitored load jobs and conducted reject analysis to ensure data integrity.
  • Facilitated migration of Informatica objects across QA, UAT, and production environments.
  • Performed error handling and bug fixes for defects in development and QA stages.
  • Utilized SFDC data loader for effective data loading, updating, and exporting.

Education

B.E - Electronics and Communication (E&CE)

R.Y.M Engineering College
Bellary
01.2014

12th standard -

Bellary Independent P.U College
Bellary
01.2010

10th standard -

St. John’s High School
Bellary
01.2008

Skills

  • Informatica PowerCenter
  • Microsoft SQL
  • IDMC and IICS
  • Snowflake data warehousing
  • Unix and Linux scripting
  • SAP BO reporting
  • Tableau reporting
  • Maestro scheduling tool
  • GitHub/GitLab version control
  • Adobe Omniture analytics

Timeline

Offshore ETL Lead

Accenture Services Pvt. Ltd. (Brand Managment Project)
04.2020 - Current

Senior ETL Developer

Accenture Services Pvt. Ltd. (Customer Data Environment)
01.2016 - 03.2020

ETL Developer

Accenture Services Pvt. Ltd. (Symentec Org Clone)
01.2015 - 10.2015

B.E - Electronics and Communication (E&CE)

R.Y.M Engineering College

12th standard -

Bellary Independent P.U College

10th standard -

St. John’s High School
Karthik Kumar Gopeneti