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
Bellary01.2014
12th standard -
Bellary Independent P.U College
Bellary01.2010
10th standard -
St. John’s High School
Bellary01.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