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