About

Sunayan Baruah is a highly motivated and results-driven Data Engineer with over 7 years of experience in data modeling, data warehousing, Business Intelligence, ETL loading, testing, automation, designing ETL frameworks, reporting, and analytics. Currently working as an Associate Tech Lead at emids, Sunayan has a strong background in the healthcare product domain. Sunayan's experience includes working as a Senior Data Engineer at risksense, where he created parsers to ingest data in JSON, XML, NASL, and different raw files into the MySQL database. He also designed and coded database tables to store the application's data, created/optimized existing SQL scripts, and performed data modeling to visualize database structure. Additionally, Sunayan developed Airflow jobs to populate data from Cassandra to MySQL DB, created an end-to-end ETL testing framework to test the data consistency, integrity, and data completeness between the source and target database using pandas, and automated the same using Robot Automation Framework and Jenkins for CI. He also revamped the entire ETL to ETVL by adding a validation layer in the data pipeline using PySpark. Sunayan has worked extensively on the creation of flyway migrations, creation deletion of tables, indexes, and other DB objects in Cassandra, MongoDB, PostgreSQL, and MySQL databases. He also worked on the Ransomware Analysis Dashboard, which was published by Risksense in 2019. Sunayan has also worked as an Associate at Goldman Sachs, where he created rules (SQL/PL-SQL) for US-Resi mortgage loans in the rules engine based on complex business logic. He also created a data warehouse to streamline and save all functional data in a more structured way. Sunayan created Alteryx workflows to generate reports based on the business logic and created/migrated critical reports and dashboards in Tableau, which enables the senior management to have a detailed view of the exceptions and also provides an insight into how the business teams are performing. He also created ETL scripts to transform, clean, and perform data validation of the test scripts data before uploading into sybase database. Sunayan holds a Bachelor of Engineering (B.E.) degree in Electrical and Electronics Engineering from mvj college of engineering. He also attended Luit Valley Academy and Don Bosco High School, Jorhat. Sunayan's technical skills include Senior Software Engineer, ETL, SQL, test, Data Engineering, MySQL, Cassandra, Python, Apache Airflow, Pandas, MongoDB,