Sandarbh Jaiswal

Data Engineer

Eli Lilly and Company India•  February 2020 - Present

Build the ETL data pipeline on AWS cloud for multiple Sales & activity data Sources, as well migrated historical data from On-prem to Cloud. Performance optimization on Redshift procedures results in a reduction of up to 60% load time. Developed interactive Tableau dashboards on top of data mart with a strong understanding of advanced Tableau features like calculated fields, parameters, table calculations, joins, data blending, and dashboard actions. Optimized Tableau Extract on server by using Tableau PDSs & pointing it from Tableau Dashboard. Responsible for orchestrating and scheduling jobs in Airflow Dags & CAWA Workload Automation using the execution plan of data. Performing and documenting data analysis, data validation, and data mapping/designs. ETL design and development, Analysis of requirements, and design code to fulfill same. Migrated Tableau reports using the Tableau Content migration tool across different servers(On-prem to the cloud). Using GitHub and AWS code pipeline for CI/CD.

System Engineer

Tata Consultancy Services Ltd•  March 2016 - February 2020

Proposed a solution & implementation as well by using AWS S3 services for archival of historical flat files to S3 bucket to cope up the challenge of space utilization issue on Linux servers. Created several Shell scripts using AWS CLI commands to move files from Linux Location to AWS Buckets. Created several Data Growth Tableau Reports for different Database servers using System Tables info. These reports are further used to Analyse/predict the future scope of increasing spaces. Created Unix shell scripts to load flat file data into the Netezza database by performing header validation checks & data quality checks like null validation, duplicate data validation, etc. Proficient in using SQL for data analysis and creating ETL Solutions. Created conceptual and high-level system design from requirements, development, system integration testing & deployment plan.