Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Rajesh Kumar Kallapari

Rajesh Kumar Kallapari

Atlanta,GA

Summary

Currently working as Sr Talend Developer, having 12+ Years of IT experience in Data Warehousing Projects. Worked on different phases of Data Warehouse development lifecycle – Designing, Development, Testing and Code Deploying to Production. Requirement gathering from end user converting the requirements into technical documents. Expertise in creating Data Warehousing Architecture and concepts. Expertise in Data modelling, where I have created Conceptual model to logical and physical modelling. Expertise in ETL tool Talend Data Integration, Talend Big Data Integration and Talend ESB. Worked as both Architect and developer on Talend Data Integration 8.x and Talend Big Data Integration 7.x and 6.x. Worked on various scenarios on files like file consolidation, fetching latest date file from a directory, point of failure recovery and dynamic file generation. Experience in Trouble shooting and implementing Performance tuning at various levels such as Source, Target, Job level and System in ETL Process. Successfully installed Talend (TAC and TMC) and its supporting applications like Job server, Nexus Repository, Audits Database and SVN/Git Repository on Linux machines and configured them in TAC. Designed overall architecture and Admin activities of the code migration from Talend 6 to Talend 8. Successfully installed and Configured Talend Management Console along with its support applications (GIT and Remote Engine paring) Creating the users and projects in TAC/TMC and assigning the Projects to the respective users. Designed various Jobs for extracting data from various sources involving relational tables and flat files and API’s. Extracting/Uploading Flat files from various cloud services like Salesforce, AWS S3 bucket, GCP cloud, Azure blob storage, Network Drive and SFTP’s using Talend components. Implemented performance tuning and optimized the code to run in respective time duration. Experience in managing large Analytic teams and applications service intake into operations. Created customised jobs for both SCD type 1 and 2 using Talend studio. Handled dynamic Schemas from data sources. Created Error Handling mechanism includes job statistics, logs, email notifications of job status. Capturing source and targets statistics like count, rejected records which are not falling under requirements. Experience in converting the Store Procedures logic into ETL requirements. Created SQL and PLSQL scripts for developing Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) objects. 5 years of experience in Data lineage/catalog. In which we analyse operations and analysis results are displayed in the view. Data linage results trace backword the component and transforms the data in the output column name passes through before being written in the column. I have generated data linage export to HTML that gives a description of the project that holds the analysed Jobs in addition to a preview of the analysis graphical results. Created Pipelines in Talend Data catalog and deployed them to cloud. Good communication and interpersonal skills, ability to learn quickly, with good analytical reasoning and adaptive to new and challenging technological environment. Worked on multiple databases like Salesforce, Snowflake, PostgreSQL, MSSQL, MySQL, Oracle 11g, and Amazon Redshift. Expertise in migrating the projects from one database to another data base. Created Re-Usable objects like joblets for business logics. Uploading files to HDFS and loading them into Hive tables. Created tables in Hive databases based on requirement (internal and external tables) and Stored formats like text file and ORC. Detail-oriented, organized and meticulous employee. Works at fast pace to meet tight deadlines. Enthusiastic team player ready to contribute to company success. Highly skilled software development professional bringing enormous talents for software design, development and integration. Offering advanced knowledge of in-demand programming languages. Background writing code and developing systems for [Industry] applications.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Talend Developer/Lead

SiriusXM
03.2022 - Current
  • Analyse the price of all AWS instances across the organization which are used by SiriusXM teams
  • Identify the instances which are not being used based on the memory usage or the instances on idle and distinguish any need of new servers if any of the existing servers are getting overloaded
  • Also, implemented code migration from Talend V6 to talend V8.
  • Improved data processing efficiency by designing and developing Talend ETL jobs.
  • Enhanced data quality by implementing data validation and error handling in Talend workflows.

Talend Lead

Softech International Resource Inc.
08.2021 - Current
  • Currently working as Sr Talend Developer, having 12+ Years of IT experience in Data Warehousing Projects
  • Worked on different phases of Data Warehouse development lifecycle – Designing, Development, Testing and Code Deploying to Production
  • Requirement gathering from end user converting the requirements into technical documents
  • Expertise in creating Data Warehousing Architecture and concepts
  • Expertise in Data modelling, where I have created Conceptual model to logical and physical modelling
  • Expertise in ETL tool Talend Data Integration, Talend Big Data Integration and Talend ESB
  • Worked as both Architect and developer on Talend Data Integration 8.x and Talend Big Data Integration 7.x and 6.x
  • Worked on various scenarios on files like file consolidation, fetching latest date file from a directory, point of failure recovery and dynamic file generation
  • Experience in Trouble shooting and implementing Performance tuning at various levels such as Source, Target, Job level and System in ETL Process
  • Successfully installed Talend (TAC and TMC) and its supporting applications like Job server, Nexus Repository, Audits Database and SVN/Git Repository on Linux machines and configured them in TAC
  • Designed overall architecture and Admin activities of the code migration from Talend 6 to Talend 8
  • Successfully installed and Configured Talend Management Console along with its support applications (GIT and Remote Engine paring) Creating the users and projects in TAC/TMC and assigning the Projects to the respective users
  • Designed various Jobs for extracting data from various sources involving relational tables and flat files and API’s
  • Extracting/Uploading Flat files from various cloud services like Salesforce, AWS S3 bucket, GCP cloud, Azure blob storage, Network Drive and SFTP’s using Talend components
  • Implemented performance tuning and optimized the code to run in respective time duration
  • Experience in managing large Analytic teams and applications service intake into operations
  • Created customised jobs for both SCD type 1 and 2 using Talend studio
  • Handled dynamic Schemas from data sources
  • Created Error Handling mechanism includes job statistics, logs, email notifications of job status
  • Capturing source and targets statistics like count, rejected records which are not falling under requirements
  • Experience in converting the Store Procedures logic into ETL requirements
  • Created SQL and PLSQL scripts for developing Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) objects
  • 5 years of experience in Data lineage/catalog
  • In which we analyse operations and analysis results are displayed in the view
  • Data linage results trace backword the component and transforms the data in the output column name passes through before being written in the column
  • I have generated data linage export to HTML that gives a description of the project that holds the analysed Jobs in addition to a preview of the analysis graphical results
  • Created Pipelines in Talend Data catalog and deployed them to cloud
  • Good communication and interpersonal skills, ability to learn quickly, with good analytical reasoning and adaptive to new and challenging technological environment
  • Worked on multiple databases like Salesforce, Snowflake, PostgreSQL, MSSQL, MySQL, Oracle 11g, and Amazon Redshift
  • Expertise in migrating the projects from one database to another data base
  • Created Re-Usable objects like joblets for business logics
  • Uploading files to HDFS and loading them into Hive tables
  • Created tables in Hive databases based on requirement (internal and external tables) and Stored formats like text file and ORC.
  • Improved product consistency by closely monitoring blending processes and adjusting parameters as needed.
  • Enhanced production efficiency by maintaining blend equipment in optimal condition through regular inspections and cleaning.

ETL Developer and BI Support Lead

VISA
08.2021 - 02.2022
  • Involved in requirement gathering and created a BRD document
  • Created data model based on understanding and got sign off from stakeholders
  • Created a job for data extraction from API and stored them files on daily basis
  • Extracted the dats from various data sources and uploaded them into GCP Cloud Storage buckets
  • Uploading source files to MySQL and loaded back to Snowflake tables using Talend
  • Created Error Handling/Audits Job which helps us to identify the job failure and store the ETL jobs statistics
  • Created notification email alerts for job success, failure, and data audits
  • Created Technical Specification document for all Talend jobs.

Technical Architect

Hyderabad
09.2019 - 07.2021
  • Firstly, involved in requirement gathering and created a BRD document
  • Created data model based on understanding and got sign off from stakeholders
  • Installed Talend Big Data 7.3 version on Ubuntu version along with Git Repository for code and MySQL for Table audits
  • Created a job for data extraction from API and stored them files on daily basis
  • Created databases and tables in Hive based on tenants
  • Uploading source files to HDFS and loaded back to hive tables using Talend
  • Created Error Handling/Audits Job which helps us to identify the job failure and store the ETL jobs statistics
  • Created notification email alerts for job success, failure and data audits
  • Created Technical Specification document for all Talend jobs.

Senior Technology Specialist

Reventics
08.2018 - 09.2019
  • Mainly involved in Analytics, Designing Data Model and Talend Admin and Developing Jobs
  • Processed Clinical data, including Claims, Patient, Administrative and health Surveys
  • Extracting the clinical data sets, staged them, cleansed the data and transformed based on the requirement and loaded them into data warehouse
  • Requirement gathering from end user converting into technical documents
  • Developing the Talend jobs based on the requirements
  • Created ETL Mapping with Talend Integration Suite to pull data from Source, apply transformations, and load data into target database
  • Extracted data from legacy databases applied business logic to load them in the staging database
  • Created complex mappings in Talend using tMap, tJoin, tReplicate, tParallelize, tJava, tJavaFlex, tAggregateRow, tDie, tWarn, tLogCatcher, etc
  • Used tStatsCatcher, tDie, tLogRow to create a generic joblet to store processing stats
  • Created Talend Mappings to populate the data into dimensions and fact tables
  • Created TalendETL job to send attachment files from pop e-mail using tPop, tFileList, tFileInputMail and then loaded data from attachments into database and archieved the files
  • Design and Implemented ETL for data load from heterogeneous Sources to Oracle as target databases
  • Conduct test run, debug & fix, and upload to SVN based Versioning system for deployment
  • Used Talendjoblet and various commonly used Talend transformations components like tMap, tDie, tConvertType, tFlowMeter, tLogCatcher, tRowGenerator, tSetGlobalVar, tHashInput&tHashOutput and many more
  • Developed historical jobs and Incremental jobs based on the source Database
  • Loading the large data sets from S3 to Redshift
  • Monitoring Master data, transactional data management
  • Stores current and historical data and are used for creating analytical reports
  • Reports range from annual, quarterly and monthly comparisons and trends to detail daily calls analysis
  • Documented process and created specification at ETL level.

Talend Developer and Admin

Dow Jones
01.2014 - 08.2018
  • Mainly involved in Analytics, Designing Data Model and Talend Admin and Developing
  • Requirement gathering from end user converting into technical documents
  • Developed the Talend jobs based on the requirements
  • Developed historical jobs and Incremental jobs based on the source Flat files
  • Integrate data from multiple Sources like files and API’s, enabling a central view using Qlik Sense
  • Loading the large data sets using the PGSQl script tool
  • Integrated R and Python Scripts in Talend using tSystem component
  • Worked with the thttprequest component to fetch the data form the source API’s
  • Monitoring Master data, transactional data management
  • Stores current and historical data and are used for creating analytical reports
  • Reports range from annual, quarterly, and monthly comparisons and trends to detail daily calls analysis
  • Documented process and created specification at ETL level.

Talend Developer

Lenovo
10.2014 - 01.2017
  • Mainly involved in Analytics and ETL developing
  • Requirement gathering from end user converting into technical documents
  • Worked with the tRESTClient to fetch the data form the source data form the API’s
  • Monitoring Master data, transactional data management
  • Stores current and historical data and are used for creating analytical reports
  • Reports range from annual and quarterly comparisons and trends to detailed daily sales analysis
  • Integrate data from multiple API’s, enabling a central view
  • Documented process and created specification at ETL level
  • Implemented Error Handling Strategy in all Jobs
  • Extracted the data from multiple sources like Flat files and MySQL and loaded the data into Redshift.

Talend Developer

Dell
01.2012 - 09.2014
  • Mainly involved in ETL developing
  • Requirement gathering from end user converting into technical documents
  • Talend ETL and SQL query designing as per the requirement as support to the Tableau development
  • Monitoring Master data, transactional data management
  • Stores current and historical data and are used for creating analytical reports
  • Reports range from annual and quarterly comparisons and trends to detailed daily sales analysis
  • Integrate data from multiple source systems, enabling a central view
  • Documented process and created specification at ETL level as well as reporting level
  • Implemented Error Handling Strategy in all Jobs.

Education

Skills

  • Windows7 &81, LINUX (Basics), UBUNTU
  • UNIX, SQL, PL/SQL
  • AWS Redshift, Salesforce, Snowflake, Oracle 9i / 10g, MYSQL 57/8x, PostgreSQL 9x, MSSQL
  • Talend DI and BDI Enterprise 6x/7x/8x and Talend Administration Centre (TAC) and Talend Management Console
  • S3, EC2, AWS Redshift, AWS Aurora, EMR, AWS RDS, Lambda
  • ETL Development
  • Data Security
  • Performance Optimization
  • Data Warehousing
  • Job Scheduling
  • Workflow Design
  • SQL Proficiency
  • Data Cleansing
  • Data Transformation
  • Data Lineage
  • Data Extraction
  • Data Modeling Techniques
  • Best Practices Implementation
  • Documentation Management
  • Testing and Debugging
  • Technical Design Documentation

Certification

Talend Data Integration Certificate

Azure AI Fundamentals

Timeline

Talend Developer/Lead

SiriusXM
03.2022 - Current

Talend Lead

Softech International Resource Inc.
08.2021 - Current

ETL Developer and BI Support Lead

VISA
08.2021 - 02.2022

Technical Architect

Hyderabad
09.2019 - 07.2021

Senior Technology Specialist

Reventics
08.2018 - 09.2019

Talend Developer

Lenovo
10.2014 - 01.2017

Talend Developer and Admin

Dow Jones
01.2014 - 08.2018

Talend Developer

Dell
01.2012 - 09.2014

Rajesh Kumar Kallapari