Must have 1. Design and develop efficient data pipelines using relational databases and dimensional data modeling techniques.
2. Write complex SQL queries to extract, transform, and load data from various sources into data warehouse using postgresql/oracle/sql server or similar
3. Knowledge of at-least 1 ETL tool like informatica/Talend/AWS Glue or similar to deploy and manage data-related services.