Tata Consultancy Services
Job Description
Must Have Technical/Functional Skills
4‑8 years hands‑on experience writing Teradata.
Experience with Teradata Utilities (BTEQ, Fast Load, Multi Load).
Extensive experience developing complex SQL code using Teradata stored procedures, macros, etc.
Strong Unix shell scripting skills.
Ability to create design documents and mapping documents.
Design and document development standards.
Knowledge of ETL and data‑warehouse concepts.
Knowledge of SQL Server and Autosys.
Roles & Responsibilities
Collaborate with stakeholders to understand current processes.
Collaborate with business to convert requirements into technical specifications.
Develop Teradata code meeting 100 % of technical specifications and business requirements.
Analyze, design, code, and test highly complex ETL processes for data warehouses and/or operational data stores.
Understand design for ETL applications, including data sources, targets, definitions, relationships, and business rules.
Work closely with technical leads, analysts, data modelers, and other developers to understand project requirements and contribute to solutions.
Provide post‑go‑live and application maintenance support.
Provide technical expertise on database design, data modeling, data warehousing, and data integration.
Create solutions for large and complex data‑driven applications.
Reconciliation and test case creation for developed solutions.
Design, develop, and support application solutions leveraging Teradata and its tools/Utilities.
Prepare test cases for unit testing, SIT, regression.
Take ownership and deliver independently; report to stakeholders highlighting achievements, risks, and future work.
Follow Agile standard for development.
Bring best practices, standards, and innovative ideas for architecture and design.
Deploy data ingestion pipelines into dev, pre, and production environments.
Perform unit, integration, functional, and non‑functional testing.
Base Salary Range $100,000 – $130,000 per annum
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, sick leave, holidays.
Legal & financial assistance: legal assistance, 401(k) plan, performance bonus, college fund, student loan refinancing.
Qualifications BACHELOR OF COMPUTER SCIENCE
Seniority Level Mid‑Senior level
Employment Type Full‑time
Job Function Business Development and Sales
Industries IT Services and IT Consulting
#J-18808-Ljbffr
4‑8 years hands‑on experience writing Teradata.
Experience with Teradata Utilities (BTEQ, Fast Load, Multi Load).
Extensive experience developing complex SQL code using Teradata stored procedures, macros, etc.
Strong Unix shell scripting skills.
Ability to create design documents and mapping documents.
Design and document development standards.
Knowledge of ETL and data‑warehouse concepts.
Knowledge of SQL Server and Autosys.
Roles & Responsibilities
Collaborate with stakeholders to understand current processes.
Collaborate with business to convert requirements into technical specifications.
Develop Teradata code meeting 100 % of technical specifications and business requirements.
Analyze, design, code, and test highly complex ETL processes for data warehouses and/or operational data stores.
Understand design for ETL applications, including data sources, targets, definitions, relationships, and business rules.
Work closely with technical leads, analysts, data modelers, and other developers to understand project requirements and contribute to solutions.
Provide post‑go‑live and application maintenance support.
Provide technical expertise on database design, data modeling, data warehousing, and data integration.
Create solutions for large and complex data‑driven applications.
Reconciliation and test case creation for developed solutions.
Design, develop, and support application solutions leveraging Teradata and its tools/Utilities.
Prepare test cases for unit testing, SIT, regression.
Take ownership and deliver independently; report to stakeholders highlighting achievements, risks, and future work.
Follow Agile standard for development.
Bring best practices, standards, and innovative ideas for architecture and design.
Deploy data ingestion pipelines into dev, pre, and production environments.
Perform unit, integration, functional, and non‑functional testing.
Base Salary Range $100,000 – $130,000 per annum
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, sick leave, holidays.
Legal & financial assistance: legal assistance, 401(k) plan, performance bonus, college fund, student loan refinancing.
Qualifications BACHELOR OF COMPUTER SCIENCE
Seniority Level Mid‑Senior level
Employment Type Full‑time
Job Function Business Development and Sales
Industries IT Services and IT Consulting
#J-18808-Ljbffr