Sap Careers in -bangalore-pune ∙ Page 1

1 Remote & work from home jobs online

Hybrid Data Solutions Architect

Spaulding ridge ·  Jaipur, Bangalore, Pune, United States Of America · Hybrid

  • Office in Jaipur, Bangalore, Pune
Apply Now

Spaulding Ridge is an advisory and IT implementation firm. We help global organizations get financial clarity into the complex, daily sales, and operational decisions that impact profitable revenue generations, efficient operational performance, and reliable financial management.

At Spaulding Ridge, we believe all business is personal. Core to our values is our relationships with our clients, our business partners, our team, and the global community. Our employees dedicate their time to helping our clients transform their business, from strategy through implementation and business transformation. 

What You Will Do and Learn

We are seeking a highly experienced and motivated ETL Architect to lead the design, development, and optimization of scalable ETL pipelines and modern data integration solutions. The ideal candidate will possess deep expertise in ETL architecture, data modeling, and hands-on experience with industry-leading tools such as Fivetran, Informatica, Azure Data Factory (ADF), and Snowflake. Strong communication skills and a proven track record in team leadership and cross-functional collaboration are essential for this role. 

Key Responsibilities: 

  • Architect, design, and implement robust ETL solutions, ensuring scalability, reliability, and performance. 
  • Lead the development of complex ETL pipelines that extract, transform, and load data from multiple sources into data warehouses or data lakes. 
  • Ensure efficient integration of systems using tools such as Fivetran, Informatica, ADF, and Snowflake. 
  • Set up and configure ETL environments, including choosing appropriate tools, platforms, and technologies. 
  • Define and implement standards for ETL environments across development, testing, and production stages. 
  • Ensure all required software, libraries, and configurations are in place to support ETL jobs. 
  • Establish ETL monitoring processes and alerting mechanisms for operational support. 
  • Build and manage data pipelines using tools like Fivetran, Informatica, Azure Data Factory, and Snowflake. 
  • Design and implement CI/CD pipelines for automated testing, deployment, and monitoring of ETL processes. 
  • Collaborate with DevOps and engineering teams to integrate ETL pipelines with version control (Git), CI/CD tools (Jenkins, GitLab, Azure DevOps), and testing frameworks. 
  • Ensure seamless integration and deployment of ETL jobs across environments (e.g., dev, test, prod). 
  • Design and implement solutions for managing SCD types 1, 2, and 3 in the data warehouse. 
  • Ensure that data integrity and historical data tracking are maintained across changing datasets. 
  • Design efficient data models and data warehousing solutions optimized for Snowflake. 
  • Ensure data quality, consistency, and reliability through rigorous testing and monitoring. 
  • Provide technical leadership and mentorship to junior engineers. 
  • Coordinate with project managers and stakeholders on project scope, timelines, and deliverables. 

 

Required Skills & Qualifications: 

  • 8–10 years of experience in ETL development and architecture. 
  • Extensive experience in designing and architecting ETL pipelines using tools such as Fivetran, Informatica, ADF, and Snowflake. 
  • Proven expertise in setting up and managing ETL environments. 
  • Strong hands-on experience with CI/CD pipelines for automated deployment, testing, and monitoring of ETL processes. 
  • Experience working with APIs, unstructured data, and JSON, Parquet, Flat files etc. 
  • Deep understanding of Slowly Changing Dimensions (SCD), including implementation of SCD Type 1, Type 2, and Type 3 in the data warehouse. 
  • Expertise in data modeling (e.g., dimensional, normalized models, star/snowflake schemas). 
  • Strong proficiency in SQL, with experience working on large-scale datasets and optimizing query performance in Snowflake or other relational databases. 
  • Familiarity with cloud data platforms (e.g., Azure, AWS, GCP) and technologies like data lakes, data warehouses, and big data solutions. 
  • Ability to lead teams, mentor junior developers, and collaborate effectively with business stakeholders. 
  • Experience with data governance and data security practices. 
  • Strong problem-solving skills and ability to troubleshoot complex data and performance issues. 
  • Experience working with applications such as Oracle ERP / SAP / Microsoft ERP / Salesforce / NetSuite / etc.  
  • Good understanding of data within ERP & CRM. Functional expertise in areas like Finance / Procurement / HRMS / etc.   

 Preferred Qualifications: 

  • Experience with modern data stack tools (e.g., dbt, Airflow, Matillion). 
  • Understanding of data governance, privacy, and compliance frameworks. 
  • Experience working in Agile/Scrum environments.