Apply on Employer Site

Tata Consultancy Services · 18 hours ago

Solutions Specialist

Seattle, WA

Full-time

Onsite

Senior Level

$100K/yr - $145K/yr

5+ years exp

Tata Consultancy Services is a leading global IT services, consulting, and business solutions organization. They are seeking a Teradata Solution Lead responsible for designing scalable data warehousing solutions, optimizing ETL processes, and providing technical leadership to team members.

Business Information SystemsConsultingInformation TechnologyIT Management

H1B Sponsor Likely

Hiring Manager

Maria Rositta Mathew

Responsibilities

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

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

Provide technical leadership and guidance to team members, fostering a collaborative and supportive team culture

Lead the planning, solution design and implementation, ensuring alignment with program objectives and timeline

Engage 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

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

Qualification

TeradataETL developmentSQL proficiencyData warehousingAutosysData quality assurancePerformance tuningAnalytical abilitiesProblem-solvingCommunication skills

Required

Design Scalable Data Warehousing Solutions using Teradata

Develop and maintain normalized (3NF) and dimensional models

Optimize physical models and fine tune queries for performance

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

Developing and maintaining data warehouses, data lakes and data mart architecture

Optimizing ETL processes for performance, scalability and reliability

SQL proficiency (intermediate skill level minimum)

Ability to manage Teradata/SQL Server/ Oracle database migration including code migration, data loads and server retirements

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