Teradata Engineer

• Provide day-to-day production support for Teradata-based applications and data warehouse processes.

• Investigate and resolve production incidents, data issues, failed batch jobs, and performance problems.
• Develop, analyze, troubleshoot, and optimize complex SQL queries in Teradata.
• Monitor and support scheduled jobs using ESP scheduling tools.
• Troubleshoot and support ETL workflows developed with IBM DataStage.
• Use Linux command-line tools to review logs, execute scripts, validate files, and investigate failures.
• Perform root-cause analysis and document corrective and preventive actions.
• Coordinate with development, infrastructure, operations, and business teams to resolve production issues.
• Support application releases, deployments, job restarts, and production validations.
• Review or troubleshoot mainframe processes, scripts, or job dependencies when applicable.
• Maintain technical documentation, operational procedures, and support runbooks.
• Participate in either individual or group onboarding, depending on project needs.

Requirements

• 3–5 years of experience in data warehousing, ETL development, application support, or production support.
• Strong hands-on experience with Teradata.
• Strong SQL development and troubleshooting skills.
• Experience supporting or developing ETL processes using IBM DataStage.
• Experience with ESP scheduling or similar enterprise workload scheduling tools.
• Hands-on experience using the Linux/Unix command line.
• Previous experience providing production or application support.
• Strong troubleshooting, analytical, and problem-solving skills.
• Ability to work during U.S. daytime business hours.
• Availability to remain on the engagement through at least year-end, with the possibility of extension.
• Flexibility to onboard individually or as part of a larger group.
• Experience working with mainframe environments.
• Knowledge of JCL, COBOL, DB2, batch processing, or mainframe job monitoring.
• Experience supporting enterprise data warehouse or banking/financial-services applications.
• Familiarity with incident management, root-cause analysis, change management, and production release processes.
• Experience with Teradata utilities such as BTEQ, TPT, FastLoad, MultiLoad, or FastExport.