Senior Snowflake Developer

Jobtailor; Hyderabad; On-site; INR 1,200,000 - 2,200,000; Full time

Job summary

Jobtailor seeks an experienced ETL & Data Integration Specialist to design, develop, and maintain robust data pipelines across cloud platforms, ensuring governance, security, and regulatory compliance.

You will build end-to-end ETL workflows into Snowflake, use AWS/Azure tools, and mentor junior developers while collaborating with MI/Reporting teams to align outputs with downstream needs.

Qualifications

• Hands-on experience with enterprise ETL tools: Ab Initio, Matillion, DataStage.
• Advanced SQL with performance tuning and query optimization.
• Snowflake data warehouse experience and cloud data architecture.
• Data governance, lineage, and security awareness across pipelines.
• Control-M scheduling with reliable orchestration.

Responsibilities

• Design, develop, and maintain scalable ETL solutions for enterprise MIS, reporting, analytics, and regulatory needs.
• End-to-end ETL design and implementation with high-quality, reconciled pipelines.
• Develop and operate ETL in AWS/Azure cloud environments.
• Leverage cloud-native storage/compute for performance and cost efficiency.
• Mentor junior ETL developers and align outputs with MI/reporting teams.

Skills

ETL design

Advanced SQL

Data modeling

Data governance

End-to-end dataflows

Tools

Ab Initio

Matillion

DataStage

Control-M

Snowflake

Power BI

AWS

Azure

Job description

Responsibilities

• Design, develop, and maintain robust, scalable, and secure data integration solutions that support enterprise management information, reporting, analytics, and regulatory needs.
• Focus on end-to-end ETL design and implementation, ensuring high-quality, reconciled, and well-governed data pipelines across cloud-based data platforms.
• Design, develop, and enhance complex ETL workflows to acquire, transform, and load data from diverse source systems into enterprise data platforms such as Snowflake.
• Use enterprise ETL tools (AWS Glue, Ab Initio, Matillion, DataStage) to build scalable and reusable data pipelines.
• Implement robust data reconciliation, validation, and error-handling processes to ensure accuracy and completeness.
• Maintain strong data lineage and traceability across all ETL processes.
• Design and implement unified data models, including star schemas and dimensional models, to support reporting and analytics.
• Optimize data structures and ETL logic to improve performance, scalability, and cost efficiency in cloud data environments.
• Partner with reporting and analytics teams to ensure ETL outputs align with downstream consumption needs.
• Develop and operate ETL solutions within cloud environments (AWS and Azure).
• Leverage cloud-native storage and compute capabilities while ensuring performance and reliability.
• Use Control-M to schedule, orchestrate, and monitor ETL jobs and dependencies.
• Apply data governance, security, and access control standards within ETL design and execution.
• Maintain metadata, documentation, and operational run books for all ETL assets.
• Support audit, regulatory, and compliance requirements through repeatable and well-documented data pipelines.
• Ensure audit trails and reconciliation controls are embedded within ETL processes.
• Translate business and reporting requirements into detailed ETL technical designs.
• Work closely with data designers, MI/reporting teams, and platform engineers.
• Support production deployments.
• Mentor junior ETL developers.

Requirements

• Strong hands‑on experience with ETL tools such as Ab Initio, Matillion, DataStage (or equivalent enterprise ETL platforms).
• Advanced SQL skills with performance tuning experience.
• Experience working with Snowflake as an enterprise data warehouse.
• Solid grasp of data modeling concepts, including star schema and dimensional modeling.
• Experience with job scheduling and orchestration using Control‑M.
• Familiarity with cloud platforms (AWS and/or Azure) for data solutions.
• Knowledge of data governance, metadata management, and data security standards.
• Ability to design and detail out end‑to‑end data flows ensuring lineage.
• Experience embedding data quality and reconciliation controls in ETL pipelines.
• Experience in financial services, risk, regulatory, or management reporting environments (preferred).
• Familiarity with data cataloging tools and data quality frameworks (preferred).
• Experience supporting reporting tools such as Power BI from a data producer perspective (preferred).
• Strong analytical and problem‑solving skills with high attention to detail.