Attention prospective job seekers! Beware of fraudulent offers Read more

ORMB Architect (ATC)

Hyderabad, Andhra Pradesh, India
Apply
ORMB Architect (ATC) - CREQ184496
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.
Primary Location
Hyderabad, Andhra Pradesh, India
Job Type
Experienced
Primary Skills
Oracle Development
Years of Experience
10
Travel
No
Job Posting
08/04/2024

Join Virtusa

 

Please enter a valid email address to begin your application.

Thank you for verifying your email. Please proceed with the steps below to apply.

We only accept the following file extensions: .pdf, .docx or .doc
Maximum file size: 1 MB
File name must not include special characters or spaces (e.g. “name_resume.pdf”)

Please attach your CV/Resume, ensure it is in the correct format and smaller than 1MB.
We only accept the following file extensions:

Thank you. You already have an active account with Virtusa's hiring system. Please login to our portal to proceed with your application or apply for more opportunities.

LoginClick to Login

About Virtusa

Teamwork, quality of life, professional and personal development: values that Virtusa is proud to embody. When you join us, you join a team of 30,000 people globally that cares about your growth — one that seeks to provide you with exciting projects, opportunities and work with state of the art technologies throughout your career with us.

Great minds, great potential: it all comes together at Virtusa. We value collaboration and the team environment of our company, and seek to provide great minds with a dynamic place to nurture new ideas and foster excellence.

Virtusa was founded on principles of equal opportunity for all, and so does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.

Learn more