Role: Data Engineer
Work location: Las Vegas, NV OR Franklin, TN (Onsite)
Duration: 06+ months
Job description:
Job Summary.
1. Data Modelling (mandatory)
a) Should have complete understanding of modelling techniques.
b) Should be aware of key considerations while designing star schema.
c) Should know what normalizing techniques are.
d) Should have used some modeling tools to design physical and logical layers.
2. Talend.
a) Should have good experience using Talend (at least 2 years minimum).
b) Should have used components like tmap, tjoin, tjava, tjavaRow, tRest, tRestClient, file-based & snowflake-based components, etc.
c) Should have experience in pulling data from various sources like API, SQL-based sources, File based sources.
d) Should know performance tuning method and should be aware of the
3. Snowflake (mandatory).
a) Should have worked on snowflake different features/components.
b) Should be aware of snowflake concepts on cost optimization.
c) Should know how to write stored procedures.
4. GCP/Big Query (basic to intermediate).
a) Should have basic knowledge of GCP and Big Query as we are migrating from BQ to Snowflake
5. DevOps (basic)
a) Should have handled CI/CD process in his past projects.
b) Should be aware of the push/pull mechanism to deploy the code.
c) Should be able to explain the concepts.
6. SQL (mandatory).
a) Should be good at writing SQL queries.