An AI agent that applies to roles like this on employers' own sites. 25 applications free, no card needed.
Job Description
Position: Data Architect (DBT+ Snowflake)
Purpose of the Position: The Cloud Data Architect will lead the design and implementation of a modern cloud-based data platform by collaborating with stakeholders to migrate existing SQL Server SSIS workloads to Snowflake using dbt-based ELT frameworks.
This role focuses on defining scalable, reliable, and governed data transformation architecture aligned with business requirements. The role is expected to provide architectural oversight, guidance to delivery teams, and ensuring solution alignment across phases.
Location: Pune/Chennai/Bangalore/Nagpur
Type of Employment: Full-time
Key Result Areas and Activities:
- Define target architecture for SSIS to Snowflake + dbt migration
- Establish Pipeline Architecture and dbt-based transformation framework including staging, intermediate, and mart layers
- Guide and perform conversion of SSIS packages into dbt models using various AI tools (SnowConvert/Cortex Code AI) with human in loop & manual refactoring ensuring consistency and scalability
- Define best practices for naming convention,data modelling, performance optimisation, and cost efficiency on Snowflake
- Design data validation, reconciliation, end to end testing and parallel run strategies for migration assurance
- Provide architectural oversight to ensure adherence to standards and solution design
- Collaborate with stakeholders to align migration approach with business needs
- Support governance, documentation, and lineage approach for audit readiness
- Enable CI/CD practices and version control for dbt deployments
- Identify risks and recommend mitigation strategies during migration lifecycle
Skills
Data ValidationImplementationSnowflakeAiSqlIf a job posting appears fraudulent, asks for payment, contains misleading information, or violates our guidelines, please report it immediately. Our team will review it promptly, Jobaaj does not charge any fee from the applicants.
About Company
At InfoCepts, youll be challenged to think innovatively, while growing your own personal and professional skills designed with the future in mind. We have more than 1200 global professionals working on cutting edge technology solutions with a single mission – transforming our customers journey with data-driven modernization.
- InfoCepts has been recognized as Gartner Peer Insights trade mark Customers Choice for two consecutive years in 2020 and 2021 which recognizes our best-in-class services that help our customers approach any data analytics problem.
- We are certified by Great Place to Workregistered, India in 2021 and recognizes our high-trust and high-performance work culture, and great employee experience in the industry.
- Our award-winning reusable solutions approach is well recognized in the D&A industry and lets our associates leverage our collective and proven consultative expertise, accelerate solution delivery through automation, enable faster time to value with reusable toolkits – all while delivering exceptional customer experience.
Our success has been unique, and we are looking for professionals who are enthusiastic and passionate about data & analytics, delivering differentiated experiences, and solving real world problems for our global customers. This position works with the competency and delivery team to execute on the assigned responsibilities.
Similar Jobs
View allLooking for something similar?
New Data Science Analytics & Machine Learning roles in Bengaluru / Bangalore.
One email a day. Unsubscribe any time.

