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.