← Serch more jobs

Technical Architect

Tata Consultancy Services • Plano, TX

Not Applicable Posted March 26, 2026 Job link

Thinking about this job

Responsibilities

Collaborate with stakeholders to understand the current process
Collaborate with business to convert the business requirement into Technical requirements.
Develop Teradata code meeting 100 percent of technical specifications and business requirements according to the established design patterns
Analyze, design, code, and test highly complex ETL processes, for data warehouses and/or operational data stores
Understand design for ETL application including data sources, data targets, data definitions, data relationships, and business rules
Work closely with technical leads, analysts, data modelers and other developers to understand project requirements and contribute to the project solution
Provide post go-live & 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 cases of developed solutions
Design, develop and support application solutions leveraging Teradata and Teradata Tools and Utilities
Prepare Test cases for Unit Testing/SIT/Regression
Should be able to take ownership and deliver independently Report out to stakeholders highlighting achievements, risks, and future work.
Follow the Agile standard for the development of the requested proposal.
Bring best practices, standards, and innovative ideas for architecture, and design.
Deployment of data ingestion pipelines into dev, pre, and production environments.
Unit testing, integration testing, functional, and non-functional testing.

Not Met Priorities

What still needs stronger evidence

Requirements

4-8 years hand on Experience on writing Teradata.
Experience in Teradata Utilities (BTEQ,Fast Load, Multi Load)
Extensive experience in developing complex SQL code using Teradata stored procedures, macros etc.
Should be good in Unix Shell scripting
Should be able to create Design documents , mapping documents
Design and document development standards
Should have knowledge on ETL and Data warehouse Concepts
Should have knowledge of SQL Server and Autosys.
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 cases of developed solutions
Deployment of data ingestion pipelines into dev, pre, and production environments.
Unit testing, integration testing, functional, and non-functional testing.

Preferred Skills

Should be good in Unix Shell scripting

Education

(Not required) – Qualifications: BACHELOR OF COMPUTER SCIENCE

Job Description
Must Have Technical/Functional Skills
4-8 years hand on Experience on writing Teradata.
Experience in Teradata Utilities (BTEQ,Fast Load, Multi Load)
Extensive experience in developing complex SQL code using Teradata stored procedures, macros etc.
Should be good in Unix Shell scripting
Should be able to create Design documents , mapping documents
Design and document development standards
Should have knowledge on ETL and Data warehouse Concepts
Should have knowledge of SQL Server and Autosys.
Roles & Responsibilities
Collaborate with stakeholders to understand the current process
Collaborate with business to convert the business requirement into Technical requirements.
Develop Teradata code meeting 100 percent of technical specifications and business requirements according to the established design patterns
Analyze, design, code, and test highly complex ETL processes, for data warehouses and/or operational data stores
Understand design for ETL application including data sources, data targets, data definitions, data relationships, and business rules
Work closely with technical leads, analysts, data modelers and other developers to understand project requirements and contribute to the project solution
Provide post go-live & 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 cases of developed solutions
Design, develop and support application solutions leveraging Teradata and Teradata Tools and Utilities
Prepare Test cases for Unit Testing/SIT/Regression
Should be able to take ownership and deliver independently Report out to stakeholders highlighting achievements, risks, and future work.
Follow the Agile standard for the development of the requested proposal.
Bring best practices, standards, and innovative ideas for architecture, and design.
Deployment of data ingestion pipelines into dev, pre, and production environments.
Unit testing, integration testing, functional, and non-functional testing.
Base Salary Range: $120,000 - $140,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, Time Off, Sick Leave & Holidays.
Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
Qualifications: BACHELOR OF COMPUTER SCIENCE