- Design, develop, and maintain scalable data pipelines and data warehouse solutions using Snowflake.
- Develop complex and optimized SQL queries for data transformation, extraction, and analysis.
- Build and maintain ETL/ELT pipelines for integrating data from multiple source systems.
- Design Snowflake databases, schemas, tables, views, stages, streams, and tasks.
- Develop efficient data transformation processes using Snowflake SQL and Stored Procedures.
- Implement incremental data loading and change-data-capture (CDC) strategies.
- Optimize Snowflake workloads for performance, scalability, and cost efficiency.
- Monitor data pipelines and troubleshoot data processing failures and performance issues.
- Perform data validation, reconciliation, and quality checks across source and target systems.
- Design, develop, and maintain scalable data pipelines and data warehouse solutions using Snowflake.
- Develop complex and optimized SQL queries for data transformation, extraction, and analysis.
- Build and maintain ETL/ELT pipelines for integrating data from multiple source systems.
- Design Snowflake databases, schemas, tables, views, stages, streams, and tasks.
- Develop efficient data transformation processes using Snowflake SQL and Stored Procedures.
- Implement incremental data loading and change-data-capture (CDC) strategies.
- Optimize Snowflake workloads for performance, scalability, and cost efficiency.
- Monitor data pipelines and troubleshoot data processing failures and performance issues.
- Perform data validation, reconciliation, and quality checks across source and target systems.
- 5+ years of experience in data engineering or a related field.
- Strong hands-on experience with Snowflake.
- Advanced SQL skills.
- Strong understanding of data warehousing concepts, including:
- Star and snowflake schemas
- Fact and dimension tables
- Slowly Changing Dimensions (SCD)
- Data modeling
- ETL/ELT
- Experience developing and managing data pipelines.
- Strong knowledge of Snowflake features such as:
- Streams
- Tasks
- Stages
- Snowpipe
- Time Travel
- Zero-Copy Cloning
- Dynamic Tables
- Stored Procedures
- Experience with cloud platforms such as AWS, Azure, or GCP.
- Experience with Git and CI/CD practices.
- Strong debugging and problem-solving skills.
- Experience working in Agile/Scrum environments
Skills Required
- 5+ years of experience in data engineering or related field
- Strong hands-on experience with Snowflake
- Advanced SQL skills
- Experience designing and managing ETL/ELT pipelines
- Strong understanding of data warehousing concepts (star/snowflake schemas, fact/dimension tables, SCD, data modeling)
- Experience with Snowflake features: Streams, Tasks, Stages, Snowpipe, Time Travel, Zero-Copy Cloning, Dynamic Tables
- Experience developing Snowflake Stored Procedures
- Experience implementing incremental loading and CDC strategies
- Experience with cloud platforms (AWS, Azure, or GCP)
- Experience with Git and CI/CD practices
- Strong debugging and problem-solving skills
- Experience working in Agile/Scrum environments
What We Do
Choosing a digital partner is about more than capabilities — it’s about collaboration and character. Unrealistic overhauls and off-the-shelf products ignore what matters most — your unique needs, culture, goals, and your legacy data and technology environments. At EXL, our collaboration is built on ongoing listening and learning to adapt our methodologies. We’re your business evolution partner—tailoring solutions that make the most of data to make better business decisions and drive more intelligence into your increasingly digital operations. Whether your goals are scaling the use of AI and digital, redesign operating models, or driving better and faster decisions, we’re here to partner with you to help you gain—and maintain—competitive advantage with efficient, sustainable models at scale. Our expertise in transformation, data science, and change management helps make your business more efficient and effective, improve customer relationships and enhance revenue growth. Instead of focusing on multi-year, resource- and time-intensive platform designs or migrations, we look deeper at your entire value chain to integrate strategies with impact. We use our specialization in analytics, digital interventions, and operations management—alongside deep industry expertise — to deliver solutions that help you outperform the competition. At EXL, it’s all about outcomes—your outcomes—and delivering success on your terms. Share your goals with us and together, we’ll optimize how you leverage data to drive your business forward. For more information, visit www.exlservice.com.
