Snowflake Developer + Talend

Qualifications

1 Strong understanding of Data warehousing Dimensional Modeling ETL etc and RDBMS concepts

2  Minimum 5 years working experience with Talend ETL tool

3 Minimum 5 years working experience in SQL Stored Procedures and Table Design

4 Minimum 5 years working experience in SQL Query optimization and ETL Data loading Performance

5 Minimum 2 years working experience in Snowflake Cloud Data warehouse

6 Experience as a Data Engineer in Hadoop Platforms on components like HIVE KAFKA NiFi Spark etc is a big plus

7 Minimum 2 years working experience in shell scripting

8 Experience in real time streaming technologies is preferred

9 Experience deploying machine learning models and automating processes in production is a plus

10 Experience with cloud technologiesAWS Azure GCP is big plus

Responsibilities

As a core member of team of Data EngineersETL Developers responsibilities include but not limited to

1 Design Develop and maintain secure consistent and reliable ETL solutions supporting critical business processes across the various Business Units

2 Ensure data solutions are compliant with enterprise security standards

3 Work in complex multiplatform environments on multiple project assignments

4 Develop and perform tests and validate data flows and prepare ETL processes to meet complex business requirements including designing and implementing of complex endtoend solutions using BI platforms

5 Coordinate with analysts and developers to ensure jobs designed and developed meet minimum support standards and best practices before migration into the production environment

6 Partner with various infrastructure teams application teams and architects to generate process designs and complex transformations to various data elements to provide the Business with insights into their business processes

7 Uses strategies such as Indexing and partitioning to fine tune the data warehouse and big data environments to improve the query response time and scalability

8 Define and capture metadata and rules associated with ETL processes

9 Assist production support team in providing resolutions to production job failures data issues and performance tuning