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