Role overview

Qualifications

Bachelor's degree in computer science, Information Systems, or related field
3-5+ years of hands-on ETL development experience with Informatica PowerCenter
Strong experience with Data Masking Transformation
Strong SQL and database skills

Responsibilities

Design, develop, and deploy ETL workflows and mappings using Informatica PowerCenter
Analyze business requirements and translate them into technical ETL solutions
Optimize data integration processes for performance, scalability, and reliability
Monitor, troubleshoot, and resolve ETL job failures in production environments

Key facts

Remote from: Uruguay
Full time
Senior (5-10 years)
ETL Developer
Spanish, English

Hard skills

Xplenty (ETL Tools) Data Integration SQL (Programming Language) Data Masking Relational Databases Job/Batch Scheduling Data Governance Metadata Management Data Quality Debugging Amazon Web Services Microsoft Azure gRPC Informatica Cloud Python (Programming Language) Java (Programming Language) IBM Cognos TM1 Scrum (Software Development)

Other skills

Problem Solving
Communication
Collaboration

About the company

SMX Services & Consulting, Inc.

SMX Services & Consulting is an information technology outsourcing (ITO) provider with more than 20 years’ applied experience providing logical solutions to emerging enterprises, in a variety of industry verticals including technology, finance, banking, real estate, insurance, and retail. Based in Miami, Florida, SMX serves private, public and institutional clients, including some Fortune 500 companies, in more than 10 countries from regional offices in Houston, San Juan, Bogotá, and Caracas.

Company details

Company size201 - 500

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

About the Role:

We are seeking an experienced ETL Developer with strong expertise in cloud ( CPI-PC o IDMC). To design, develop, and maintain robust data integration solutions. This role will be responsible for extracting, transforming, and loading data from multiple sources into enterprise data warehouses and operational data stores, ensuring accuracy, scalability, and performance.

Key Responsibilities:

Design, develop, and deploy ETL workflows and mappings using Informatica PowerCenter.
Analyze business requirements and translate them into technical ETL solutions.
Optimize data integration processes for performance, scalability, and reliability.
Work with relational databases (Oracle, SQL Server, DB2, etc.) to extract and load data.
Perform data profiling, validation, and quality checks to ensure accuracy and consistency.
Monitor, troubleshoot, and resolve ETL job failures in production environments.
Collaborate with data architects, business analysts, and stakeholders to support reporting and analytics needs.
Document ETL processes, technical specifications, and data flow diagrams.
Ensure compliance with data governance, security, and best practices.

Qualifications:

Bachelor's degree in computer science, Information Systems, or related field (or equivalent experience).
3-5+ years of hands-on ETL development experience, with a focus on Informatica PowerCenter.
Strong experience with Data Masking Transformation
Strong SQL and database skills (query tuning, stored procedures, indexing).
Experience with data warehousing concepts (star schema, snowflake, slowly changing dimensions).
Familiarity with job scheduling tools (Control-M, Autosys, or similar).
Understanding of data governance, metadata management, and data quality principles.
Strong problem-solving and debugging skills.
Excellent communication and collaboration abilities.

Strong Preference:

Experience with cloud data platforms (AWS, Azure, GCP, Snowflake).
Knowledge of Informatica Cloud (IICS) or other ETL tools.
Familiarity with Python or shell scripting for automation and Java.

Additionally:

Knowledge of IBM Cognos.
Availability to handle cancellations and production deployments during working hours.
Exposure to Agile/Scrum environments.

Availability: Monday to Friday, 3:00 PM - 12:00AM AST (Puerto Rico Time)

Languages: Fully bilingual (English/Spanish)

Contract Type: 6 Months (Fully remote Job)

Apply once. Then go straight to the hiring manager.

After you apply, unlock the direct contact details of the people who actually make the call. A quick follow-up makes you 5x more likely to land an interview.