Snowflake Data Engineer

Company Description

DevoTrend IT is a global technology solutions provider leading the digitalization of private and public sectors. We deliver end-to-end digital transformation solutions and services, from ideation to deployment. Our offerings include IT & Software Consultancy Services, Resources Outsourcing Services, and Digital Transformation Consultancy, all aimed at driving innovative and productive experiences for our customers. With expertise in cloud, analytics, mobility, and various CRM/ERP platforms, we provide impactful and maintainable software solutions.

Role Description

This is a full-time hybrid role for a Snowflake Data Engineer and the locations are Pune, Mumbai, Chennai and Bangalore. The Snowflake Data Engineer will be responsible for designing, implementing, and managing data warehousing solutions on the Snowflake platform. Day-to-day tasks will include data modeling, building and managing ETL processes, and performing data analytics. The role requires close collaboration with cross-functional teams to ensure data integrity and optimal performance of the data infrastructure.

Qualifications

Build ETL (extract, transform, and loading) jobs using Fivetran and dbt for our internal projects and for customers that use various platforms like Azure, Salesforce, and AWS technologies

• Monitoring active ETL jobs in production.

• Build out data lineage artifacts to ensure all current and future systems are properly documented

• Assist with the build out design/mapping documentation to ensure development is clear and testable for QA and UAT purposes

• Assess current and future data transformation needs to recommend, develop, and train new data integration tool technologies

• Discover efficiencies with shared data processes and batch schedules to help ensure no redundancy and smooth operations

• Assist the Data Quality Analyst to implement checks and balances across all jobs to ensure data quality throughout the entire environment for current and future batch jobs.

• Hands-on experience in developing and implementing large-scale data warehouses, Business Intelligence and MDM solutions, including Data Lakes/Data Vaults.

SUPERVISORY RESPONSIBILITIES:

• This job has no supervisory responsibilities.

QUALIFICATIONS:

• Bachelor's Degree in Computer Science, Math, Software Engineering, Computer Engineering, or related field AND 6+ years experience in business analytics, data science, software development, data modeling or data engineering work

• 3-5 year’s experience with a strong proficiency with SQL query/development skills

• Develop ETL routines that manipulate and transfer large volumes of data and perform quality checks

• Hands-on experience with ETL tools (e.g Informatica, Talend, dbt, Azure Data Factory) • Experience working in the healthcare industry with PHI/PII

• Creative, lateral, and critical thinker

• Excellent communicator

• Well-developed interpersonal skills

• Good at prioritizing tasks and time management

• Ability to describe, create and implement new solutions

• Experience with related or complementary open source software platforms and languages (e.g. Java, Linux, Apache, Perl/Python/PHP, Chef)

• Knowledge / Hands-on experience with BI tools and reporting software (e.g. Cognos, Power BI, Tableau)

• • Big Data stack (e.g.Snowflake(Snowpark), SPARK, MapReduce, Hadoop, Sqoop, Pig, HBase, Hive, Flume)