EXPERTISEDatabases• Creating conceptual, ER, logical, and physical data models for data warehouse and transactional systems• Implementation of dimensional models, data marts, EDW, ODS, and OLTP databases and their administrationBI and Analytics• Descriptive, Predictive and Prescriptive analytics modeling and methods• Prototyping, and developing ETL/ELT, Reporting, Analysis, Monitoring, and Data Mining BI solutionsCloud• Setting up of Azure cloud and hybrid infrastructure for data warehouse and BI systems• Migrating, extending, and modernizing of on-premise data warehouse environments to cloud• DWH and data pipeline CICD• Integration of structured and semi structured data sourcesBig Data• Prototyping of Hadoop and Cloud storage based computing solutions• Big data experiments on modern data warehousingSKILLS• Database: SQL Server, Oracle, PostgreSQL, Azure SQL database, Hive, Spark SQL• Cloud data warehouse: Azure Synapse, Snowflake, Azure data lake• ETL/ELT: SSIS, Matillion, Informatica ICS, Talend, Azure data factory, Sqoop, Airflow• BI: SSRS, SSAS Multidimensional/Tabular, QlikView, Tableau, Power BI, Roambi, Datazen, Looker, Splunk, R• Design/Modeling: ER Studio, Enterprise Architect, Visio, Erwin Data Modeler, DBT• Language: T-SQL, PL/pgSQL, PL/SQL, MDX, DAX, DMX, PowerShell, C#, JavaScript, Java, Python• Administration: Azure, SQL Server (relational and OLAP), TFS, Tableau, Power BI, Snowflake, Airflow, DBT• Devops: TFS, VSS, Surround, Tortoise SVN, Git• CDC: Attunity, HVR
Listed skills include Ssrs, Microsoft Sql Server, Ssis, T Sql, and 37 others.
