Python & Oracle Data Engineer | ETL & DW Specialist

Tata Consultancy Services Limited; Charlotte (NC); On-site; USD 110,000 - 125,000; Full time

Job summary

Tata Consultancy Services Limited in Charlotte, NC is seeking a Python & Oracle Developer to design, implement, and optimize data processing and warehousing solutions. You will work on complex SQL, Oracle PL/SQL, and Python-based ETL pipelines, ensuring data integrity and performance.

The role emphasizes data modeling, schema design, and collaboration with analysts and architects. Strong analytical skills and Agile/Scrum experience are expected.

Qualifications

• Strong expertise in Oracle SQL and PL/SQL.
• Experience with complex queries, joins, and subqueries.
• Proficient in data modeling and star/snowflake schemas.
• Background in data warehousing (BFSI) preferred.

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.

Skills

Python

Oracle SQL

PL/SQL

Data modeling

ETL

Pandas

NumPy

SQLAlchemy

cx_Oracle

Agile/Scrum

Data warehousing

Job description

Tata Consultancy Services Limited in Charlotte, NC is seeking a Python & Oracle Developer to design, implement, and optimize data processing and warehousing solutions. You will work on complex SQL, Oracle PL/SQL, and Python-based ETL pipelines, ensuring data integrity and performance.

The role emphasizes data modeling, schema design, and collaboration with analysts and architects. Strong analytical skills and Agile/Scrum experience are expected.