We are seeking an experienced Senior Data Vault Developer with strong expertise in Snowflake and Data Vault 2.0 to design, develop, and maintain scalable and reliable cloud data warehouse solutions. The ideal candidate will have hands-on experience with Snowflake, SQL, DBT, ETL/ELT, Data Vault modeling, and cloud platforms.
The candidate will be responsible for building data pipelines, developing Data Vault models, optimizing Snowflake environments, supporting data migration initiatives, and ensuring data quality, governance, and security across the data ecosystem.
Experience :6 + Years
Location: ALL CGI (Bangalore, Hyderabad, Chennai, Pune, Mumbai)
Your future duties and responsibilities
- Design, develop, and maintain scalable data pipelines using Snowflake, DBT, and cloud services.
- Develop and maintain Data Vault 2.0 models using Hubs, Links, and Satellites.
- Design data warehouse schemas and perform Snowflake performance tuning and optimization.
- Build and optimize ETL/ELT workflows for structured and semi-structured data.
- Support legacy data warehouse migration to Snowflake using Data Vault methodology.
- Automate data workflows using Snowflake Tasks, Streams, and Stored Procedures.
- Develop SQL-based transformations and data processing solutions.
- Collaborate with data engineers, architects, analysts, and business stakeholders to understand data requirements.
- Troubleshoot and optimize existing data pipelines and workflows for reliability and efficiency.
- Ensure data quality, governance, security, and compliance across the data platform.
- Participate in data migration, validation, testing, and deployment activities.
- Stay updated with new Snowflake features, Data Vault practices, and cloud data engineering technologies.
- Contribute to continuous improvement of data architecture and engineering processes.
Required qualifications to be successful in this role
- Strong hands-on experience with Snowflake Cloud Data Platform.
- Strong expertise in Data Vault 2.0, including Hubs, Links, and Satellites.
- Strong proficiency in SQL and data warehousing concepts.
- Experience with DBT and ETL/ELT tools such as Informatica, Talend, Matillion, or Fivetran.
- Experience developing and optimizing Snowflake data pipelines and data models.
- Hands-on experience with Data Vault-based data warehouse implementations.
- Experience with at least one major cloud platform: AWS, Azure, or GCP.
- Experience with data migration projects to Snowflake.
- Knowledge of Python, Scala, or Java for scripting and automation.
- Strong understanding of data quality, governance, security, and performance optimization.
- Strong troubleshooting and problem-solving skills.
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
Preferred Qualifications
- Exposure to Spark, Hadoop, or other Big Data technologies.
- Experience with Tableau, Power BI, or Looker.
- Knowledge of CI/CD, DevOps, and deployment practices.
- Experience working in large-scale cloud data warehouse migration projects.
Must-Have Skills
1. Snowflake
2. Data Vault 2.0
3. SQL
4. DBT / ETL-ELT
5. Data Warehouse Migration
Together, as owners, let’s turn meaningful insights into action.
Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…
You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.
Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.
You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.
That same commitment to fairness extends to how we use technology. To support our recruitment team, AI tools may be used to help assess applications though they never replace human judgement. All hiring decisions remain entirely in the hands of our recruitment professionals.
Come join our team—one of the largest IT and business consulting services firms in the world.
