Rohit Ayila

About Rohit Ayila

Data Engineer with 6 years of experience in designing, developing, and optimizing ETL pipelines using AWS and Azure ecosystems. Skilled in building scalable data solutions, integrating cross-platform data flows, and ensuring high data quality and reliability. Experienced in debugging, automation, and deploying cloud-native data engineering solutions following CI/CD best practices.

Experience

1. Senior Data Engineer

   Genpact

   Jan 2022 — Present · Hyderabad, IN

   Designed and orchestrated end-to-end ETL pipelines using AWS Step Functions, enabling seamless data flow from source systems to Amazon Redshift. • Implemented AWS DMS to ingest data from heterogeneous sources into Amazon S3, ensuring reliable and scalable ingestion. • Developed PySpark and SparkSQL Glue jobs for complex transformations before loading into Redshift. • Led efforts to integrate Anaplan inbound and outbound data flows, using AWS Lambda, Step Functions for inbound automation, and Glue jobs for outbound, enabling seamless data exchange between AWS pipelines and Anaplan. • Ensured CI/CD best practices by deploying Glue jobs and other resources via CloudFormation templates, improving consistency and maintainability. • Scheduled and monitored jobs with EventBridge and CloudWatch, enabling proactive debugging and better pipeline reliability. • Optimized architecture and execution strategy to reduce costs while adhering to AWS best practices.

Education

• BVC Engineering College - India

  B.tech

  2014 — 2018