Python & Oracle Developer

Overview

Location:

Charlotte, NC

Experience:

8 - 10 years

• Strong expertise in Oracle SQL & PL/SQL
• Complex queries, joins, subqueries, stored procedures, functions, packages
• Star/snowflake schema design
• Data processing (Pandas, Num Py)
• Database connectivity ( / SQL Alchemy)
• 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
• 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

Qualifications:

BACHELOR OF COMPUTER SCIENCE