You will be working under a Team Leader, analyzing challenging requirements, flying to
client offices in Asia Pacific, attending meetings and interacting with end users,
preparing specifications, undertaking development of complex application functions in
PL/SQL. You will additionally participate in code review and testing. &n
Read more
You will be working under a Team Leader, analyzing challenging requirements, flying to
client offices in Asia Pacific, attending meetings and interacting with end users,
preparing specifications, undertaking development of complex application functions in
PL/SQL. You will additionally participate in code review and testing.
We are looking for smart, self-learning problem-solvers who are not only knowledgeable
in enterprise technologies but also know how to work collaboratively with others to apply
technologies in creative, practical and efficient ways. Three important qualities we seek:
∙Ability to work in a fast paced team environment with constantly changing
priorities.
∙Ability to design, develop and implement multi threaded PL/SQL code for OLTP
and reporting solutions to meet business needs.
Technical Skills:--
-Job Functions
Design, Development, Documentation, Maintenance, Coordination,
Support.
-Languages
Oracle PL/SQL, Advanced PL/SQL
-Platforms
Windows
Database
Oracle 19c
-Advance
Tools/Technologies
Oracle 19c, Toad, Pl Sql Developer
-Domain Knowledge
Finance, Insurance, Music
Responsibility -
Ø Must have worked on oracle Pl/Sql
Ø Must have experience in Packages, Procedures, Functions, Triggers, Views, Cursors, PL/SQL Table, Nested Tables, Arrays, Sequences, Indexes, synonyms, file handling, DBMS Scheduler, oracle text, Subqueries, Inline views, Materialized view in oracle database
Ø Experience in writing and tuning complex and large SQL queries with the help of explain plan, trace files, tkprof.
Ø Good at debugging and testing code
Ø Experience in Database Design, Modeling And Normalization.
Ø Experience with data flow diagrams, data dictionary techniques, Entity relation modeling.
Ø Sound analytical, problem solving and trouble shooting skills.
Ø Good spoken and written communication skills.
Ø Ability to work well in both a team and individual environment.
Ø Experience in data migration from legacy system to new system.
Ø Sound Experience in Toad, SQL developer.
Ø Knowledge of Windows Operating System
Ø Integral member of team, which is responsible for database development of various modules of core financial application.
Ø Responsible for understanding the all aspects of systems and resolving numerous technical issues.
Ø Developing and maintenance of PL/SQL codes.
Ø Handling client side support.
Ø Providing client support.
