Principal Consultant - Singapore - OPTIMUM SOLUTIONS (SINGAPORE) PTE LTD

Description

Job Role:

• Develop and implement technical best practices for data movement, data quality, data cleansing, and other ETL-related activities. Develop and ensure adherence to locally defined standards for all developed components.

• Hands-on SQL knowledge with experience solving complex SQL problems, writing stored procs/functions and using it for ETL integration layer (SSIS)

• Implement best practices using modern tech stack to improve and simplify complex processes.

• Experience in relational databases like MS SQL Server and programming skills in T-SQL

• Maintain "common code" libraries, so objects can be shared and folders for all Environments (Dev, System Test and Production), Code Check-In/Check-Out procedures and assists in managing SIT/DEV.

• Able to read Data Models to translate them into ETL loads into Data Warehouse.

• Participate in requirements, design, and development reviews. Conduct or participate in meetings with owners of key system components to fully understand current data and systems environments. Resolve source data issues and refine transformation rules.

• Analyze source system data to assess data quality. Work with technical team to determine strategies for handling data anomalies that are identified. Design ETL processes and develop source-to-target data mappings, integration workflows, and load processes.

• Use the SSIS platform to extract, transform, and load data. Develop, test, integrate, and deploy ETL routines using ETL tools and external programming/scripting languages as necessary. Write and maintain unit test cases.

• Provide data analysis and technical documentation for both source and target mappings.

Requirements and Qualifications:

• 5+ years of hands-on experience with MS SQL Server SSIS and MS Visual C#

• Possess understanding of modern data warehouse architectures and data warehouse modernization techniques.

• Good knowledge of BI architecture, data warehousing concepts, and data vault model

• Deep Knowledge of SQL language with common database platforms such as SQL Server and Oracle

• Knowledge and experience of development using Java/Python is an advantage.

• Knowledge and experience with Control M Scheduler is a plus

• Understanding of ERP products such as Oracle Fusion is a plus.