Principal Engineer - D20 Bishan, Ang Mo Kio, SG

Roles & Responsibilities

Responsibilities :

• Works with Solution Architect & Business Analysts on end-to-end solution, evaluate and develop high-quality data solutions.
• Works with non-technical, subject matter experts to understand underlying data behavior and characteristics in ways that will be new for such non-technical people.
• Works cooperatively with others to resolve data and process issues.
• Uses standard data modeling, data flow, and data documentation tools to analyze, document and present data analysis work.
• Plan & develop ETL, Data preparation / aggregation processes from various sources to MSSQL database / PostgreSQL DB
• Maintain, and optimize ETL and other ETL processes to adapt to changes in needs and requirements.
• Participate in MS SQL code reviews and provide guidance on best practices.
• Review new database schema changes.
• Familiar with T-SQL, stored procedures, functions, inline SQL, database structures
• Analyze existing SQL queries for performance improvements.
• Monitor code migration and database change management through various stages of the development cycle.
• Design & Develop procedures and scripts for data migration.
• Develop, implement, maintain policies and procedures, and document database architecture to ensure security and integrity of the databases.

Requirements :

Tell employers what skills you have

Data Analysis

Data Modeling

T-SQL

Architect

Informatica

Automation Tools

ETL

Microsoft SQL

Structural Engineering

Data Migration

Data Architecture

Communication Skills

Performance Tuning

Team Player

TSQL Stored Procedures