Harika Irrinki

About Harika Irrinki

Data Engineer with 11 years of experience in designing, implementing, and maintaining data warehouse applications using Python and ETL tools.• Proficient in SQL, focusing on implementing complex and optimized queries. Skilled in RDBMS, including Oracle, MS SQL Server, and Teradata• Expert knowledge in building scalable ETL pipelines and troubleshooting issues with ETL Jobs• AWS Certified Cloud Practitioner with knowledge in EC2, S3, Glue, Lambda, IAM, ECR, Step Functions, CloudWatch, SQS, SNS, Redshift, RDS, DLQ, Athena and Dynamo DB services• Proficient in Unix shell scripting, WinSCP, and FTP/SFTP for automation and data management tasks• Demonstrated proficiency and hands-on familiarity with data warehousing concepts, including star schema, snowflake schema, fact tables, dimension tables, OLTP (Online Transaction Processing), OLAP (Online Analytical Processing), and data marts• Worked on Teradata loading utilities such as BTEQ, FastLoad, MultiLoad, and FastExport• Experienced in managing large datasets and executing various types of loadings, including incremental, batch, and full loads, to ensure efficient data handling and processing• Extensive hands-on experience across various modules in the Healthcare and Telecom domains• Hands-on experience in migrating applications from on-prem infrastructure to AWS cloud• Experienced in developing machine learning models using PySpark MLLib and TensorFlow for predictive analysis on large datasets• Led a workshop on text data analytics and NLP with Python at SDSU Data Science Symposium 2023. Delivered presentations and provided hands-on training to participants-Technical Skills-• Programming: Python, Pandas, PySpark, SQL, PL/SQL, Unix Shell Scripting• ETL Tools: Informatica PowerCenter, DBT, Apache Airflow• Databases: Oracle, Teradata, Microsoft SQL Server, MySQL• Reporting: Tableau, Power BI, SAP BO • Cloud: AWS (EC2, S3, Glue, ECR, IAM, Lambda, Step Functions, CloudWatch, SQS, SNS, Redshift, RDS, DLQ, DynamoDB)• Semantic Layer & Virtualization: AtScale• Data Warehouse: Data Management, Data Modeling, Data Migration, Data Validation, Data Integration• DevOps: GIT, Jenkins, Maven, Docker, Kubernetes, Udeploy, Artifactory • Schedulers: CA Workstation, Cron Jobs, Tidal Enterprise Scheduler (TES),$U• Agile Tools: Rally, JIRA, Confluence• Machine Learning: Classification Algorithms & Decision Trees, Reinforcement Learning, NLP• Healthcare Domains: Claims, Network, Provider, Demographics, PBM, Encounters, EHR, Diagnoses, Procedures

Experience

1. Cloud Data Engineer

   Cigna Healthcare

   Sep 2024 — Present

   As a Cloud Data Engineer, working on building and automating AWS infrastructure while also developing data pipelines and transformation workflows. Hands-on with EC2, S3, Lambda, EKS/ECS, Aurora, CloudWatch, IAM, and KMS, deploying AtScale on EC2 using Terraform and Infrastructure as Code. Developing Python and shell scripts for automation, working with Databricks and DBT for analytics, and deploying containerized applications on OpenShift for scalable, reliable delivery.• Designed and implemented a complete Data Engineering infrastructure in AWS during migration from Cigna to HCSC.• Hands-on experience with AWS services including EC2, NLB, ALB, CloudWatch (for logging and alarms), S3, Secrets Manager, Systems Manager, IAM policies, EKS, KMS, ECS, Aurora DB, and Lambda.• Automated infrastructure deployment using Terraform, with a complete Infrastructure as Code setup to host AtScale on EC2, fully integrated with AWS CLI.• Set up AtScale infrastructure from scratch, including model creation and application deployment on AWS EC2 instances.• Developed Python scripts for application automation, backup operations, and AWS CLI integrations.• Created and maintained shell scripts for system automation and operational tasks.• Worked with Databricks as a data warehouse and wrote SQL queries for analytics and reporting.• Practical experience with DBT for building and managing data transformation workflows.• Deployed containerized applications using OpenShift for scalable and reliable delivery.

Education

• SRKR Engineering College

  Bachelor of Engineering - BE, Electrical and Electronics Engineering

  2010 — 2014

• Dakota State University

  Master's degree, Artificial Intelligence

• Sri Kakatiya Merit School, Bhimavaram

  SSC (Board of Secondary Education)

  2003 — 2008

• Aditya junior college, Bhimavaram

  Board of Intermediate Education, MPC (Maths, Physics, Chemistry)

  2008 — 2010