Descrição
Job Summary:
Salary
S$7,000 - S$10,000 / Monthly
Job Type
Seniority
Mid
Years of Experience
At least 5 years
Tech Stacks
ETL Oracle SSRS SSIS Vault PowerBI MSSQL SQL.NET
Role: Data Engineer -EDW|SSIS| ETL |SSRS | -* 12 months Renewable contract*
Experience: Minimum of 5 years
Location : Changi Business Park
Benefits:
- Renewable contract (Performance-based, with possibility of conversion to perm)
- Medical Insurance Coverage
- Leave credits
- Performance Bonus
We are in need of an experienced SQL Server Integrated Services (SSIS) | SSRS | SWL | EDW| ETL Developer who will work with business users and members of the technical team on the architecture, design, and development of highly scalable ETL processes.
The Senior Consultant must have 4 + years’ experience with the Enterprise Data Warehouse architecture, design, development and deployment of ETL processes using EDW |SSIS |SSRS |.NET
Note: Position requires the ability to work various work schedules that may include night standby, scheduled weekend activity and/or holiday activities.:
MUST HAVE SKILLS:
Enterprise data warehouse (EDW)
SSIS
SSRS
ETL
.NET
Power BI
Data Transformation from the core banking system (T24)
Additional responsibilities of this role will include the following:
- Deliver projects/work on-time, on-budget, and in a way that accomplishes project goals 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.
- Document designs, develop data quality components and establish and/or conduct unit tests.
- 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 ,EDW,SSRS,PowerBI, T24 ,.NET
- 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
Note: Position requires the ability to work various work schedules that may include night standby, scheduled weekend activity and/or holiday activities.: