Python & Oracle Developer

Job Description

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

Qualifications:

BACHELOR OF COMPUTER SCIENCE