Summary
Overview
Work History
Education
Skills
Certification
Awards and Recognitions
Timeline
Generic

HARIKA IRRINKI

Louisville,CO

Summary

• Data Engineer with 8+ years of experience designing and implementing data warehouse applications using Python and ETL tools (Informatica PowerCenter)

• Proficient in SQL, focusing on implementing complex and optimized queries. Skilled in RDBMS, including Oracle, MS SQL Server, and Teradata

• Expert knowledge in building ETL pipelines, Data Integration, and troubleshooting issues with ETL Jobs

• Hands-on Python (Pandas, Flask, and Dash) experience developing web applications, RESTFUL services

• Hands-on knowledge of Unix shell scripting, WinSCP, and FTP/SFTP

• AWS Certified Cloud Practitioner with knowledge in EC2, S3, Lambda, and Dynamo DB services

Overview

10
10
years of professional experience
1
1
Certification

Work History

Graduate Assistant (Intern)

Paradigm Futures - Startup
10.2022 - 12.2023
  • Developed data-driven Web application and RESTful services using Python Flask and Dash
  • Implemented interactive dashboards with visualizations (matplotlib, plotly) showing real-time insights by web scraping (Beautiful Soup) data from reputable sources such as USDA, EIA, and BLS
  • Implemented and scheduled Airflow DAGS for automating application workflows/jobs
  • Used Docker images to deploy application in Kubernetes clusters

Senior Software Engineer

CGI
08.2018 - 07.2022
  • Led team of six ETL developers. Actively involved in planning, Requirement analysis, Design discussions, and code reviews
  • Designed and Implemented ETL pipelines using Python and Informatica
  • Extracted data from various sources (JSON, Flat files, XML, CSV, and Oracle), transformed data using Python(pandas) and Informatica(transformations), and loaded it into Data warehouse/UI
  • Used Tableau for reporting transformed data from data marts
  • Adhered to Agile model, collaborated with cross-functional teams, tracked progress in Jira, and consistently delivered work without spillovers

Systems Engineer

Tata Consultancy Services
06.2014 - 08.2018
  • In role of Teradata developer, Designed and developed data warehouse applications to process OLTP data from Oracle and load it to Teradata using Informatica
  • Extensively worked on SQL query optimization to publish data to users in near real-time.
  • Automated data reconciliation by creating audit jobs between source systems and EDW

Education

Master of Science - Computer Science (Artificial Intelligence)

Dakota State University
Madison, SD
12.2023

Bachelor of Science - Electrical Engineering

Andhra University
Visakhapatnam, India
05.2014

Skills

  • Programming: Python, SQL, Shell Scripting
  • ETL Tools: Informatica PowerCenter
  • Cloud: AWS
  • Workflow: Apache Airflow
  • Databases: Oracle, Teradata, Microsoft SQL Server
  • Reporting: Tableau, Power BI, SAP BO
  • DevOps: GIT, Jenkins, Urelease/Udeploy, Artifactory
  • Schedulers: Cron Jobs, Tidal Enterprise Scheduler (TES)
  • Machine Learning: Classification Algorithms & Decision Trees

Certification

  • AWS Certified Cloud Practitioner, Amazon Web Services - Mar 2021

Awards and Recognitions

· Top performer in the university and achieved Cumulative GPA of 4.00/4.00 in masters(2023)

· Received APEX award in CGI for two consecutive years (2022, 2021)

· Received a key contributor and star performer award in CGI in 2021

Timeline

Graduate Assistant (Intern)

Paradigm Futures - Startup
10.2022 - 12.2023

Senior Software Engineer

CGI
08.2018 - 07.2022

Systems Engineer

Tata Consultancy Services
06.2014 - 08.2018

Master of Science - Computer Science (Artificial Intelligence)

Dakota State University

Bachelor of Science - Electrical Engineering

Andhra University

Similar Profiles

CREATE PROFILE
HARIKA IRRINKI