This job has closed.

Tata Consultancy Services · 22 hours ago

Senior Engineer -Technology

Plano, TX

Full-time

Onsite

Mid, Senior Level

$120K/yr - $130K/yr

Tata Consultancy Services is a leading global IT services and consulting company, and they are seeking a Senior Engineer in Technology. The role involves designing and developing ETL jobs and data pipelines, ensuring data quality, and optimizing performance of database jobs while collaborating with various stakeholders.

Business Information SystemsConsultingInformation TechnologyIT Management

H1B Sponsor Likely

Responsibilities

Design and develop Tera Data ETL jobs and data pipeline

Design, Develop and support enterprise data warehouse solutions leveraging Teradata and Teradata tools and utilities

Extracting data from various data sources, transforming, and loading it into target systems

Ensuring data quality, integrity, and consistency across different systems

Optimizing ETL processes for performance, scalability and reliability

SQL proficiency (intermediate skill level minimum)

Ability to manage Teradata SQL

Troubleshooting and resolving data integration issues

Solid skills with writing/translating SQL queries and SQL data validation

Performance tuning of SQL queries

Defining, managing, and monitoring job schedules, as well as troubleshooting issues within the Autosys environment

Understanding and implementing job schedules, dependencies, and workflows within Autosys

Analyzing and resolving issues with Autosys jobs and processes

Jobs failures troubleshoot in AutoSys, failure can be Linux scripting, DataStage ETL, Teradata SQL

Part Loader which is ETL in DataStage

Optimizing Database jobs for performance by collaborating with DBAs and implementing SQL coding and design changes within the job structure

Actively participated in troubleshooting and resolving issues related to data loading delays and database server outages, ensuring minimal disruption to data flow and system operations

Engaged in periodic reviews of job logs and performance metrics to identify trends, proactively addressing potential issues

Troubleshooting production issues through meticulous job log reviews, implementing necessary design changes via change management and adhering to the code promotion process

Contributed to the development and maintenance of documentation for troubleshooting procedures, best practices, and system configurations, facilitating knowledge sharing within the team and managing Change Requests

Resolving data issues arising from load delays or database server downtimes, with a focus on ensuring customer satisfaction

Collaborated with stakeholders to understand business requirements, providing valuable insights and recommendations for optimizing data processing workflows

Qualification

Teradata ETLSQL proficiencyAutosys managementData quality assurancePerformance tuningTeam coordinationStakeholders managementTroubleshooting

Required

Design and develop Tera Data ETL jobs and data pipeline

Design, Develop and support enterprise data warehouse solutions leveraging Teradata and Teradata tools and utilities

Extracting data from various data sources, transforming, and loading it into target systems

Ensuring data quality, integrity, and consistency across different systems

Optimizing ETL processes for performance, scalability and reliability

SQL proficiency (intermediate skill level minimum)

Ability to manage Teradata SQL

Troubleshooting and resolving data integration issues

Solid skills with writing/translating SQL queries and SQL data validation

Performance tuning of SQL queries

Defining, managing, and monitoring job schedules, as well as troubleshooting issues within the Autosys environment

Understanding and implementing job schedules, dependencies, and workflows within Autosys

Analyzing and resolving issues with Autosys jobs and processes

Jobs failures troubleshoot in AutoSys, failure can be Linux scripting, DataStage ETL, Teradata SQL

Part Loader which is ETL in DataStage

Bachelor/Master Computer Science or Software Engineering

BACHELOR OF COMPUTER SCIENCE

Company

Tata Consultancy Services

Glassdoor3.8

Tata Consultancy Services is a business solutions company that specializes on information technology services and consulting.

Founded in 1968

Mumbai, Maharashtra, IND

10001+ employees

http://www.tcs.com

H1B Sponsorship

Tata Consultancy Services has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (7880)

2024 (9690)

2023 (8537)

2022 (11159)

2021 (9813)

2020 (11984)