Tech Business Analyst (Oracle Data Integration & Enterprise Applications)

CMC-APAC Private Limited; Singapore; On-site; SGD 90,000 - 130,000; Full time

Job summary

CMC-APAC Private Limited is seeking a Technical Business Analyst to support enterprise data services, system integrations and customer-facing platforms. You will work with stakeholders, DBAs, and vendors to ensure data integrity, availability and timely delivery across interconnected systems.

The role requires strong business analysis capabilities with knowledge of Oracle databases, data replication, APIs and enterprise architectures.

Qualifications

• Experience gathering requirements from stakeholders and documenting them clearly.
• Experience coordinating SIT/UAT, deployment activities and production support.

Responsibilities

• Engage stakeholders to understand objectives and translate into business, functional and technical requirements.

Skills

Stakeholder engagement

Requirements gathering

RESTful APIs

Oracle databases

Data replication

System integrations

Analytical skills

Troubleshooting

Education

Degree in IT/CS/IS/Engineering

Tools

Oracle GoldenGate

SQL

Data integration tools

Job description

About the role

As a Technical Business Analyst deployed to our Client, you will play a key role in supporting and enhancing enterprise data services, system integrations and customer-facing digital platforms. A significant part of the role involves supporting enterprise data replication and data exchange services that enable the reliable flow of operational data across multiple systems and platforms. You will work closely with business stakeholders, application teams, database administrators, infrastructure engineers and vendors to ensure the integrity, availability and timely delivery of data across interconnected systems.

The role requires strong business analysis capabilities, coupled with technical knowledge of Oracle databases, data replication technologies, APIs, system integrations and enterprise application architectures. You will be involved in requirements analysis, impact assessments, solution delivery, testing, production support and platform modernisation initiatives.

Key responsibilities

• Engage stakeholders to understand business objectives, operational requirements and customer needs, and translate them into clear business, functional and technical requirements
• Perform impact assessments, analyse business processes, document user stories and acceptance criteria, and review solution designs
• Support enterprise data replication and data exchange services that facilitate the movement of data across multiple source and consuming systems
• Analyse replication requirements, review source and target data structures, identify dependencies and assess the impact of system, application and database changes on existing data flows
• Work closely with database administrators and vendors to support replication technologies such as Oracle GoldenGate, troubleshoot replication issues and investigate data discrepancies
• Support the onboarding of new data integrations, review interface specifications, validate data mappings and facilitate end-to-end testing of data exchange services
• Coordinate SIT, UAT, integration testing and production verification activities
• Investigate incidents, perform impact assessments, facilitate root cause analysis and coordinate resolution efforts across technical teams and vendors
• Maintain business requirements, solution specifications, integration documentation, operational procedures and support guides
• Serve as a key liaison between business stakeholders, vendors and technical teams

About you

• Degree in Information Technology, Computer Science, Information Systems, Engineering or a related discipline
• At least 5 years of relevant experience in Business Analysis, Systems Analysis, Application Support, Integration Services or Enterprise Data Platforms
• Strong experience in requirements gathering, stakeholder engagement and solution analysis
• Good understanding of Oracle databases, data structures, SQL queries and database concepts
• Experience supporting enterprise applications, system integrations, data exchange platforms or customer-facing digital services
• Experience coordinating SIT, UAT, deployment activities and production support
• Understanding of RESTful APIs, web services, API authentication methods and enterprise integration patterns
• Excellent communication and stakeholder management skills
• Strong analytical, problem-solving and troubleshooting skills
• Familiarity with Oracle GoldenGate (OGG), data replication technologies or change data capture solutions