Tata Consultancy Services
Developer
Pay$85000.00 - $115000.00 / year
LocationCharlotte/North Carolina
Employment typeOther
What's your preference?
Job Description
- Req#: 358914
- Primary Skill: Oracle PLSQL.
- Secondary: Core Java, Cassandra, Unix.
- Experience: Minimum 7 years.
- Design, develop, and maintain complex PL/SQL packages, procedures, functions, triggers and views for mission critical applications.
- Write high-performance, scalable PL/SQL code for large and complex business logic.
- Write efficient SQL queries for data extraction and transformation.
- Tune PL/SQL code and SQL queries for performance optimization.
- Analyze execution plans and apply indexing strategies.
- Analyze execution plans, optimize SQL and PL/SQL for performance (bulk operations, indexing, pipelined functions).
- Refactor poorly performed queries and stored procedures.
- Assist in data modeling and schema design for new feature or systems.
- Ensure normalization, integrity constraints, partitioning, and effective indexing.
- Collaborate with DBAs for capacity planning and system tunning.
- Core Java Integration.
- Build Java components that interact with Oracle database using JDBC/ORM/Spring frameworks.
- Collaborate with Java developers to ensure seamless integration of PL/SQL procedures into application layers.
- Debug and enhance backend services built with Java.
- Data Handling and ETL Support.
- Support ETL operations through PL/SQL logic and scripts.
- Assist in data validation, cleansing, and transformation task.
- Work with large volumes of data across different systems.
Skill: Oracle SQL + Java Developer
Must Have Technical/Functional Skills:Roles & Responsibilities:Database Development and Optimization:Database Design and Architecture:Salary Range - $85,000-$115,000 a year
#LI-NS2About the company
Tata Consultancy Services is an Indian multinational information technology services and consulting company headquartered in Mumbai, Maharashtra, India with its largest campus located in Chennai, Tamil Nadu, India.