Lead ETL Developer

Lead Etl DeveloperETL DeveloperKey Responsibilities:• Design, develop, and maintain ETL solutions using Informatica PowerCenter and DBT+ Snowflake to support enterprise data warehouse and regulatory reporting requirements.• Analyze business and technical requirements and translate them into scalable data integration solutions.• Perform data profiling, source system analysis, and business rule validation to support data integration initiatives.• Optimize ETL workflows for performance, reliability, and scalability through tuning and best practices.• Investigate and resolve production issues, ETL failures, data discrepancies, and performance bottlenecks through root cause analysis.• Conduct data validation, reconciliation, and quality checks to ensure accuracy, completeness, and consistency of data.• Perform impact analysis for source system changes, business rule modifications, and database enhancements.• Assess upstream and downstream dependencies across ETL processes, databases, reports, and consuming applications.• Support the full development lifecycle, including testing, UAT, deployment validation, monthly releases, and environment migrations.• Collaborate with business analysts, data analysts, architects, and other stakeholders while maintaining technical documentation and supporting audit/compliance requirements.Key Skills• Informatica PowerCenter• DBT with Snowflake• Oracle SQL & PL/SQL• Unix/Linux• ETL Design & Development• Data Warehousing• Data Integration• Data Profiling & Validation• Performance Tuning• Data Reconciliation• Impact Analysis• Release & Change Management• Data Governance & Data LineageAbout the companyAvance Consulting is a global leader in innovative talent solutions for diverse industries. Since 2007, we have been serving nearly a third of Fortune 500 companies and most of the top 100 technology companies worldwide.Our team of 700+ experts offers Engineering Services, Information Technology, Digital and Executive Search solutions from our offices in North America, UK, Europe and APAC.We understand the local markets and cultures and tailor our services to meet the needs of our clients. Our clients value our flexibility and agility, which enable us to deliver high-quality results at any scale across the globe.This allows us to work with numerous industries at varying scale across the globe while ensuring the excellent service standard that our clients have come to expect.At Avance you can learn new skills and technologies, have more advancement opportunities and career growth, being a part of our productive atmosphere, and a positive reinforcement culture.