Satyam Asati
@Satyam_asati
Sr. Software Engineer at Ellicium Solutions (GTO)
Pune, Maharashtra, India
Satyam Asati is a Data Engineer with over 3 years of experience designing scalable ETL pipelines, Data Lakes, and data warehouse solutions on Azure. He specializes in developing end-to-end data pipelines using Python, Azure Data Factory, Databricks, and SQL. His expertise includes data modeling, Medallion Architecture, and incremental data loading. Satyam has a proven track record of building reliable data platforms that enable advanced analytics and business insights.
Experience
Sr. Software Engineer
Ellicium Solutions (GTO)
Built a shared Python library published through Azure Artifacts Feed to standardize commodity identification logic. Developed a Python-based data ingestion pipeline leveraging Bing Search APIs, OpenAI models, and NLP techniques. Designed and implemented Azure Data Factory pipelines to ingest tariff data and orchestrated downstream synchronization. Designed and maintained fact and dimension tables for supply chain analytics. Implemented SCD Type 2 logic for tariff datasets. Developed APIs to interact with Azure Cosmos DB and designed scalable document schemas.
Sr. Software Engineer
Ellicium Solutions (SXR)
Built automated Python ETL pipelines to ingest and preprocess large CSV datasets. Integrated OpenAI GPT-3.5 models into the pipeline to enrich supplier data and perform domain-based de-duplication. Developed automated classification pipelines to categorize organizational spend. Designed data transformation workflows to standardize supplier and transaction datasets.
Data Intern
Ellicium Solutions
Designed and implemented a configurable ETL framework in Python. Built distributed data processing pipelines using PySpark and Apache Spark to clean, transform, and aggregate large datasets. Ensured data reliability through validation, cleansing, and transformation processes.
Education
K. D. K. College of Engineering
Bachelor of Engineering