Oracle PL / SQL Developer
NTT DATA Services
Req ID: 60011
At NTT DATA Services, we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees are key factors in our company’s growth, market presence and our ability to help our clients stay a step ahead of the competition. By hiring the best people and helping them grow both professionally and personally, we ensure a bright future for NTT DATA Services and for the people who work here.
NTT DATA Services currently seeks a Oracle PL / SQL Developer to join our team in Knoxville, Tennessee (US-TN), United States (US).
NTT data is currently hiring for an Oracle Developer in Knoxville TN.
We are looking for a Sr. Application Developer to implement and support the Master Data Management platform.
Candidate will provide input and support for, and performs full systems life cycle management activities (e.g., analysis, technical requirements, design, coding, testing, implementation of systems and applications software, etc.).
Participate in planning and execution for new projects and enhancements including estimation, task and resource planning.
Performs component, data, security and integration architecture design and testing to meet business requirements.
Collaborates with teams and supports emerging technologies to ensure effective communication and achievement of objectives.
We are looking programming experience as an Oracle PL/SQL Developer in Analysis, Design, Administration and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
Certifications in Oracle professional with strong knowledge on Oracle Architecture and Database Design.
Excellent knowledge in Oracle12c/11g/10g/9i, PL/SQL, SQL *PLUS, SQL Developer, TOAD, PL/SQL Developer.
Experience in Database design using Normalization.
Knowledge on Anonymous Blocks, Autonomous Transactions, Procedures, Functions, Record Types, Collections, Analytical Functions, Dynamic SQL/PLSQL, Pipelining, Hierarchy Queries, Cursors, Exception Handling and Advanced Queuing.
Experience in writing SQL Queries, Sub Queries, Views, Materialized Views, Packages, Triggers, Ref Cursors, Dynamic SQL, Exceptions.
Experience in RMAN backups and recovery to include full and incremental backups and cloning a database, handled complex restoration scenarios.
Experience in Installation and configuration of Oracle 9i, 10g and 11g in UNIX/LINUX and Windows environment and implementation of RAC, 11g Grid Infrastructure with ASM and ACFS File systems.
Experience in designing business requirements and modeling using oracle designer.
Experience in developing Joins, Indexes and sequences.
Experience in query optimization, performance and tuning using Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
Extreme Use of Exception Handling methods along with Pragma_Exception_init
Experience in Migrating from Legacy Mainframe to Oracle, accessing Oracle tables in DB2.
Experience in writing Technical Design Documents and Developing Unit Test Documents.
Well versed in system analysis, Relational and Dimensional Modeling, Database design and implementing RDBMS specific features and data warehousing.
Experienced in developing Conceptual, Logical and Physical models using Erwin and Power designer.
Well versed in Forward and Reverse Engineering principles.
Efficient in Dimensional Data Modeling for Data Mart design, identifying Facts and Dimensions and Strong understanding of principles of data warehousing, fact tables, dimension tables, Slowly Changing Dimensions (SCD) Type I and Type II.
Experience in designing star schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS architecture by using tools like Erwin data modeler.
Coherent with Normalization/Denormalization techniques & normalizations up to 3NF.
Knowledge on Teradata tools and utilities like BTEQ, SQL Assistant, Teradata Manager
Articulate with Data Conversion, Data Quality, Data Profiling and System Testing and implementing RDBMS features and ETL and data integration.
Experience in job schedulers like crontab, Python, UNIX & LINUX Shell Scripting.
5 years of full life cycle Oracle PL/SQL development
3 years of Unix shell scripting
This position is only available to those interested in direct staff employment opportunities with NTT DATA, Inc. or its subsidiaries. Please note, 1099 or corp-2-corp contractors or the equivalent will NOT be considered. We offer a full comprehensive benefits package that starts from your first day of employment.
About NTT DATA Services
NTT DATA Services partners with clients to navigate and simplify the modern complexities of business and technology, delivering the insights, solutions and outcomes that matter most. We deliver tangible business results by combining deep industry expertise with applied innovations in digital, cloud and automation across a comprehensive portfolio of consulting, applications, infrastructure and business process services.
NTT DATA Services, headquartered in Plano, Texas, is a division of NTT DATA Corporation, a top 10 global business and IT services provider with 118,000+ professionals in more than 50 countries, and NTT Group, a partner to 88 percent of the Fortune 100. Visit ******************* to learn more.
NTT DATA, Inc. (the Company) is an equal opportunity employer and makes employment decisions on the basis of merit and business needs. The Company will consider all qualified applicants for employment without regard to race, color, religious creed, citizenship, national origin, ancestry, age, sex, sexual orientation, gender identity, genetic information, physical or mental disability, veteran or marital status, or any other class protected by law. To comply with applicable laws ensuring equal employment opportunities to qualified individuals with a disability, the Company will make reasonable accommodations for the known physical or mental limitations of an otherwise qualified individual with a disability who is an applicant or an employee unless undue hardship to the Company would result.
NTT Data – 4 hours ago – report job – original job
On Company Site
To apply for this job please visit itjobpro.com.