Teradata Engineer
On-siteCarmen, Provincia de San José, Republic of Costa Rica or Carmen, Provincia de San José, Republic of Costa Rica
Job Summary
Provide day-to-day production support for Teradata-based applications and data warehouse processes by investigating and resolving production incidents, data issues, failed batch jobs, and performance problems. Develop, analyze, troubleshoot, and optimize complex SQL queries while monitoring scheduled jobs using ESP tools and ETL workflows built with IBM DataStage. Use Linux command-line tools to review logs, execute scripts, and validate files, then perform root-cause analysis and document corrective actions. Coordinate with development, infrastructure, and business teams to support application releases, deployments, and job restarts. Maintain technical documentation, operational procedures, and support runbooks. Participate in onboarding individually or as part of a group, with availability to remain through year-end and flexibility to work during U.S. daytime business hours.
Required Qualifications
- 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
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.