Senior Engineer -Technology

Responsibilities and Qualifications

• Design and develop Teradata 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 Auto Sys, failure can be Linux scripting, Data Stage ETL, Teradata SQL.
• Part Loader which is ETL in Data Stage Roles & Responsibilities
• 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.
• Generic Managerial Skills, If any Team coordination and Stakeholders Management
• Bachelor/Master Computer Science or Software Engineering

Salary Range: $120,000 - $130,000 a year

Senior Engineer Technology
• Plano, TX, United States