Who are we? Indegene is a global consultancy at the forefront of driving innovation in the Pharmaceutical and Life Sciences industry, through combining medical and commercial expertise with innovative digital and AI technologies. We enable global healthcare organizations address complex challenges and drive better health and business outcomes by seamlessly integrating analytics, technology, operations, and medical expertise. Find out more at indegene.com Who are you? We are looking for experienced Snowflake engineers for * In-depth knowledge of Snowflake’s data warehousing capabilities. * Understanding of Snowflake’s virtual warehouse architecture and how to optimize performance and cost. * Proficiency in using Snowflake’s data sharing and integration features for seamless collaboration. * Implement data modeling techniques, including OLTP, OLAP, and Data Vault 2.0 methodologies. * Design, build, and maintain scalable and high-performance ETL/ELT pipelines using Snowflake on cloud platforms (AWS). * Develop and optimize complex SQL scripts, stored procedures, and data transformations. * Work closely with data analysts, architects, and business teams to understand requirements and deliver reliable data solutions. * Implement and maintain data models, dimensional modeling for data warehousing, data marts, and star/snowflake schemas to support reporting and analytics. * Integrate data from various sources including APIs, flat files, relational databases, and cloud services. * Ensure data quality, data governance, and compliance standards are met. * Monitor and troubleshoot performance issues, errors, and pipeline failures in Snowflake and associated tools. * Participate in code reviews, testing, and deployment of data solutions in development and production environments. Required knowledge: * Ability to write complex SQL queries, stored procedures, and user-defined functions. * Skills in optimizing SQL queries for performance and efficiency. * Experience with ETL/ELT tools and techniques, including Snowpipe, AWS Glue, Informatica cloud or similar tools for real-time and periodic data processing. * Proficiency in transforming data within Snowflake using SQL, with Python being a plus. * Strong understanding of data security, compliance and governance. * Experience with dbt for database object modeling and provisioning. * Experience in version control tools, in particular Azure DevOps. * Good documentation and coaching practice. EQUAL OPPORTUNITY Indegene is proud to be an Equal Employment Employer and is committed to the culture of Inclusion and Diversity. We do not discriminate on the basis of race, religion, sex, colour, age, national origin, pregnancy, sexual orientation, physical ability, or any other characteristics. All employment decisions, from hiring to separation, will be based on business requirements, the candidate’s merit and qualification. We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, national origin, gender identity, sexual orientation, disability status, protected veteran status, or any other characteristics.