Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Kishore Kotaru

Arlington,USA

Summary

  • Over 8 years of IT experience, with a strong focus on ETL development, data integration, and data warehousing using Talend Open Studio and Talend Data Fabric.
  • Worked on end-to-end ETL workflows for OLTP and OLAP systems, applying both Kimball and Inmon methodologies
  • Developed and maintained Talend jobs for extracting, transforming, and loading structured and semi-structured data from Oracle, SQL Server, MySQL, flat files, and JSON
  • Hands-on experience with Talend components, including tMap, tJoin, tFilter, tAggregateRow, tDenormalize, tNormalize, tJavaRow, tLogCatcher, and tReplicate.
  • Worked on the Talend Administration Console (TAC) for job scheduling, monitoring, deployment, and context management.
  • Developed reusable Joblets and parameterized Talend jobs for scalable and modular ETL design.
  • Migrated large volumes of data between heterogeneous systems, including AWS S3, Redshift, RDS, and on-prem databases, using Talend connectors.
  • Developed data quality routines using Talend DQ for profiling, standardization, and cleansing of source datasets.
  • Experience working with Hadoop ecosystem tools such as Hive, HDFS, Pig, and Sqoop to process big data pipelines.
  • Integrated Talend with cloud storage and APIs using AWS SDKs, making use of S3 buckets and Redshift clusters.
  • Worked on the performance tuning of Talend jobs using parallel execution, partitioning, and lookup caching.
  • Developed PL/SQL stored procedures, triggers, and functions to support data transformation logic and validation.
  • Performed data validation, unit testing, and system integration testing to ensure ETL job accuracy and reliability.
  • Worked on version control and deployment using Git, Jenkins, and Talend CI/CD plugins for job automation.
  • Familiar with Agile and Waterfall SDLC methodologies, collaborating closely with QA, DevOps, and data analysts to deliver ETL solutions on time.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Talend Developer

7-eleven
01.2021 - Current
  • Developed ETL workflows in Talend to ingest transactional and inventory data from POS systems into a centralized warehouse.
  • Created complex Talend jobs using tMap, tDenormalize, tUnite, tAggregateRow, and context variables to support retail data harmonization.
  • Worked on Talend CDC (Change Data Capture) to synchronize store-level data across regional warehouses.
  • Designed star schema and snowflake models to support analytics dashboards for real-time inventory monitoring.
  • Created reusable Joblets and Java routines to standardize retail data preprocessing logic.
  • Integrated Talend with AWS S3 and Redshift to support cloud-based data storage and analytics.
  • Configured Talend jobs in TAC, and scheduled them using Job Conductor for nightly incremental loads.
  • Developed UNIX shell scripts to automate job retries and alerting mechanisms for failed ETL processes.
  • Monitored job performance and tuned Talend pipelines to reduce data load time by 30%.
  • Worked with REST APIs to pull promotional and pricing data, and integrated it into the data lake.
  • Implemented row-level error logging and job statistics tracking using tLogCatcher and tStatCatcher.
  • Collaborated with the QA and BI teams to validate data completeness and accuracy across stores.
  • Created technical design documentation outlining ETL logic and source-to-target mappings.
  • Utilized Git for version control, and managed deployment pipelines using Jenkins.

Talend Developer

ABC Fitness
07.2018 - 01.2021
  • Developed data integration jobs in Talend to consolidate member activity, billing, and subscription data.
  • Extracted and transformed XML and JSON data feeds from third-party fitness platforms.
  • Built dimension and fact tables for fitness engagement and billing KPIs using Talend Studio
  • Designed parameterized Talend jobs using globalMap and context variables to allow for environment flexibility.
  • Worked on SCD Type 2 logic for member subscription history using tMap and tSurvive components.
  • Developed DQ profiling jobs to validate fitness tracker data accuracy and identify nulls and outliers.
  • Created staging and warehouse layers in Oracle and SQL Server based on business requirements.
  • Automated job execution and notifications for subscription processing using TAC triggers.
  • I wrote PL/SQL procedures to enrich customer attributes before final loading.
  • Integrated Talend with AWS SNS and Lambda to trigger downstream alerts based on churn signals.
  • Worked with QA to build test cases and validate edge scenarios in ETL processing.
  • Tuned high-volume jobs with parallelization and memory optimization.
  • Maintained metadata and lineage using Talend MDM and metadata manager features.
  • Participated in sprint reviews and contributed to Jira story grooming for ETL user stories.

Talend Developer

Accenture
09.2017 - 06.2018
  • Created scalable ETL solutions in Talend to support enterprise clients across finance, healthcare, and telecom domains
  • Migrated legacy ETL jobs from Informatica to Talend to improve maintainability and reduce licensing costs.
  • Used Talend’s tFileInput, tDBInput, tJavaRow, and tOutput components to support cross-platform data integration.
  • Built reusable templates and Joblets for common use cases, like address parsing, audit logging, and deduplication.
  • Participated in the installation and configuration of Talend Studio and TAC on client servers.
  • Developed Talend jobs for Oracle to Snowflake data migration, using bulk load techniques
  • Designed ETL frameworks to support audit trails and job execution lineage for compliance projects.
  • Created mapping documents and BRDs for new ETL pipelines as part of data modernization projects.
  • Performed root cause analysis and fixed transformation logic issues during UAT and production support.
  • Applied custom Java routines within Talend for data enrichment and validation logic.
  • Scheduled batch ETL jobs using Control-M, and configured job dependencies.
  • Provided production support, including job monitoring, troubleshooting, and performance tuning.
  • Created complex joins, filters, and aggregations for reporting and analytics requirements.
  • Participated in knowledge-sharing sessions and documentation handoffs for long-term project maintenance.

Education

Master of Science - Data Science

University of The Cumberlands
Williamsburg, KY
05-2024

Skills

  • Talend Open Studio 6x
  • Talend Administration Console (TAC)
  • Talend joblets, context variables, Java routines
  • Talend components: tMap, tJoin, tFlowMeter, tLogCatcher, tJavaRow, tReplicate, tDenormalize, tNormalize, tDie, and tWarn
  • Data warehousing and ETL design using star schema and snowflake schema
  • Kimball and Inmon dimensional modeling methodologies
  • Oracle 11g/10g/9i, MySQL 57, MS SQL Server 2008/2012, Teradata, Sybase, MS Access
  • HDFS, Hive, Pig, Spark (16 – 20), HBase, Impala, Scala, Sqoop, Flume
  • Cloudera CDH 5x, Hortonworks
  • NoSQL databases: MongoDB, Cassandra, HBase
  • PL/SQL, T-SQL, SQL, Core Java, J2EE
  • Python, Shell scripting, HTML, JavaScript
  • Unix (AIX, HP-UX), Linux, and Windows environments
  • AWS services: S3, Redshift, RDS, Lambda, SNS, SQS
  • Data profiling and cleansing using Talend Data Quality
  • Data modeling tools: ERwin, ER Studio, Visio
  • Toad, SQL Plus, Teradata SQL Assistant, Data Studio
  • Version control using GitHub
  • Experience with REST APIs, JSON, and XML integration
  • Performance tuning and parallel processing in Talend
  • Job orchestration and monitoring using TAC and Control-M
  • Unit testing, error handling, logging, and alerting in Talend jobs

Certification

  • AWS Solution Architect Associate

Timeline

Talend Developer

7-eleven
01.2021 - Current

Talend Developer

ABC Fitness
07.2018 - 01.2021

Talend Developer

Accenture
09.2017 - 06.2018

Master of Science - Data Science

University of The Cumberlands

Similar Profiles

CREATE PROFILE
Kishore Kotaru