Experience in data warehousing, ETL, and data modeling
Experience working with SQL and NoSQL databases
Experience with data modeling in large Data warehousing, data lake environment
? Architect and develop and maintain an enterprise data warehouse
? Knowledge of MS SQL Server, SSIS, SSRS.
? Knowledge of Hadoop, Hive, HBase, and Pig scripting is a plus
? Design and develop database objects, tables, stored procedures, views, and triggers in MS SQL Server.
? Design and implement robust end-to-end ETL pipelines
? Create and manage ETL data pipelines (sourcing data from databases, streaming data, various web APIs, etc.)
? Integrate data from the data warehouse into 3rd party tools to make data actionable
? Configure and maintain database servers and processes, monitor system health and performance, ensuring high levels of performance, availability, and security.
? Preparing and maintaining storage management plans, including routine backups, long-term archives, and disaster recovery support.