ETL Engineer (Informatica) - Data Warehouse Expert

Ethereum Technologies; Columbia (SC); In loco; USD 95.000 - 135.000; Tempo pieno

Descrizione del lavoro

Ethereum Technologies is seeking an experienced ETL Developer in the United States, Columbia, SC. You will build scalable data integration solutions, implement complex transformations, and optimize ETL workflows within an enterprise data warehouse environment.

The role requires strong Informatica expertise (PowerCenter and IICS), SQL/PLSQL, Unix/Linux scripting, and experience with scheduling tools like Control-M or Autosys. A Bachelor's degree is required, with a Master’s viewed as a plus.

Competenze

• 5–8 years of ETL development experience required.
• Minimum 3 years of hands-on Informatica PowerCenter experience.
• Strong SQL and PL/SQL proficiency expected.
• Experience with enterprise data warehouses and large datasets.
• Unix/Linux scripting and job scheduling experience.

Mansioni

• Develop and maintain ETL mappings, sessions, workflows, and reusable transformations.
• Build data integration solutions to process structured and unstructured data.
• Analyze source-to-target mapping documents and implement transformation logic.
• Optimize ETL workflows to improve processing time and system performance.
• Perform data reconciliation and troubleshoot data quality issues.
• Coordinate with DBAs and data architects.
• Monitor scheduled jobs and resolve production failures.
• Prepare technical documentation and support deployment activities.

Conoscenze

ETL development

SQL

PL/SQL

Data warehousing

Unix/Linux scripting

Job scheduling

Formazione

Bachelor's degree in Computer Science or related

Master's degree in a relevant technical field (advantage)

Strumenti

Informatica PowerCenter

Informatica Cloud (IICS)

Control-M

Autosys

Oracle

SQL Server

Descrizione del lavoro

Ethereum Technologies is seeking an experienced ETL Developer in the United States, Columbia, SC. You will build scalable data integration solutions, implement complex transformations, and optimize ETL workflows within an enterprise data warehouse environment.

The role requires strong Informatica expertise (PowerCenter and IICS), SQL/PLSQL, Unix/Linux scripting, and experience with scheduling tools like Control-M or Autosys. A Bachelor's degree is required, with a Master’s viewed as a plus.