ETL Developer @SMX Services and Consulting, Inc.
Data and Analytics
Salary unspecified
Remote Location
Employment Type full-time
Posted 1mth ago

[Hiring] ETL Developer @SMX Services and Consulting, Inc.

1mth ago - SMX Services and Consulting, Inc. is hiring a remote ETL Developer. πŸ’Έ Salary: unspecified πŸ“Location: AST (UTC-9)

Role Description

We are seeking an experienced ETL Developer with strong expertise in cloud (CPI-PC or 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.

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

Requirements

  • 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:00 AM AST (Puerto Rico Time)

Languages

  • Fully bilingual (English/Spanish)

Contract Type

  • 6 Months (Fully remote Job)
Before You Apply
️
remote Be aware of the location restriction for this remote position: AST (UTC-9)
β€Ό Beware of scams! When applying for jobs, you should NEVER have to pay anything. Learn more.
ETL Developer @SMX Services and Consulting, Inc.
Data and Analytics
Salary unspecified
Remote Location
Employment Type full-time
Posted 1mth ago
Apply for this position
Did not apply βœ“
Applied βœ“
Sent Follow-Up βœ“
Interview Scheduled βœ“
Interview Completed βœ“
Offer Accepted βœ“
Offer Declined βœ“
Application Denied βœ“
Unlock 140,000+ Remote Jobs
️
remote Be aware of the location restriction for this remote position: AST (UTC-9)
β€Ό Beware of scams! When applying for jobs, you should NEVER have to pay anything. Learn more.
Apply for this position
Did not apply βœ“
Applied βœ“
Sent Follow-Up βœ“
Interview Scheduled βœ“
Interview Completed βœ“
Offer Accepted βœ“
Offer Declined βœ“
Application Denied βœ“
Unlock 140,000+ Remote Jobs
Γ—

Apply to the best remote jobs
before everyone else

Access 140,000+ vetted remote jobs and get daily alerts.

4.9 β˜…β˜…β˜…β˜…β˜… from 500+ reviews
Unlock All Jobs Now

Maybe later