Description

You will design, develop, and maintain ETL pipelines and integration connectors using Adeptia.

This role is remote.

Responsibilities

• Build and optimize ETL workflows to extract, transform, validate, and load data across internal and external systems.
• Implement REST/SOAP API integrations using OAuth, JWT, or API keys.
• Map source and destination fields, define transformation logic, and ensure data accuracy.
• Create process flows, sequence diagrams, and technical documentation for development and maintenance.
• Troubleshoot integration defects, identify root causes, and implement corrective actions.

Required Skills

• 5+ years of experience designing complex multi-step ETL pipelines with branching logic and error handling.
• Expertise with ETL platforms such as Adeptia (preferred), Azure Data Factory, or Informatica.
• Strong SQL skills and familiarity with JavaScript or an equivalent programming language.
• Familiarity with CI/CD pipelines, automated testing, and DevOps practices.
• Knowledge of secure coding practices for data movement and API consumption.
• Understanding of data modeling concepts, including schemas and data lineage.
• Experience working within Agile or SAFeAgile frameworks.

Preferred Skills

• Excellent analytical, problem-solving, and written communication skills.

Key Skills

Education

Bachelor's degree