Learn Data Skills
Beta

Rupesh Macherla

Data Engineer

Avenga

Technologies

My Portfolio Highlights

My New Workbook

SQL

My New Workbook

Python_Learning

My New Workbook

Bicycle Sales Database

Champion of data integrity, ensuring accuracy in the age of information overload.

My Work

Take a look at my latest work.

DataLab

SQL

DataLab

Python_Learning

DataLab

Bicycle Sales Database

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Avenga | Oct 2022 - Present

ETL Developer

>International team collaboration >Talend ETL pipeline design and development >Interact with the client, get the requirements >Implement the Talend jobs. Extract the data from RDBMS, google sheets >Tranform the data using processing components in Talend (Date calculations, Aggregation, joins, delta load, Incremental load) >Create Master jobs and configure it in TMC. >Actively involve in Production Incidents using ServiceNow >Agile Methodology. >Informatica Power Center >Talend 7.x, 8.x. TAC, TMC, AWS Redshift, PostgreSQL, Oracle.
Show More

Virtusa | Sep 2020 - Sep 2022

Consultant technology

>Implement the Talend ETL data pipelines. >Implement the SCD Type 1 and Type 2 >Configure the S3 components in Talend Studio and extract the dats from AWS S3 files and transform it in Talend >Used AWS Redshift as a target data warehouse and load the data from different data sources including flat files, ftp server, S3. >Power BI data modelling for self service analytics >Created the Power BI dashboard for different vendor files timestamp tracking using conditional formatting and DAX functions (Consolidation dashboard that can track the timestamp of files from system to system) >Involved the Database Migration support from oracle legacy system to AWS Aurora DB >Agile Project Methodology, Daily Scrum calls, Sprint Planning and Sprint Review sessions. >Actively involved Sprint Backlog discussion and Sprint refinement and Sprint retrospective >Talend Technical documentation creation, Relaese IQ/OQ preparation. >Talend 7.x, TAC, Talend Management Console, Power BI, Redshift, Aurora DB, AWS S3, Putty, WinScp, SQL Work bench, Cloudberry tool experience.

Accuracy Info Labs Pvt Ltd | Apr 2016 - Aug 2020

Consultant

>Implementing ETL jobs end to end in Talend Data Integration Studio. >Install and Configure the Talend server components. >Connect different data source from Power BI and create the reports in Power BI desktop and publish the in Power BI service. >Create the Power BI dashboards and enable the access to end users. >Talend Version 6.x and 7.x >Done the custom SharePoint online site and create the custom components in SharePoint online 2019. >Database connectors used in Talend Oracle, SQL Server, PostgreSQL.

My Education

Take a look at my formal education

MCA - Master of Computer Applications, Computer ScienceSri Venkateswara University | 2016

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free