Python & Oracle Developer

Tata Consultancy Services Limited

Charlotte, NC, United States

about 1 month ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Compensation

$100,000.0 - $120,000.0

Working hours

Regular working hours

Job source

www.indeed.com

Tech stack

Data Validation Data Integrity Extract Transform Load (ETL) Data Warehousing Database Connection Database Queries Entity Relationship Models Python (Programming Language) NumPy Oracle SQL Developer Performance Tuning Query Optimization

+12 more

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