Lead Data Engineer
KyndrylMar, 2022 - Present4 yr 4 months
Developed ETL data processing pipeline using Python, Elasticsearch, Kibana. Read multiple csv files, performed transformations using NumPy and Pandas, delivering business insights. Engineered and deployed ETL pipeline in AWS using Glue, S3, Redshift, and Power BI, extracting data from Jira API and Project Rak API to analyze teams, boards, and sprints, optimizing resource allocation for 30% efficiency boost. Integrated data from APIs to build analytical dashboards. Automated Backup reporting, reducing manual efforts by 40%. Implemented best practices for logging. Communicated client needs, guiding team members. Worked on POC using AWS Data Migration service to migrate data from Oracle to Redshift. Established POC to read data from Kafka topics in Spark using PySpark. Upgraded Glue jobs from 2.0 to 4.0 using cloud formation templates and migrated jobs to production. Experience integrating LLM using OpenAI API.