Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Siva Prashant Karagana

ETL Lead Engineer
Hyderabad,TG

Summary

With over 11 years of experience as a Software Development Engineer in Test (SDET) in the Healthcare & Life Sciences, Finance, and Banking domains, I bring extensive expertise. I have honed my skills in Extract, Transform, Load (ETL) processes, working seamlessly with cloud platforms like Databricks, AWS EMR, and Snowflake. My deep understanding of data warehousing concepts enables me to proficiently write complex SQL stored procedures and Scala code, while also showcasing strong debugging and troubleshooting skills. Notable achievements include successful implementation of a Data Quality Framework that significantly boosts client confidence. I possess extensive knowledge of Unix and Autosys, including writing and deploying JIL files and log tracking. With expertise in Scala, ETL/DWH testing concepts, and Informatica PowerCenter, along with a basic understanding of Perl scripting, I am well-versed in the software development life cycle. My strong background in working with relational databases and solid backend testing experience further enhance my skill set. Known for quickly mastering new concepts and technologies while actively sharing ideas with the team. Received commendations from business leads and onsite teams for understanding business requirements and identifying and logging requirement defects that add value to the business.

Overview

11
11
years of professional experience
7
7
years of post-secondary education
5
5
Certifications

Work History

ETL Lead Software Engineer

S&P Global
04.2021 - Current
  • Company Overview: S&P Global provides ratings to entities/companies on various factors
  • We as a team, consume the ratings data, combine them with other metadata and provide meaningful data to clients which would help them get more insights and make informed decisions
  • S&P Global provides ratings to entities/companies on various factors
  • We as a team, consume the ratings data, combine them with other metadata and provide meaningful data to clients which would help them get more insights and make informed decisions
  • Collaborated with cross-functional teams to deliver comprehensive solutions for clients'' needs.
  • Cooperated with other engineers to design performant queries and database schemas to support analytics reporting.
  • Led a team of software engineers to successfully complete projects within deadlines, ensuring high-quality end products.

System QA Analyst

Wells Fargo
01.2017 - 04.2021
  • Company Overview: Commercial credit cards offer companies advanced functionality such as the ability to set employee-spending limits and restrict card usage to specific types of purchases
  • Collaborated with cross-functional teams to ensure seamless integration of new features and bug fixes.
  • Expanded team knowledge base, mentoring junior QA analysts on best practices and industry standards.
  • Supported timely project completion through efficient prioritization and execution of test tasks.
  • Promoted a culture of continuous improvement, regularly reviewing and refining QA processes and methodologies.
  • Managed defect reporting process, ensuring clear communication with stakeholders regarding issue status and resolution timelines.
  • Leveraged root cause analysis techniques to identify recurring issues and drive long-term solutions within the development process.

Senior Software Engineer - QA

NTT Data
12.2013 - 01.2017
  • Company Overview: An ERP based application developed for automating the process of manufacturing dosimeters (used to measure different types of radiations to which humans are exposed)
  • Mentored junior developers, fostering professional growth and enhancing team productivity.
  • Enhanced software functionality by identifying and resolving complex technical issues.
  • Regularly reviewed peers'' code contributions, offering constructive feedback to enhance overall product quality.
  • Delivered exceptional client support by promptly addressing concerns and implementing requested changes or enhancements to software solutions.

Education

PG Diploma - Data Science

International Institute of Information Technology Bangalore
01.2019 - 01.2020

B.Tech - ECE

CVR College of Engineering
01.2009 - 01.2013

Intermediate - MPC

Prathibha Junior college
01.2007 - 01.2009

SSC - 10th

Dilsukhnagar Public School

Skills

ETL

Certification

Certified SAFe 5 Practitioner, UpGrad

Timeline

ETL Lead Software Engineer

S&P Global
04.2021 - Current

PG Diploma - Data Science

International Institute of Information Technology Bangalore
01.2019 - 01.2020

System QA Analyst

Wells Fargo
01.2017 - 04.2021

Senior Software Engineer - QA

NTT Data
12.2013 - 01.2017

B.Tech - ECE

CVR College of Engineering
01.2009 - 01.2013

Intermediate - MPC

Prathibha Junior college
01.2007 - 01.2009

SSC - 10th

Dilsukhnagar Public School
Siva Prashant KaraganaETL Lead Engineer