Description

Job Duties

Gather business requirements and perform analysis on present data management related applications, procedures and processes. Prepare High-level and Low-level design documents to translate the business requirements to technical specifications. Build extract / load / transform (ETL) process in the Snowflake Data Factory using DBT to manage and store data from internal and external sources. Design and build scalable data models using DBT, considering dimensional modeling best practices and business requirements. Develop complex data transformations and ETL processes within DBT to clean, enrich, and aggregate data from various sources. Optimize SQL queries within DBT to improve data processing speed and performance. Create custom DBT macros to automate data cleaning and validation processes, reducing manual effort and increasing data consistency. Collaborate with cross-functional teams to gather requirements and design DBT models that align with business needs. Work on Python script to automate the Data Processing. Work under supervision. Travel and/or relocation to unanticipated client sites throughout USA is required.

Education

Bachelor’s degree in Computer Science/ IT/IS/Engineering(any) or closely related field with Twelve (12) months of experience in the job offered or as an IT Consultant or Analyst or Programmer or Developer or related field.

Experience

Experience of Twelve (12) months in working with ETL and Python is required. Travel and/or relocation is required to unanticipated client sites within USA. International travel is not required. The frequency of travel is currently not known exactly but it could reach as high as 100% as it depends on the client and project requirement that cannot be currently anticipated. Employer provides Information technology services to various clients in USA and hence implementing projects will require such travel which could be as high as 100%

Key Skills

Education

Any Graduate