Yaswanth Chitikela
Hyderabad
Summary
With over 4 years of experience in the IT industry, I have a strong background as a Data Engineer and Quality Analyst, specializing in Teradata, Informatica PowerCenter, and Control-M. I possess advanced skills in SQL and indexing, along with extensive knowledge in ETL development using Informatica PowerCenter 10.5.0. My experience includes writing SQL queries for backend testing to ensure data integrity and validity. I also have expertise in data validation, cleansing, and identifying discrepancies. With a solid understanding of data warehouse concepts and project requirements, I can effectively write unit test cases for data quality analysis. I have consistently received positive feedback from clients and onsite leads for delivering successful results.
Overview
4
4
years of professional experience
Work History
Data Engineer
TECH MAHINDRA PVT LTD
02.2021 - Current
Client: Cisco
Databases: Teradata, Oracle
Development Tools: Teradata, Informatica, Control-M
Domain: Enterprise Data Warehouse (EDW)
Project: Cisco_EDS_DI_FINANCE
Project Description:
This project aims to establish a consistent, company-wide set of recurring revenue metrics that enables the measurement of the company's performance across its recurring revenue portfolio.
Key Responsibilities:
- Analyzed and understood client requirements.
- Developed SQL code based on specified requirements.
- Collaborated on ETL (Extract, Transform, Load) tasks to maintain data integrity and ensure pipeline stability.
- Enhanced data quality through thorough cleaning, validation, and transformation processes.
- Optimized query performance and refined database structures for faster and more accurate data retrieval and reporting.
- Deployed changes to higher environments using GIT and Spinnaker/Udeploy tools.
- Validated data against test cases and performed backtracking in cases of discrepancies or data loss.
- Created and scheduled jobs for respective workflows using the Control-M tool, as per requirements.
- Prepared the test environment by migrating tables and workflows during environmental setup.
Education
B. Tech - Electronics and communication Engineering
Narasaraopeta Engineering College
01.2019
Intermediate - MPC
Sri Chaitanya Junior College
01.2015
Skills
- SQL Programming
- Data Warehousing
- Data Modeling
- ETL development
- Performance Tuning
- Data Quality Assurance
- Data Analysis
- SDLC
- Teamwork and Collaboration
- Excellent Communication
Languages and Technologies
SQL, Linux, Windows, Teradata, Oracle, Informatica Power Center, Control-M
Timeline
Data Engineer
TECH MAHINDRA PVT LTD
02.2021 - Current
Intermediate - MPC
Sri Chaitanya Junior College
B. Tech - Electronics and communication Engineering
Narasaraopeta Engineering College
Similar Profiles
Hemanth Kumar BangaruHemanth Kumar Bangaru
Team Lead at Tech Mahindra, Tech Mahindra Pvt LtdTeam Lead at Tech Mahindra, Tech Mahindra Pvt Ltd
Prince MukhiPrince Mukhi
Sr Software Engineer at Tech Mahindra Pvt LtdSr Software Engineer at Tech Mahindra Pvt Ltd
YOGESH EKORIYAYOGESH EKORIYA
Senior Customer Support Executive at TECH MAHINDRA PVT LTDSenior Customer Support Executive at TECH MAHINDRA PVT LTD