Job Description:
Job Description
Job Description
· Analyze / Review the requirement, prepare the design document, system test plan as per requirements.
· Developing / Reviewing Code
· Experience in Jira Tool for creating the Epics, Features, User stories, generate reports.
· Experience of working in an Agile environment and the ability to work in a constantly evolving project, without losing sight of the requirements or the overall vision
· Good understanding of the RDBMs and experience in writing SQL queries. Ensure delivery within schedule by adhering to the engineering and quality standards.
· Own & deliver end to end projects within Oracle and on-prem for Payments Data Platform.
· Once a month available on support rota for a week for on call (24/7).
· Able to work under pressure on deliverables, P1 Violations, Incidents.
· Understand requirements, design & develop - Event Driven and Near Real time data patte
s, - Ingress | Egress, Real time and streaming· Provide Weekly & Monthly Project Updates to stake holders & Management. Removes roadblock and facilitates handoffs where needed to keep sprint running smoothly.
· Should be fluent and clear in communications (Written & Verbal)
Experience
· Overall experience of 9+ years and considerable experience in Oracle, Sql, Plsql.
· Expertise in database using Oracle 12 c and above.
· Able to Analyze existing SQL queries for performance improvements.
· Should have working experience on managing large database.
· Should have worked on requirements, design & develop - Event Driven and Near Real time data patte
s - Ingress | Egress, Real time and streaming.· Expertise in Advanced PLSQL and Performance tuning.
· Very Strong Oracle PLSQL programming experience (e.g. Procedures, packages, functions, exceptions etc.).
· Experience in Table, Functions, Indexes, Table partition, Analytical functions.
· Experience in data extraction from JSON, XML and flat file
· Must have thorough understanding, knowledge, exposure to advanced PL/ SQL (collections, Native Dynamic SQL etc.).
· Knowledge on Large scale XML processing and parsing.
· Apache Kafka & MQ Knowledge Added Advantage.
· Exposure to microservices based architecture and deployment to private/public cloud
· Should have lead a team of min 2-4 resources with Excellent written & verbal communications
- As per Agile development methodology should be flexible to support developed code in production environment
Key Skills
Oracle, Sql, Plsql, Stored proc, Java, SDLC
Purview is a leading Digital Cloud & Data Engineering company headquartered in Edinburgh, United Kingdom having a presence in 14 countries India (Hyderabad, Bangalore, Chennai and Pune), Poland, Germany, Finland, Netherlands, Ireland, USA, UAE, Oman, Singapore, Hong Kong, Malaysia and Australia.
We have a strong presence in UK, Europe and APEC, providing services to Captive Clients (HSBC, NatWest, Northern Trust, IDFC First Bank, Nordia Bank etc) in fully managed solutions and co-managed capacity models. Also, we support various top IT tier 1 organisations (Capgemini, Deloitte, Wipro, Virtusa, L&T, CoForge, TechM and more) to deliver solutions and workforce/resources.
Company Info:
3rd Floor, Sonthalia Mind Space
Near Westin Hotel, Gafoor Nagar
Hitechcity, Hyderabad
Phone: +91 40 48549120 / +91 8790177967
Gyleview House, 3 Redheughs Rigg,
South Gyle, Edinburgh, EH12 9DQ.
Phone: +44 7590230910