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

TCS Employee Benefits Summary:

Discretionary Annual Incentive.

Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.

Family Support: Maternal & Parental Leaves.

Insurance Options: Auto & Home Insurance, Identity Theft Protection.

Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.

Time Off: Vacation, Time Off, Sick Leave & Holidays.

Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Salary Range: $100,000-$120,000 a year

Location

Charlotte, NC

Job Function

TECHNOLOGY

Role

Engineer

Job Id

421275

Desired Skills

Oracle | Python

Salary Range

$100,000-$120,000 a year

Desired Candidate Profile

Qualifications : BACHELOR OF COMPUTER SCIENCE