Aseem Goyal

Data Engineer

Exponentia.ai•  April 2024 - June 2024•  Noida

Worked as Data Engineer under Niva Bupa Project. Worked with multiple DBS like Oracle, PostgreSQL, MSSQL, mongoDB, etc. to migrate and integrate the datafrom Niva Bupa DBs to our staging layer in our own servers using Talend. Transformed the migrated data and migrated it further to ods layer to show the reports on Qlik.

Technical Consultant - PL/SQL

Insife•  January 2024 - April 2024•  Noida

Worked under HELOPV product of Insife to develop and manage SQL database and Apis using tools like Oracle SQL developer,MSSQL etc. Worked on Data Migration from HALOPV to Argus. Worked on stored procedures and complex SQL queries in MsSQL and Postgres to extract, transform and load datafrom multiple sources. Build the code for new forms of UI.

Product Engineer

Smart Energy Water (SEW)•  January 2021 - January 2024•  Noida

Worked with multiple clients like Dominion Energy, Liberty Customer First Utilites, COL, NPPD, SESB. Worked under SCM product of SEW to design and maintain the database infrastructure for these clients using tools like MSSQL, PostgreSQL, ETL(Talend), PLSQL(Oracle SQL). Developed and implemented efficient ETL processes to streamline data integration and improve data quality. Enforced data security measures, including access controls and encryption, to adhere to industry regulations and protect sensitive information. Developed automation scripts using Python to streamline data processing. Loading CIS files in ETL to process big data. Worked on stored procedures and complex SQL queries in MsSQL and Postrgres to extract, transform and load data from multiple sources.