Tata Consultancy Services

Python & Oracle Developer

Tata Consultancy Services • $110K — $125K *
Charlotte, NC 28269In-Person
Finance & Insurance
Less than 5 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • Strong expertise in Oracle SQL & PL/SQL
  • Experience with complex queries, joins, subqueries, and stored procedures
  • Familiarity with ER modeling and database normalization
  • Knowledge of star/snowflake schema design
  • Proficient in Python libraries for data processing (Pandas, NumPy)
  • Experience with database connectivity tools (cx_Oracle / SQLAlchemy)
  • Background in data warehousing, preferably in the BFSI domain.
  • Strong analytical and problem-solving skills.

Responsibilities

  • Design and maintain Oracle PL/SQL programs
  • Develop and optimize complex SQL queries
  • Build and manage Python-based data processing pipelines
  • Work on data modeling and schema design
  • Troubleshoot job failures and data discrepancies
  • Implement performance tuning and optimization strategies
  • Develop ETL workflows and automation scripts.

Benefits

  • Opportunity to work in a collaborative Agile/Scrum environment
  • Engage with cross-functional teams including business analysts and data architects
  • Focus on complex problem-solving and advanced data processing
  • Professional growth in a data-driven industry like BFSI
  • Exposure to innovative technologies and methodologies in data handling.
Full Job Description
Python & Oracle Developer

Must Have Technical/Functional Skills
• Strong expertise in Oracle SQL & PL/SQL
• Complex queries, joins, subqueries, Stored procedures, functions, packages
• ER modeling, normalization/denormalization
• Star/snowflake schema design
• Data processing (Pandas, NumPy)
• Database connectivity (cx_Oracle / SQLAlchemy)
• ETL processes and data pipelines
• Query optimization and performance tuning
• Indexing, partitioning, and execution plans
• Experience in data warehousing / BFSI domain (preferred)
• Ability to translate business requirements into technical design
• Strong analytical and problem-solving skills
• Understanding of data validation and quality frameworks
• Experience working in Agile / Scrum environments

Roles & Responsibilities
• Design, develop, and maintain Oracle PL/SQL programs
• Develop and optimize complex SQL queries
• Build and maintain Python-based data processing pipelines
• Work on data modeling and schema design
• Troubleshoot and resolve:

Job failures

Data discrepancies

Database performance issues
• Implement performance tuning techniques

Query optimization

Indexing strategies
• Develop ETL workflows and automation scripts
• Ensure data integrity, consistency, and validation
• Collaborate with Business analysts, Data architects, Upstream/downstream teams

Salary Range- $110,000-$125,000 a year

About Tata Consultancy Services

Tata Consultancy Services (TCS) is an Indian multinational information technology (IT) services and consulting company, headquartered in Mumbai, Maharashtra, India. It is a subsidiary of Tata Group and operates in 149 locations across 46 countries. TCS is the largest Indian company by market capitalization and is ranked 11th on the Forbes Global 2000 list of the world's biggest public companies. TCS is also the second-largest IT services company in the world by revenue and the largest employer of women in India. The company provides services in areas including IT, consulting, and business solutions.
Learn more about Tata Consultancy Services
Size
469,261 employees
Industry
Information Technology
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Tata Consultancy Services

More Finance & Insurance Jobs

Find similar Python & Oracle Developer jobs:

NationwideCharlotte, NC