Role overview

Qualifications

Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
5+ years of experience in ETL/Data Engineering development.
Strong analytical, problem-solving, and troubleshooting skills.
Excellent communication and collaboration abilities.

Responsibilities

Design, develop, test, and deploy ETL workflows using Ab Initio, Informatica PowerCenter, or IBM DataStage.
Develop and optimize complex SQL queries, stored procedures, and database objects.
Build and maintain data integration processes for large-scale enterprise data warehouses.
Analyze source-to-target mappings and implement data transformation logic.

Key facts

Remote from: Mexico
Full time
Senior (5-10 years)
ETL Developer
English

Hard skills

Ab Initio (Software) SQL (Programming Language) Teradata BI Data Validation Data Quality Reconciliation

Other skills

Analytical Skills
Problem Solving
Troubleshooting (Problem Solving)
Communication
Collaboration

About the company

Turtle Trax S.A.

Travel & Tourism

Turtle Trax S.A. is a Costa Rican company that organizes rural tourism projects on the Pacific coast of Costa Rica’s Nicoya Paninsula. We create a unique experience for both international and national travellers by combining sea turtle conservation, hands-on volunteer work, community projects, and locally based tourism. Turtle Trax runs four sea turtle nesting beach conservation projects in partnership with PRETOMA, a Costa Rican NGO. The focus of the projects is to protect sea turtle nests both directly, with hatcheries, and indirectly, through community education and sustainable tourism.

Company details

Company typeStartup

IndustryTravel & Tourism

Company size2 - 10

Links

Website LinkedIn See all jobs

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

Key Responsibilities

Design, develop, test, and deploy ETL workflows using Ab Initio, Informatica PowerCenter, or IBM DataStage.
Develop and optimize complex SQL queries, stored procedures, and database objects.
Build and maintain data integration processes for large-scale enterprise data warehouses.
Work extensively with Teradata databases for data extraction, transformation, and loading activities.
Develop and maintain PySpark applications for big data processing and data transformation.
Analyze source-to-target mappings and implement data transformation logic.
Perform data validation, reconciliation, and quality checks to ensure data accuracy and consistency.
Troubleshoot ETL job failures, performance bottlenecks, and data issues.
Collaborate with business analysts, data architects, and stakeholders to gather and understand requirements.
Follow best practices for ETL development, coding standards, and documentation.
Participate in code reviews, testing, deployment, and production support activities.
Monitor ETL processes and ensure timely execution of data loads

Technical Skills

Strong experience with at least one ETL tool:
- Ab Initio (Preferred)
- Informatica PowerCenter
- IBM DataStage
Advanced SQL development and query optimization skills.
Hands-on experience with Teradata databases.
Strong knowledge of PySpark and distributed data processing concepts.
Experience with data warehousing concepts, dimensional modeling, and ETL methodologies.
Knowledge of Unix/Linux shell scripting.
Experience with data validation, data quality, and reconciliation processes.
Understanding of performance tuning and optimization techniques.

Requirements

Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
5+ years of experience in ETL/Data Engineering development.
Strong analytical, problem-solving, and troubleshooting skills.
Excellent communication and collaboration abilities.