Lead ETL Engineer - Powercenter / IICS and SQL

Overview

Remote
Depends on Experience
Contract - W2
Contract - 6 Month(s)

Skills

Informatica PowerCenter
IICS
SQL

Job Details

Role: Lead ETL Engineer (Informatica PowerCenter / IICS and SQL)

Duration: 6 months

Location: 100% remote

Bill Rate: 95/hr

Customer: Green Dot Bank

Job Summary:

We are seeking a Lead ETL Engineer with deep expertise in Informatica PowerCenter / IICS, advanced SQL, and strong experience in building and managing enterprise-grade ETL pipelines. The ideal candidate will demonstrate hands-on technical excellence, strong leadership, and a collaborative approach to leading offshore/onsite teams and managing key stakeholders.

Key Responsibilities:

  • Design, develop, and optimize ETL pipelines using Informatica PowerCenter/IICS.
  • Write and tune complex SQL queries, stored procedures, and database objects.
  • Ensure high-performance data integration across multi-source systems.
  • Implement best practices in error handling, logging, and audit frameworks.
  • Lead and mentor onsite/offshore development teams.
  • Communicate with stakeholders, gather requirements, and provide technical leadership.
  • Participate in performance tuning, troubleshooting, and root cause analysis of ETL jobs.
  • Drive continuous improvement in ETL processes and data pipeline automation.

Required Skills:

Skill Area

Key Focus

Informatica (PowerCenter/IICS)

Mappings, workflows, performance tuning, real-time integration

SQL & Databases

Advanced SQL, stored procedures, performance optimization, cloud warehousing

ETL & Integration

Multi-source pipelines, error handling, auditing

Leadership

Team mentoring, stakeholder engagement, offshore team coordination

Nice-to-Have Skills:

Area

Tools/Experience

Scripting & Automation

Shell, PowerShell, CI/CD pipelines, job schedulers (e.g., Control-M, Autosys)

Troubleshooting & Support

Production support, debugging, cost-benefit analysis

Cloud & Big Data

Snowflake, Azure Synapse, Hive, Sqoop, Kafka/streaming platforms

Preferred Qualifications:

  • Bachelor s or Master s degree in Computer Science, Engineering, or related field.
  • 7+ years of hands-on ETL development experience.
  • 2+ years in a lead or architect role managing ETL teams.
  • Experience working in Agile environments.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.