Teradata Engineer

Job Information

• Job Opening ID OTSI_2633_JOB
• Date Opened 08/17/2026
• Industry Banking, Financial Service & Insurance
• Job Type Data Engineer
• City Carmen
• State/Province Provincia de San José
• Country Costa Rica
• Zip/Postal Code 10101

About Us

OTSI is a global technology partner providing enterprise IT consulting, digital solutions, and managed services. We help organizations modernize complex technology landscapes, harness the power of data, and build scalable AI-led ecosystems to accelerate innovation and business growth. With over 26 years of experience, we consistently turn complex challenges into success stories through our strong technical capabilities and deep industry knowledge. Our global team of 1,800+ professionals, spread across 6 countries, delivers cutting-edge solutions for customers across Banking, Financial Services, Insurance, Transportation & Logistics, Energy & Utilities, Healthcare & Life Sciences, Government, Hi-Tech, Telecom & Media, Manufacturing, and more.

Our focused technology areas:

• AI/ML (Agentic AI Solutions, GenAI/LLMs, Natural Language Processing, Intelligent Processing, Physical Intelligence)
• Data & Analytics (Data Architecture, Data Engineering, Data Migration, Data Modernization, Big Data, Analytics and BI)
• Cloud (Cloud Computing, Cloud Migration, Cloud-Native Architecture, Hybrid and Multi-Cloud)
• Digital Engineering (Application Modernization, Product Engineering, Platform Engineering, DevSecOps)
• Quality Engineering (Manual Testing, Non-functional testing, Test Automation, Digital Testing)
• Enterprise Platforms (SAP, Microsoft, Oracle, etc.)

Our focused industries and target segments:

• Banking, Financial Services, & Insurance
• Manufacturing, Transportation, & Logistics
• Energy & Utilities
• Telecom & Media
• Healthcare & Life-sciences
• Government & Public Sector (FED, SLED, & Partners)
• Hi-Tech

Job Description

• 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.