Python & Oracle Developer

Tata Consultancy Services; Charlotte (NC); On-site; USD 110,000 - 125,000; Full time

Job summary

Tata Consultancy Services Limited in Charlotte, NC is seeking a Python & Oracle Developer to design, implement, and optimize data processing and warehousing solutions. You will work on complex SQL, Oracle PL/SQL, and Python-based ETL pipelines, ensuring data integrity and performance.

The role emphasizes data modeling, schema design, and collaboration with analysts and architects. Strong analytical skills and Agile/Scrum experience are expected.

Qualifications

• Strong expertise in Oracle SQL and PL/SQL.
• Experience with complex queries, joins, and subqueries.
• Proficient in data modeling and star/snowflake schemas.
• Background in data warehousing (BFSI) preferred.

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.

Skills

Python

Oracle SQL

PL/SQL

Data modeling

ETL

Pandas

NumPy

SQLAlchemy

cx_Oracle

Agile/Scrum

Data warehousing

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

Location

Charlotte, NC

Function

TECHNOLOGY

Role

Engineer

ID

432774

Skills

Python

Salary Range

$110,000 - $125,000