Senior ETL Lead: IICS, Snowflake & SQL | Hybrid

TiltEdge Solutions LLC; Plainsboro Township (NJ); Hybrid; USD 120,000 - 180,000; Full time

Job summary

TiltEdge Solutions LLC is seeking an experienced ETL Lead to guide data integration initiatives using Informatica IICS, Snowflake, and SQL. You will lead a hands-on team while collaborating with business stakeholders to deliver scalable ETL solutions.

The role emphasizes technical leadership, performance optimization, and best practices in data pipelines. Hybrid work in Plainsboro, NJ is available, with onsite collaboration and production support responsibilities.

Qualifications

• 10+ years of experience in ETL/data integration and data warehousing.
• Strong hands-on experience with Informatica IICS.
• Strong experience with Snowflake, including data loading, transformation, performance tuning, and optimization.
• Advanced SQL skills with experience working with complex queries and large datasets.
• Proven experience leading ETL development teams or serving as a technical lead.
• Strong understanding of data warehouse concepts, ETL/ELT methodologies, dimensional modeling, and data integration patterns.
• Experience troubleshooting and optimizing ETL workflows and SQL queries.
• Strong analytical, problem-solving, and communication skills.
• Ability to work effectively with both technical and business stakeholders.

Responsibilities

• Lead the design, development, and implementation of scalable ETL/data integration solutions using Informatica IICS.
• Develop and optimize complex ETL workflows, mappings, tasks, and integrations.
• Design and implement data pipelines and data transformation processes in Snowflake.
• Write, optimize, and troubleshoot complex SQL queries, stored procedures, and data transformations.
• Lead ETL developers and provide technical guidance, code reviews, and best practices.
• Work with business analysts, data architects, and downstream application teams to understand data requirements.
• Perform data profiling, validation, reconciliation, and troubleshooting to ensure data quality and accuracy.
• Optimize ETL processes and Snowflake workloads for performance and scalability.
• Monitor production data pipelines, investigate failures, and drive timely resolution of issues.
• Establish and enforce ETL development standards, coding practices, and documentation.
• Participate in architecture and design discussions for data integration and warehouse solutions.
• Support deployment, release management, and production implementation activities.
• Mentor team members and help drive continuous improvement across ETL development processes.

Skills

Informatica IICS

Snowflake

SQL

ETL/ELT

Data warehousing

Leadership

Tools

Git

CI/CD pipelines

Job description

TiltEdge Solutions LLC is seeking an experienced ETL Lead to guide data integration initiatives using Informatica IICS, Snowflake, and SQL. You will lead a hands-on team while collaborating with business stakeholders to deliver scalable ETL solutions.

The role emphasizes technical leadership, performance optimization, and best practices in data pipelines. Hybrid work in Plainsboro, NJ is available, with onsite collaboration and production support responsibilities.