Data Engineer - Systems & Data Warehouse Testing Specialist

Utkarsh Kumar

***.*******@*****.*** 966-***-**** Gopalganj, Bihar (841438) linkedin.com/in/utkarssshkumar Profile

Systems Engineer with experience in Data Warehouse Testing. Proficient in optimizing SQL queries, Big Data technologies, and utilizing data visualization tools to deliver actionable insights for informed business decision-making. Skilled in DevOps methodologies, Cloud platforms, and automation testing tools like Selenium. Experienced in Python, Java, and scripting languages with a solid foundation in OOP and machine learning. Understanding of software development lifecycle (SDLC) and SCRUM Agile methodologies to work collaboratively in cross-functional fast-paced team environment. Excellent written and verbal communication skills, strong problem-solving and analytical abilities, and willingness to learn new skills.

Professional Experience

Systems Engineer Trainee, Infosys Limited 08/2022 – 02/2023 Mysore, India

•Performed data warehousing operations using Big Data technologies and ETL processes to extract, transform, and load data from diverse sources while ensuring data quality and integrity.

•Documented data processes and pipeline architectures along with optimizing data processing workflows.

•Developed and maintained automated test scripts, test plan and test cases for web applications.

•Collaborated with the teams to review business requirements, deliverables and stakeholder management.

•Wrote well-designed code using best industry practices, along with troubleshooting and debugging. Projects

Flappy Bird Game using Python with PyGame:

•Created an interactive Flappy Bird game using Python and the PyGame library.

•Designed game mechanics, user controls, collision detection and scoring algorithms for immersive gameplay. Customer and Sale insight Dashboard using ETL:

•Extracted data, executed mappings between corresponding source and target in PowerCenter Designer.

•Performed essential data transformations to meet the requirements, resulting in 15% improvement in data quality and accuracy.

•Loaded transformed data into the target database via data pipeline, ensuring data relationships and constraints remained maintained.

•Streamlined migration with SQL Server tools, leading to 20% efficiency in data management and 20% reduction in processing time.

•Technologies Used: Informatica PowerCenter, MS SQL Server, MS Excel. DevOps - CI/CD Pipeline creation and Implementation:

•Automated Continuous Integration and Continuous Delivery pipeline stages with Git integration for efficiency.

•Designed pipeline architecture for source code integration, build automation, deployment and monitoring.

•Orchestrated Docker and Kubernetes deployments to ensure consistent application delivery.

•Technologies Used: Docker, Kubernetes, GitHub.

Python Flask Application deployment to OKE:

•Containerized Python Flask applications using Docker and deployed on Oracle Kubernetes Engine.

•Created Kubernetes manifests for application deployment, scaling and resource allocation.

•Implemented automated updates and version control systems.

•Technologies Used: Kubernetes, Docker, Oracle Kubernetes Engine (OKE). Education

Bachelor's degree in Electronics and Communication Engineering (B.Tech), Galgotias University

05/2022 Greater Noida

Certificates

Programming fundamentals Using Python

Cloud Computing basics

Oracle Cloud Infrastructure DevOps Professional

Introduction to Unix and Shell Scripting

Achievements

•6*(Gold badge) in Problem solving, 5*(Gold badge) in Java, SQL, Python on Hackerrank.

•Solved 500+ problems across coding platforms like Hackerrank and Leetcode.

•Ranked under 2100 out of 18250 participants in CodeChef February long challenge. Skills

Programming Languages

•Java

•Python

Shell Scripting

•Unix / Linux

RDBMS

•Oracle PL/SQL

•Microsoft SQL Server

Machine Learning

•Numpy

•Pandas

•Matplotlib

Big Data

•Apache Hadoop

•Apache Hive

Tools

ETL

Informatica PowerCenter

DevOps

•Kubernetes

•Docker

•Oracle Cloud

Testing

•Selenium WebDriver

•JUnit

Others

•Microsoft Power BI

•Microsoft Excel

Contact this candidate