This job listing has expired and the position may no longer be open for hire.

Database with Oracle SQL and PLSQL. at Cognizant

Posted in Information Technology 30+ days ago.

Type: Full-Time
Location: Morrisville, North Carolina





Job Description:

Database with Oracle SQL and PLSQL.

Location and Travel: North Carolina,NC

*This role is not able to offer visa transfer or sponsorship now or in the future*

Job Description:


  • Senior Database resource with hands on experience and decision taking skills.

  • Independently understand, design and code application components.

  • Excellent knowledge of Oracle and relational database technology is a must.

  • Excellent understanding of OLAP vs OLTP, data ware housing concepts.

  • Exceptional knowledge of performance tuning, hints, optimizer joins

  • Analytical functions, bulk processing and advances oracle skills like advance queues, pipeline.

  • XML processing on Oracle.

  • Proper database design -  partitioning, pruning and related nuisances

  • ETL understanding and batch processing

  • Knowledge of packages and triggers

  • SQLLDR and other data loading tools

  • Be able to debug issues relate to Oracle as well as web during then batch quickly.

  • Excellent communication skills, be able to work with BA’s and users to understand functional and technical requirement documents.

  • Be able to design, maintain documents, and present to business.

Good to have Skills:


  • Azure and Cloud concepts nice to have.

  • Knowledge on advanced data management tools is added advantage.

  • Knowledge and experience in Unix scripting is also required.

  • Understanding and experience in maintaining and enhancing batch driven applications

Technical Skills






































SNo Primary Skill Proficiency Level * Rqrd./Dsrd.
1 PL/SQL PL1 Required
2 Big Data PL1 Required
3 Oracle OLAP PL1 Required
4 Azure PL1 Desired
5 XML PL1 Required

 

Domain Skills














SNo Primary Skill Proficiency Level * Rqrd./Dsrd.
1 Compliance Operations NA Desired

 

* Proficiency Legends






















Proficiency Level Generic Reference
PL1 The associate has basic awareness and comprehension of the skill and is in the process of acquiring this skill through various channels.
PL2 The associate possesses working knowledge of the skill, and can actively and independently apply this skill in engagements and projects.
PL3 The associate has comprehensive, in-depth and specialized knowledge of the skill. She / he has extensively demonstrated successful application of the skill in engagements or projects.
PL4 The associate can function as a subject matter expert for this skill. The associate is capable of analyzing, evaluating and synthesizing solutions using the skill.





More jobs in Morrisville, North Carolina


Alliance Health

Thermo Fisher Scientific

Kforce Inc
More jobs in Information Technology


COLSON GROUP HOLDINGS, LLC

SafeRack, LLC

Metro One Loss Prevention Services Group (Guard Division), Inc.