ETL Lead

Must Have Technical/Functional Skills:

• ETL Design and Architecture ,Performance optimization.

• Problem solving and debugging skills , Leadership and mentorship, ETL Tools (Informatics , IICS , Datastage).
• Database Core concepts - SQL,PL/SQL , Unix-Shell, Python, Communication and collaboration

Roles & Responsibilities:

ETL Architecture & Solution Design:

• Lead the design and implementation of scalable ETL solutions for enterprise data warehouse and data integration initiatives.
• Define ETL architecture, data movement strategies, framework standards, and best practices.
• Develop source-to-target mappings, technical design documents, and implementation plans.
• Ensure adherence to enterprise architecture, security, governance, and data quality standards.

ETL Development & Delivery:

• Design, develop, and maintain ETL processes using Informatica PowerCenter, IICS, and DataStage.
• Develop reusable ETL frameworks, utilities, and accelerators to improve delivery efficiency.
• Work closely with data architects, business analysts, and application teams to understand requirements and translate them into technical solutions.
• Lead end-to-end ETL project delivery including development, testing, deployment, and production support.

Performance Optimization:

• Analyze and tune ETL workflows, mappings, sessions, and SQL queries to meet SLAs.
• Optimize database performance through indexing strategies, partitioning, and query tuning.
• Identify bottlenecks in ETL pipelines and implement performance improvement measures.
• Drive efficient handling of large-volume data loads, incremental processing, and parallel execution strategies.

Problem Solving & Debugging

• Troubleshoot complex ETL failures, data quality issues, and production incidents.
• Perform root cause analysis and implement permanent corrective actions.
• Support critical production deployments and lead issue resolution during incident management.
• Establish monitoring, alerting, and recovery mechanisms for ETL processes.

Leadership & Team Management:

• Lead a team of ETL developers and provide technical direction across multiple projects.
• Conduct code reviews, design reviews, and ensure adherence to development standards.
• Mentor junior team members and facilitate technical skill development.
• Participate in effort estimation, sprint planning, resource allocation, and project tracking.
• Drive continuous improvement initiative s and adoption of industry best practices.

Database & Programming:

• Develop complex SQL queries, PL/SQL procedures, functions, packages, and performance tuning solutions.
• Create automation scripts using Shell Scripting and Python.
• Support data validation, reconciliation, and data quality framework implementations.

Communication & Collaboration:

• Partner with business stakeholders, architects, project managers, and offshore/onshore teams.
• Present technical solutions, risks, and recommendations to leadership and business users.
• Facilitate requirement discussions, design workshops, and technical reviews.
• Ensure effective communication across cross-functional teams and project stakeholders.