Hana Esolutions Inc - El Dorado Hills, CA
posted 13 days ago
Full-time - Mid Level
El Dorado Hills, CA
About the position
The Database Architect/Data Engineer role at Hana Esolutions Inc involves designing, developing, and implementing ETL processes to load data into a Snowflake Data Warehouse. The position emphasizes data governance, quality standards, and the creation of data models and transformation pipelines. The role also includes migrating data warehouses and applications to cloud environments, specifically AWS, while leading a team of data engineers.
Responsibilities
- Design, develop, and implement ETLs in IICS to load data into Snowflake Data Warehouse.
- Ensure data governance and quality standards, defining rules and policies for stakeholders.
- Create models using Data Build Tool (dbt) to process data from Snowflake.
- Create and maintain data transformation pipelines and multiple dashboards in Tableau.
- Migrate data warehouse from Vertica to Snowflake.
- Develop ETLs using multiple tools like IICS, Matillion, and dbt.
- Migrate ETLs from Informatica PowerCenter to Informatica Intelligent Cloud (IICS).
- Migrate on-premises applications to AWS cloud.
- Minimize data warehouse costs and increase performance.
- Lead a team of data engineers.
Requirements
- Bachelor's degree in Computer Science, Technology, Engineering, C.I.S., or equivalent.
- 5 years of experience in relevant fields.
