Job Description: Should have good knowledge of Advanced SQL ( Ranking, Analytical function) Should have good knowledge of Snowflake, Pyspark/Scala ,Snwoflake, Azure Databricks. Should have good knowledge Data validation of Full & Incremental load Should have good knowledge of Data warehousing Concepts Should have good knowledge of Writing advanced sql and oracle query Fact & dimension modeling ETL Testing hands-on Need to Row number and Rank Function in sql server Fact and Dimensional concepts. Should be knowing SQL Server functions Good understanding of data warehouse concept. Analytical skill to play with Data Should be able to understand and capture the project requirements Should be able to understand and analyze the code flow/work flow Should be able to debug/analyze the production logs/errors. Should be able to do the unit testing of code Should be able to do the documentation of services. Job Type: Full-time Pay: $40,282.61 - $112,885.02 per year Benefits: 401(k) Dental insurance Flexible schedule Health insurance Paid time off Relocation assistance Vision insurance Schedule: Monday to Friday Ability to commute/relocate: Long Island City, NY 11101: Reliably commute or planning to relocate before starting work (Required) Experience: Informatica: 5 years (Required) SQL: 5 years (Required) Data warehouse: 1 year (Preferred) Work Location: In person