ETL Developer - Singapore - OPTIMUM SOLUTIONS (SINGAPORE) PTE LTD

OPTIMUM SOLUTIONS (SINGAPORE) PTE LTD Singapore

5 days ago

Description

Roles & Responsibilities

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.

Tell employers what skills you have

Technical Documentation
Oracle
Data Analysis
T-SQL
ERP
ETL
Data Quality
Test Cases
SQL
SQL Server
C#
SSIS
Visual C
Data Warehousing
Databases

Etl Developer

4 days ago

TANGSPAC CONSULTING PTE LTD Singapore

Working for banking client, you will be responsible for developing ETL solution · Roles: · Working with business analysts to define business rules for data quality management and migration. · Translating business requirement specifications and rules into technical specifications ...
Etl Developer

1 week ago

Cognizant Singapore

We are seeking an experienced ETL Developer to join our growing team. · Key Responsibilities: · - Able to participate in requirement gathering by engaging SME's & Technical teams. · - Understanding on banking domain with an exposure on Retail/Corporate/Wealth Management/Investmen ...
Etl Developer

1 week ago

Experis Singapore

**Responsibilities**: · - Design, develop, optimize and verify **Qlik Sense** data model and dashboards. · - Participate in requirement gathering and data analysis. · - Maintain and support **Qlik** environment including access configuration and building authorization rules. · - ...
Etl Developer

3 days ago

ABS CONNECT PTE. LTD. Singapore

**Responsibilities**: · Have 10+ years of experience · Create an ETL mapping document from the business requirements. · Develop framework and ETL artifacts using the ETL mappings. · **Requirements**: · Experience in Data Warehousing development. · ETL developer who is responsible ...
Etl Developer

1 week ago

NodeFlair Singapore

**Job Summary**: · **Salary** · S$9,000 - S$12,000 / Monthly · **Job Type** · **Seniority** · Senior · **Years of Experience** · At least 6 years · **Tech Stacks** · ETL Jenkins API Shell Script HDFS HBase Shell UNIX Git Java Hive NoSQL Bitbucket SQL Hadoop Python · **Responsibil ...
Etl Developer

1 week ago

NodeFlair Singapore

**Job Summary**: · **Salary** · S$7,500 - S$9,500 / Monthly · **Job Type** · **Seniority** · Senior · **Years of Experience** · At least 6 years · **Tech Stacks** · ETL Jenkins API Shell Script HDFS HBase Shell UNIX Git Java Hive Linux NoSQL Bitbucket SQL Hadoop Python · Role: ET ...
Etl Developers

1 week ago

SAKSOFT PTE LIMITED Singapore

Experience: 6-9 years · Role: ETL Developers · Key Skills: · Data Processing, 3-tier environment installation, configuration and · troubleshooting, Shell Script, SQL, NOSQL, System Integration, System Diagram · Key Responsibilities: · - Participate in end-to-end projects for syst ...
Etl Developer

3 days ago

NodeFlair Singapore

**Job Summary**: · **Salary** · S$7,000 - S$9,500 / Monthly · **Job Type** · **Seniority** · Senior · **Years of Experience** · At least 6 years · **Tech Stacks** · ETL Jenkins API Shell Script HDFS HBase Shell UNIX Git Java Hive Linux NoSQL Bitbucket SQL Hadoop Python · Role: ET ...
Etl Developer

1 week ago

U3 Infotech Pte Ltd. Singapore

Job · - ETL Developer(Obiee) · Informatica Power Centre · Oracle · Oracle PL/SQL · Unix (Good to have) · OBIEE (Good to have) · Preferred Banking industry domain. ...
Etl Developer

1 week ago

Encora Singapore

Encora is a global Software and Digital Engineering company that helps business overcome the Software Engineering Talent shortage and provides next-gen services and such as Predictive Analysis, Artificial Intelligence & Machine Learning, IoT, Cloud, and Test Automation. We count ...
Etl Developer

2 days ago

EVO OUTSOURCING SOLUTIONS PTE. LTD. Singapore

**Responsibilities**: · - Analyzing data source, designing, testing and implementing analytic reports and dashboards. · Skills/Requirement · - A graduate of bachelor's degree in computer science and/or equivalent · - At least 3 years of ETL and BI experience · - Experienced in In ...
Etl Developer

1 week ago

CLPS TECHNOLOGY (SINGAPORE) PTE. LTD. Singapore

Create and optimize end-to-end data pipelines to populate the data marts from multiple data sources · - Perform data profiling to understand data quality of source data, and address data quality issues through data transformation and data loading · - Provide support for UAT and P ...
Informatica Etl Developer

1 week ago

FUTUREX TECHNOLOGIES PTE. LTD. Singapore

We are looking for a consultant which can execute the implementation data integration & management solution using ETL tool. The consultant will deliver value-added solutions to our banking client. · The main tasks/responsibilities will include: · Involve in full cycle of project ...
Etl Lead Developer

1 week ago

Cognizant Singapore

Cognizant SingaporePosted 13 minutes ago Permanent Competitive · - ETL Lead Developer · - As the ETL Lead Developer, you will collaborate with cross-functional teams, including data analysts, database administrators, software engineers, and business stakeholders, to understand re ...
Etl + Qliksense Developer

1 week ago

ESOL PTE. LTD. Singapore

**ETL Developer: · Job responsibilities: · - Design, develop, optimize, and verify Qlik Sense data model and dashboards. · - Participate in requirement gathering and data analysis. · - Maintain and support Qlik environment including access configuration and building authorization ...
Etl Lead Developer

1 week ago

Cognizant Singapore

As the ETL Lead Developer, you will collaborate with cross-functional teams, including data analysts, database administrators, software engineers, and business stakeholders, to understand requirements, implement solutions, and provide ongoing support. Your strong technical skills ...
Etl Developer(L3)

2 days ago

Tek Village Pte Ltd Singapore

**Role & Responsibilities** · Participate in end-to-end projects for system implementation of MLS system · - Engage and collaborate with Architects, Security and Development Lead to ensure solution design complies with enterprise design principles, security, and control standards ...
Avp, Etl/iib Developer

1 week ago

Sumitomo Mitsui Banking Corporation (SMBC) Singapore

**Responsibilities**: · - Perform impactful analysis for upstream and downstream changes that affect the systems · - Design, develop and deploy programs, batch scripts, ETL flows (using Elixir Ambience tool), complex PL/SQL and T-SQL scripts (packages, stored procures, functions, ...
Hiring for Etl Informatica Developer

1 week ago

PATH INFOTECH PTE. LTD. Singapore

Degree/Diploma in Computer Science/ Engineering, Information Technology/ System or equivalent. · - Minimum 8 years of experience in design, develop, deploy, and maintenance of BI solutions · - Equipped with key SQL Skillsets on Oracle, Teradata and MS-SQL Server databases · - Kno ...
Etl (Ssis/SQL) Developer

1 day ago

Cognizant Singapore

Cognizant is seeking an experienced ETL (SSIS/SQL) Developer to lead the implementation and execution of our ERP General Ledger (GL), Accounts Payable (AP), Asset Management (AM), and Billing modules. This full-time role based in Singapore has a favourable salary and the opportun ...