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