Contract role: ETL Lead Consultant at Secaucus, NJ (Remote) - Open for W2

ETL Lead Consultant

Secaucus, NJ (Remote)

Long Term Contract

Job Summary:

• We are seeking an experienced ETL Lead to design, develop, and manage enterprise-scale data integration solutions. The ideal candidate will lead ETL development initiatives, mentor team members, collaborate with business and data stakeholders, and ensure high-quality data movement across multiple source and target systems. The ETL Lead will play a critical role in driving data modernization, data warehousing, reporting, analytics, and cloud migration initiatives.

Responsibilities:

• Lead the design, development, testing, deployment, and support of ETL/ELT solutions.
• Analyze business requirements and translate them into scalable data integration architectures.
• Develop and optimize ETL workflows, mappings, transformations, and data pipelines.
• Ensure data quality, integrity, governance, and compliance across data platforms.
• Collaborate with business analysts, data architects, data engineers, and application teams.
• Perform root cause analysis and resolve complex production issues.
• Drive ETL performance tuning and optimization initiatives.
• Establish coding standards, best practices, and development guidelines.
• Lead code reviews and mentor junior ETL developers.
• Support data migration, modernization, and cloud transformation projects.
• Manage project deliverables, timelines, and stakeholder communications.
• Implement CI/CD and DevOps practices for ETL deployment and monitoring.
• Create and maintain technical documentation, data flow diagrams, and operational procedures.

Skills:

• Strong experience in ETL development and leadership.

Expertise in one or more ETL tools:

• Informatica PowerCenter / IICS
• Talend
• SSIS
• IBM DataStage
• Ab Initio
• AWS Glue
• Matillion
• Strong SQL and database programming skills.
• Experience with relational databases: Oracle, SQL Server, PostgreSQL, MySQL
• Knowledge of Data Warehousing and Dimensional Modeling concepts. Experience working with large-scale data integration and migration projects.
• Strong understanding of data quality and data governance principles.
• Experience with scheduling and orchestration tools such as Control-M, Airflow, or Autosys.
• Familiarity with source control tools like Git, Azure DevOps, or Bitbucket.
• Knowledge of cloud platforms: Azure, AWS , Google Cloud Platform