Data Engineer

Samta Infotech Pvt. Ltd. is a human-centric software solutions company based in Singapore and India. As a product-focused technology company, we specialize in transforming problem statements into impactful solutions, developing products from the ground up. Our expertise combines advanced software engineering, strategic consulting, and design thinking to help organizations reimagine their businesses for the digital era. We are committed to delivering innovative, human-centered solutions that address complex challenges while driving long term growth and value.

Role Summary:

Key Responsibilities:

Designing and implementing data architecture:

Data pipeline development:

Performance optimization and tuning:

Data security and compliance:

Collaborating with stakeholders:

Job Specification

Educational Qualification

Professional certification of Databricks or equivalent certification is highly preferred.

Experience:

Technical Skills:

• 1+ year of experience to Design and develop efficient and scalable data models in Snowflake/Databricks to support our organization's data analytics and reporting needs.

• Experience working on platform transformation projects migrating data from multiple source sources to Snowflake/Databricks.

• Working experience in migrating from on premise and other cloud databases to Snowflake/Databricks.

• Design and implement database objects such as tables, views, schemas, and stored procedures in Snowflake/Databricks to organize and manage data effectively.

• Understand data pipelines and ETL processes to extract, transform, and load data from various sources into Snowflake/Databricks using tools such as Snowflake/Databricks's native features, Informatica, Talend, or other ETL tools.

• Strong understanding of data modelling concepts and techniques, including relational and dimensional modelling principles.

• Optimize data models, queries, and data pipelines for performance and efficiency, including partitioning strategies, indexing, query optimization, and data compression techniques.

• Proficiency in SQL and experience with Snowflake/Databricks's SQL dialect for querying and manipulating data.

• Monitor and maintain Snowflake/Databricks database performance, availability, and reliability, including proactive monitoring, troubleshooting, and capacity planning.

• Collaborate with data engineers, data analysts, and business stakeholders to understand data requirements, define data models, and deliver data solutions that meet business needs.

• Document data models, database designs, ETL processes, and data governance policies to ensure clear understanding and maintainability of data solutions.

• Experience with performance tuning and optimization techniques for Snowflake/Databricks databases and data pipelines.

• Provide technical support and training to users.

Soft Skills:

• Excellent problem-solving skills and the ability to work in a collaborative team environment.

• Being a start-up, ability to work independently.

•Proficient in English with effective communication abilities essential for successful teamwork.