Tata Consultancy Services
Teradata ETL Developer
– Tata Consultancy Services
Base Salary : $100,000 - $130,000 per annum
Must Have Technical/Functional Skills
4-8 years hands‑on experience writing Teradata code.
Experience with Teradata Utilities (BTEQ, Fast Load, Multi Load).
Extensive experience developing complex SQL code using Teradata stored procedures, macros, etc.
Proficiency in Unix Shell scripting.
Ability to create design documents, mapping documents, and design development standards.
Knowledge of ETL and Data Warehouse concepts.
Knowledge of SQL Server and Autosys.
Roles & Responsibilities
Collaborate with stakeholders to understand current processes.
Translate business requirements into technical requirements.
Develop Teradata code meeting 100% of technical specifications and business requirements according to design patterns.
Analyze, design, code, and test highly complex ETL processes for data warehouses and/or operational data stores.
Design 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.
Reconcile and test developed solutions.
Design, develop, and support application solutions leveraging Teradata and related tools.
Prepare test cases for unit testing, SIT, regression.
Take ownership and deliver independently; report to stakeholders on achievements, risks, and future work.
Follow Agile standards for requested proposal development.
Bring best practices, standards, and innovative architecture ideas.
Deploy data ingestion pipelines into dev, pre, and production environments.
Conduct unit, integration, functional, and non‑functional testing.
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, 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
– Tata Consultancy Services
Base Salary : $100,000 - $130,000 per annum
Must Have Technical/Functional Skills
4-8 years hands‑on experience writing Teradata code.
Experience with Teradata Utilities (BTEQ, Fast Load, Multi Load).
Extensive experience developing complex SQL code using Teradata stored procedures, macros, etc.
Proficiency in Unix Shell scripting.
Ability to create design documents, mapping documents, and design development standards.
Knowledge of ETL and Data Warehouse concepts.
Knowledge of SQL Server and Autosys.
Roles & Responsibilities
Collaborate with stakeholders to understand current processes.
Translate business requirements into technical requirements.
Develop Teradata code meeting 100% of technical specifications and business requirements according to design patterns.
Analyze, design, code, and test highly complex ETL processes for data warehouses and/or operational data stores.
Design 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.
Reconcile and test developed solutions.
Design, develop, and support application solutions leveraging Teradata and related tools.
Prepare test cases for unit testing, SIT, regression.
Take ownership and deliver independently; report to stakeholders on achievements, risks, and future work.
Follow Agile standards for requested proposal development.
Bring best practices, standards, and innovative architecture ideas.
Deploy data ingestion pipelines into dev, pre, and production environments.
Conduct unit, integration, functional, and non‑functional testing.
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, 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