Data Engineer - Snowflake DB

Role : Senior Data Engineer(Snowflake & DBT) Primary Skills : Skills : : 4 to 6 Years Location : Responsibilities : - Translate functional specifications and change requests into technical specifications. - Translate business requirement documents, functional specifications, and technical specifications into related coding. - Develop efficient code with unit testing and code documentation. - Ensure accuracy and integrity of data and applications through analysis, coding, documenting, testing, and problem-solving. - Set up the development environment and configure development tools. - Communicate project status with all project stakeholders. - Manage, monitor, and ensure the security and privacy of data to satisfy business needs. - Contribute to the automation of modules wherever required. - Be proficient in written, verbal, and presentation communication (English). - Coordinate with the UAT team. Role Requirements : - Proficiency in basic and advanced SQL programming concepts (Procedures, Analytical functions, etc.). - Good knowledge and understanding of Data warehouse concepts (Dimensional Modeling, change data capture, slowly changing dimensions, etc.). - Knowledgeable in Shell/PowerShell scripting. - Knowledgeable in relational databases, non-relational databases, data streams, and file stores. - Knowledgeable in performance tuning and optimization. - Experience in Data Profiling and Data validation. - Experience in requirements gathering and documentation processes and performing unit testing. - Understanding and implementing QA and various testing processes in the project. - Knowledge in any BI tools will be an added advantage. - Sound aptitude, outstanding logical reasoning, and analytical skills. - Willingness to learn and take initiatives. - Ability to adapt to a fast-paced Agile environment. Additional Requirement : - Design, develop, and maintain scalable data models and transformations using DBT in conjunction with Snowflake, ensuring effective transformation and loading of data from diverse sources into the data warehouse or data lake. - Implement and manage data models in DBT, guaranteeing accurate data transformation and alignment with business needs. - Utilize DBT to convert raw, unstructured data into structured datasets, facilitating efficient analysis and reporting. - Write and optimize SQL queries within DBT to enhance data transformation processes and overall performance. - Establish best practices in DBT processes to improve performance, scalability, and reliability. - Demonstrate expertise in SQL and possess a strong understanding of Data Warehouse concepts and Modern Data Architectures. - Exhibit familiarity with cloud-based platforms (e.g., AWS, Azure, GCP). - Migrate legacy transformation code into modular DBT data models. (ref:hirist.tech)

Location: Chennai, IN

Posted Date: 10/9/2024