Virtusa

ORMB Architect (ATC)

Job Description

Experience in Billing landscape with Data-driven approach, define, design and drive Data architecture roadmap for ORMB architecture - Oracle Revenue Management and Billing.
Understanding of micro services architecture and other architecture patterns, REST APIs
Reading, parsing of JSON, XML and other structures and develop understanding of data attributes and values between two systems.
Experience in designing utilities and automating processes.
Use of various data modelling, DFD, Data lineage tools like Visio, reverse engineering tools
Must have experience working in Banking and Financial service industry specifically with a MNC Bank of size of HSBC
Must have experience analysing large size data, JSONs, XMLs, other formats and writing scripts to extract, transform and load using tools or developed automation tools
Oracle SQL, PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle 9i, 10g, 11g and 12c Relational Database Management System RDBMS
Experience in Analysis, Design and Implementation.
Good knowledge of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions.
Good knowledge of logical and physical Data Modeling using normalizing Techniques.
Good knowledge of Tables, Views, Constraints, Index B Tree, Bitmap and Function Based.
Good knowledge of Complex database objects like Stored Procedures, Functions, Packages, Cursors and Triggers using SQL and PL/SQL Conversion, Aggregate, Numeric, Character, General
Performance tuning.
Good understanding of Joins Outer, Left / Right Outer Join, Self, Inner, Cross Join.
Handling errors with Exceptions.
Hands on nested Subqueries, Dual Table.
Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
Good command on UNIX commands grep,scp, sort, crontab, mail
User Administration commands useradd, usermod, userdel, passwd, groupadd, groupmod, chown, chgrp
Good understanding of shell scripts for invoking SQL scripts.
Map, TypeTree, MDQ, Resource registry, Connectivity with multiple source / target systems Text File, CSV, XML, Database Debuging in case of any issue.
Knowledge of Jira, Confluence and Agile methodologies, Sprint, Story Points, Task Estimations during sprint planning.
Should have good communication skills,
Should be vigilant to identify the issues/risks well in advance.


Jobs at Hyderabad

Virtusa

Scrum Master

Full Time

Hyderabad, Telangana

View Details

Last Date: July 31, 2025

Virtusa

Salesforce developer

Full Time

Hyderabad, Telangana

View Details

Last Date: Dec. 31, 2024

Virtusa

Salesforce Developer

Full Time

Hyderabad, Telangana

View Details

Last Date: May 14, 2025

Virtusa

Senior .Net API Developer

Full Time

Hyderabad, Telangana

View Details

Last Date: Dec. 31, 2024

TCS

Sr. Java Lead

2 - 15 Years

Hyderabad, Telangana

View Details

Last Date: Dec. 31, 2024

Virtusa

React Native web Developer

Full Time

Hyderabad, Telangana

View Details

Last Date: Dec. 31, 2025

Virtusa

Consultant

Full Time

Hyderabad, Telangana

View Details

Last Date: Dec. 31, 2025

Virtusa

QA Lead

Full Time

Hyderabad, Telangana

View Details

Last Date: Dec. 31, 2024

Virtusa

Informatica QA

Full Time

Hyderabad, Telangana

View Details

Last Date: Dec. 31, 2024

Oracle

Applications Developer 4

Professional

Hyderabad, Telangana

View Details

Last Date: April 21, 2025

Virtusa

Senior Consultant

Full Time

Hyderabad, Telangana

View Details

Last Date: Dec. 31, 2024

Virtusa

Senior Angular Developer

Full Time

Hyderabad, Telangana

View Details

Last Date: June 30, 2025




More Jobs at Virtusa

Virtusa

Python React

Full Time

Chennai, Tamil Nadu

View Details

Last Date: March 31, 2025

Virtusa

.NET Lead

Full Time

Bangalore, Karnataka

View Details

Last Date: Dec. 31, 2024

Virtusa

Senior Java FSD Developer

Full Time

Bangalore, Karnataka

View Details

Last Date: Dec. 31, 2024

Virtusa

GCP Tech Lead

Full Time

Hyderabad, Telangana

View Details

Last Date: Dec. 31, 2024

Virtusa

Pega CSSA Developer

Full Time

Bangalore, Karnataka

View Details

Last Date: Dec. 31, 2024

Virtusa

IBM FileNet Developer

Full Time

Pune, Maharashtra

View Details

Last Date: Dec. 31, 2024

Virtusa

Full stack developer

Full Time

Hyderabad, Telangana

View Details

Last Date: Dec. 31, 2024

Virtusa

Pega CSSA Developer

Full Time

Hyderabad, Telangana

View Details

Last Date: Dec. 31, 2024

Virtusa

BA - Product Owner

Full Time

Chennai, Tamil Nadu

View Details

Last Date: June 30, 2025

Virtusa

Senior Architect - Java

Full Time

Hyderabad, Telangana

View Details

Last Date: Dec. 31, 2024

Virtusa

Senior Architect

Full Time

Bangalore, Karnataka

View Details

Last Date: Dec. 31, 2024

Virtusa

Java - Senior Consultant

Full Time

Hyderabad, Telangana

View Details

Last Date: Dec. 31, 2024