Python & Oracle Developer

Tata Consultancy Services Limited
Charlotte, United States of America
6 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Compensation
$ 120K

Job location

Charlotte, United States of America

Tech stack

Data Validation
Data Integrity
ETL
Data Warehousing
Database Connection
Database Queries
Entity Relationship Models
Python
NumPy
Oracle SQL Developer
Performance Tuning
Query Optimization
SQL Stored Procedures
PL-SQL
SQL Databases
SQLAlchemy
Data Processing
Freeform SQL
Database Optimization
Database Performance
Indexer
Pandas
Information Technology
Data Pipelines

Job description

  • 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

Requirements

  • 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, Qualifications : BACHELOR OF COMPUTER SCIENCE

Benefits & conditions

(part of Tata group) 3.93.9 out of 5 stars Charlotte, NC $100,000 - $120,000 a year, Pulled from the full job description

  • Pet insurance
  • Health insurance
  • Vision insurance
  • Dental insurance
  • Commuter assistance, 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

Apply for this position