Amit is available for hire

Amit Jain

Verified Expert in Engineering

Database Design and Programming Developer

Singapore, Singapore

Toptal member since January 16, 2023

Expertise

Data Warehouse Data Engineering SQL ETL Data Science Data Analysis Oracle Development Business Intelligence Development Database Data Visualization Python

Bio

Amit is a data and analytics professional with 19 years of experience in architecture, design, and delivering data and business analytics solutions for global Fortune 500 companies. He has worked across banking, insurance, telecom, gaming and attractions, government, B2B eCommerce, life sciences, and higher education industries.

Portfolio

National University of Singapore

Oracle Database, SQL Server 2017, Informatica ETL, erwin Data Modeler...

Experience

Oracle Database - 19 years
Oracle PL/SQL - 19 years
Data Warehousing - 18 years
ETL Implementation & Design - 15 years
Database Programming - 15 years
Data Engineering - 15 years
Data Modeling - 15 years
Data Architecture - 12 years

Availability

Full-time

Preferred Environment

Oracle Database, Microsoft Power BI, Data Architecture, Data Engineering, Data Modeling, Data Warehousing, Data Visualization, ETL Implementation & Design, Master Data Management (MDM), Azure PaaS

The most amazing...

...data models I've designed were for a leading university's admissions, scholarships, and financial aid applications and processing systems.

Work Experience

Data Architect

2020 - PRESENT

National University of Singapore

Acted as the data architect for the modernization of the university's admission, scholarship, and financial aid application systems, including designing the normalized data models from scratch.
Conceptualized, designed, and implemented an enterprise operational data store (ODS) to meet the transactional data needs of various downstream information systems from other enterprise business applications.
Specified the ETL framework components and design for the enterprise data warehouse of the university.

Technologies: Oracle Database, SQL Server 2017, Informatica ETL, erwin Data Modeler, Data Architecture, Business Analytics, Database Programming, Database Design, Data Engineering, Data Modeling, Data Visualization, Data Warehousing, ETL Implementation & Design, Master Data Management (MDM), SQL, Data Analysis, Data Analytics, Data Warehouse Design, ETL Tools

Experience

Undergraduate Admissions System

https://www.nus.edu.sg/oam/apply-to-nus/application

The undergraduate admissions portal of the National University of Singapore. I was the data architect for the project and was in charge of designing the normalized data model, the data flows, and the data integration interface specifications for the application system.

Education

2013 - 2016

Master's Degree in Information Technology

Singapore Management University - Singapore, Singapore

2000 - 2003

Master's Degree in Computer Science

Madurai Kamaraj University - Tamil Nadu, India

Certifications

JUNE 2022 - PRESENT

Microsoft Certified: Azure Database Administrator Associate

Microsoft

APRIL 2022 - PRESENT

Microsoft Certified: Azure AI Fundamentals

Microsoft

MARCH 2022 - MARCH 2023

Microsoft Certified: Power BI Data Analyst Associate

Microsoft

FEBRUARY 2022 - PRESENT

Microsoft Certified: Security, Compliance, and Identity Fundamentals

Microsoft

FEBRUARY 2022 - PRESENT

Microsoft Certified: Azure Fundamentals

Microsoft

JANUARY 2022 - PRESENT

Microsoft Certified: Azure Data Fundamentals

Microsoft

Skills

Tools

Microsoft Power BI, Informatica ETL, Informatica Master Data Management (MDM), Oracle GoldenGate

Languages

SQL, Python 3, R

Paradigms

ETL, ETL Implementation & Design, Business Intelligence (BI), Database Design

Platforms

Oracle Database, KNIME, Azure PaaS, Denodo, Oracle Data Integrator (ODI), Azure

Storage

Master Data Management (MDM), Oracle SQL, Oracle PL/SQL, Database Programming, SQL Server 2017, Azure SQL Databases, Data Integration

Other

Data Engineering, Data Modeling, Data Warehousing, ETL Development, Data Warehouse Design, ETL Tools, Data Architecture, Business Analytics, erwin Data Modeler, Data Analysis, Data Analytics, Data Visualization, Azure SaaS, Exploratory Data Analysis, Data Science

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring