Python & Oracle Developer

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

Job summary

Tata Consultancy Services in Charlotte, NC is seeking a Python & Oracle Developer to design and maintain Oracle PL/SQL programs, develop complex SQL queries, and build Python data processing pipelines.

The role emphasizes data modeling, schema design, ETL pipelines, and performance tuning, with BFSI domain experience preferred and an Agile work environment.

Qualifications

• Strong expertise in Oracle SQL and PL/SQL.
• Complex queries, joins, subqueries, stored procedures.
• ER modeling and normalization/denormalization.
• Star and Snowflake schema design.
• Data processing using Pandas and NumPy.
• Database connectivity via cx_Oracle and SQLAlchemy.
• ETL processes and data pipelines.
• Query optimization and performance tuning.
• Indexing, partitioning, and execution plans.
• Experience in data warehousing / BFSI domain preferred.
• 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.

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.

Skills

Oracle SQL

PL/SQL

SQL optimization

Data modeling

Python

Pandas

NumPy

ETL

Data warehousing

Agile/Scrum

cx_Oracle

SQLAlchemy

Star Schema

Snowflake Schema

Job description

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