$100,000–$120,000 Per Year
Agile Programming Methodologies, Analysis Skills, Business Analysis, Business Skills, Data Management, Data Modeling, Data Processing, Data Quality, Data Warehousing, Database Design, Database Extract Transform and Load (ETL), Entity Relational (ER) Modeling, Identify Issues, Legal, Loan Funding, Oracle, Oracle Database, Oracle PL-SQL, Performance Tuning/Optimization, Problem Solving Skills, Python Programming/Scripting Language, Query Optimization, Requirements Management, SQL (Structured Query Language), Scripting (Scripting Languages), Scrum Project Management and Software Development, Snowflake Schema, Software Engineering, Star Schema, Student Loans, Technical/Engineering Design
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
T
Tata Consultancy Services Ltd