Data Architect

Data architect

Job Title

Data Architect

Reporting Structure

Project Manager

Education

Graduation in Engineering/ Computer Science/

Information Technology or similar field or post-graduation in above mentioned discipline from a recognized University

Experience/ Qualifications

· 6–10 years of experience in enterprise data architecture and migration projects

· Domain expertise in HRMS systems (payroll, employee records, benefits, performance management, compliance reporting)

· Experience in data modeling and migration of HRMS modules (employee master data, organizational hierarchies, leave/attendance, compensation structures)

· Proven experience in end-to-end data migration from Sybase to Oracle databases , including schema assessment, target schema design, and migration execution

· Hands-on expertise in designing, building, and optimizing ETL/ELT pipelines using tools such as Nifi, Informatica, ODI or equivalent

· Experience implementing incremental loads, Change Data Capture (CDC), and real-time data integration

· Ability to assess source schemas, design target schemas, and create migration runbooks

· Hands-on expertise in de signing & development of Oracle database solutions that meet business requirements and scalability needs

· Expertise in handling large-scale data migrations, including BLOB/CLOB migration for unstructured data

· Implement partitioning, clustering, and caching strategies as needed

· Optimize database performance through effective schema design, indexing strategies, query optimization techniques and large-scale data migration strategies

· Perform database capacity planning and manage storage requirements

· Implement and enforce data governance standards, compliance and database security policies

Responsibilities

• · Design, build, and optimize ETL/ELT pipelines to support Sybase-to-Oracle migration projects

• · Lead and execute data migration strategies , ensuring reliability, scalability, and compliance with RBI standards

• · Collaborate with application developers to design and optimize SQL queries, stored procedures, and database code.

• · Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization

• · Identify and design data architecture frameworks including security, metadata, reference data, and master data

• · Ensure data quality, consistency, and compliance with RBI and enterprise standards.

• · Contribute to strategic roadmaps for RDBMS consolidation, modernization, and future migrations

• Location

• Navi Mumbai / Mumbai

• Employment Type

• All positions are on fixed term contract on a full-time basis exclusively for ReBIT, initially for a period of five years, extendable by mutual consent