Job Description

:
The incumbent will be responsible for, but not limited to, the following key deliverables: - Design, develop, and maintain scalable data pipelines and ETL processes using AWS services and Snowflake. - Expertise in writing/handling SQL queries including complex Joins, analytical functions and subqueries - Expertise in Snowflake including Good Knowledge on Multi-Cluster Warehouses, Virtual Warehouses, Snowpipe, Snowflake Clone, Time Travel, Data Sharing and Credit Usage. - Should have hands on experience in AWS Services like Lambda, Step functions, Glue, S3 buckets. - Implement data models, data integration, and data migration solutions. - Solid understanding of nested json file handling & Flattening - Experience in Cloud migration projects is a plus. - Should have knowledge on Job Metadata and ETL Step Metadata Creation, Migration, Execution. - Healthcare Insurance domain knowledge is a Plus. - Experience in Value Based Care systems is an added advantage. - Good understanding of Population Health Management - Document and simulate complex issues. - Excellent understanding on different file formats (avro, parquet) and JSON - Knowledge on Python is a plus.
QUALIFICATION o Full time IT Engineering or equivalent degree (preferably in Computers ) EXPERIENCE o 6+ years as AWS, Snowflake, ETL Developer SKILLS AND COMPETENCIES o Design and Development: Design, develop, and maintain scalable data pipelines and ETL processes using AWS services and Snowflake. Implement data models, data integration, and data migration solutions. o Data Management: Manage and optimize Snowflake environments to ensure efficient performance and cost-effectiveness. Develop and implement data governance policies and procedures. o Collaboration: Work closely with data analysts, data scientists, and other stakeholders to understand data requirements and deliver solutions that meet business needs. Collaborate with DevOps teams to ensure seamless integration and deployment of data solutions. o Performance Optimization: Monitor and optimize the performance of data pipelines and Snowflake queries. Troubleshoot and resolve any issues related to data processing and storage. o Security and Compliance: Ensure data security and compliance with relevant regulations and standards. Implement and manage access controls and encryption for sensitive data. o Experience: Proven experience in developing and managing data solutions using AWS services (e.g., S3, Lambda, Redshift, Glue). Extensive experience with Snowflake, including cloud data warehousing concepts, performance tuning, and security. o Technical Skills: Proficiency in SQL and experience with data modeling. Familiarity with data integration tools and ETL processes. Experience with version control systems (e.g., Git) and CI/CD pipelines.
Skills:
Snowflake,Etl Testing,Aws Services,Json
About Company:
UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world's best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clients' organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact--touching billions of lives in the process.