Snowflake Engineer

Job Title : Snowflake Engineer

Location : Bangalore

Experience : 6 to 9 years

Job Summary

We are seeking a skilled Snowflake Engineer with hands-on experience in designing and developing low to moderately complex data integration solutions. The ideal candidate will have strong expertise in RMDS (Snowflake, PostgreSQL) and ETL / ELT tools such as Informatica, Nifi, or Snaplogic. Experience with cloud platforms, particularly AWS services (IAM, EC2, S3, Lambda, RDS), and familiarity with data streaming tools like Kafka is essential.

Roles And Responsibilities

• Design, develop, and implement low to moderately complex data integration solutions using ETL / ELT tools such as Informatica, Nifi, or Snaplogic.
• Work with RMDS platforms like Snowflake and PostgreSQL to manage, process, and transform data efficiently.
• Collaborate with cross-functional teams to understand business requirements and translate them into technical data solutions.
• Develop and maintain data pipelines, ensuring data quality, integrity, and accuracy.
• Utilize cloud services (AWS – IAM, EC2, S3, Lambda, RDS) to design scalable and secure data workflows.
• Implement data streaming solutions using tools like Kafka to support real-time data processing needs.
• Support data modeling and database design activities, including RDBMS (Oracle, SQL Server) and non-RDBMS (Graph, NoSQL, Time-series) systems.
• Apply Data Warehousing concepts and best practices to ensure efficient storage and retrieval of large datasets.
• Write scripts and automation using programming languages such as Java, Python, and JSON for data manipulation and processing.
• Troubleshoot, monitor, and optimize ETL processes to improve performance and reduce errors.
• Document technical specifications, processes, and workflows to support knowledge sharing and operational continuity.

Years Of Experience

6 to 9 years of relevant experience

Educational Qualification

Certifications (Optional But Preferred)

Must-Have Skills

Nice-to-Have Skills

About SMC Squared

At SMC Squared, people are the foundation of our success. We help leading US and multinational companies accelerate digital transformation by building and managing Global Capability Centres with fully integrated, strategically aligned, and valued teams. Our people-first approach creates opportunities for talented professionals to grow, contribute, and thrive, while enabling organizations to scale intelligently.

As part of Hexaware Technologies—a global leader in IT, BPO, and consulting—we deliver greater value through enhanced digital capabilities, automation platforms, and a shared commitment to people-centric transformation. Join us and be part of a purpose-driven company where your ideas matter, your work makes a global impact, and your career can reach new heights.

Join us and be part of a purpose-driven company where your ideas matter, your work has a global impact, and your career can reach new heights.

EEO Statement

SMC Squared is an equal opportunity employer. We encourage applications from candidates of all backgrounds and experiences.

If you are a creative individual with a passion for design and a drive to contribute to impactful projects, we invite you to apply for this exciting opportunity.

Skills Required

Java, S3, Rds, Snaplogic, Postgresql, Kafka, Json, Informatica, ELT, Lambda, Ec2, snowflake , Iam, Python, Etl, Aws