Looking for a job

Amola Chouhan

@amolachouhan

Data Engineer at Impetus Technologies who modernized 25 ETL pipelines and improved execution speed by 40%.

At Impetus Technologies, I migrated approximately 25 ETL pipelines from legacy BDL to Databricks MIDAS for the BlueStream digital insurance data platform, using PySpark and Spark SQL transformations with reconciliation and validation.

I contributed to onboarding more than 250 data feeds from MongoDB, Oracle, PostgreSQL, SFTP, and Amazon SQS. The work used Multi-Hop Architecture to process Parquet, CSV, and JSON data through layered transformations.

As an Associate Software Engineer, I improved the New Transaction Type framework for RQB processing and client-portal activity tracking. These query optimization and ETL improvements contributed to 37% lower compute costs and 40% faster execution across a platform processing more than 5TB of daily claims and policy data.

I also developed AWS ingestion pipelines during my internship and implemented validation and error-handling checks. I'm a Databricks Certified Data Engineer Professional and Associate.

Experience

Work history, roles, and key accomplishments

Current

Software Engineer

Current

Impetus Technologies

Jul 2025 - Present (1 year 4 months)

Migrated ~25 ETL pipelines from legacy BDL to Databricks MIDAS, implementing PySpark and Spark SQL transformations with data reconciliation and validation. Contributed to onboarding 250+ data feeds and automated production pipeline monitoring.

PySpark Spark SQL Databricks ETL Data Migration Data Validation Data Reconciliation Workflow Orchestration MongoDB Oracle PostgreSQL SFTP Amazon SQS Parquet CSV JSON

Associate Software Engineer

Impetus Technologies

Jul 2024 - Jun 2025 (11 months)

Enhanced the New Transaction Type framework for RQB processing and client-portal activity tracking through query optimization and ETL improvements. Configured and onboarded ~110 Oracle source tables using Informatica PowerCenter and PowerExchange-based CDC.

ETL Query Optimization Informatica PowerCenter Change Data Capture Oracle SQL Data Cleaning Dashboard Development

Summer Intern

Impetus Technologies

Jan 2024 - Jun 2024 (5 months)

Developed and maintained AWS-based cloud-native ingestion pipelines using Amazon SQS, AWS Lambda, Amazon S3, CloudWatch, and Step Functions. Implemented data quality, ingestion validation, and error-handling checks.