Rajkumar Shiva

Background

About Rajkumar Shiva

Seasoned Azure Data Engineer and Business Intelligence Technical Lead with expertise in designing and implementing scalable data solutions. Proficient in T-SQL, PySpark, SparkSQL and PL/SQL, with extensive experience in developing ETL Azure Data Factory (ADF) with various activities and Data flow tasks and also with SSIS packages using various containers and tasks. Skilled in Master-Child Packages/Pipeline Models for optimized performance and maintenance. Adept in data warehousing and staging, and implementing best practices based on the scenario for performance tuning in ETL/ELT tools SQL Queries, and creating drill-down and parameterized reports in SSRS and Power BI Reports. Experienced in OLAP cube development, MDX, and advanced report customization with features like cascading parameters, data-driven subscriptions, and interactive dashboards. Proven track record in migrating databases to Azure Cloud, ensuring seamless integration and scalability. Certified Azure Data Engineer Associate (DP-203) with a hands-on approach to managing complex projects in Agile environments using Azure DevOps. Area of expertise: • Programming Languages: T-SQL, HQL, PL/SQL, PySpark, SparkSQL, C#. • Database Management Systems (RDBMS): MS SQL Server Azure SQL) • ETL and Data Integration Tools: Azure Data Factory (ADF), SQL Server Integration Services (SSIS), • Data Warehousing and Modeling: Azure Synapse Analytics, Azure Databricks, Azure Data Lake (ADLS Gen2), Star Schema and Snowflake Schema Design, Fact and Dimension Tables, OLTP and OLAP Architecture, Data Cleansing, CDC (Change Data Capture), SCD (Slowly Changing Dimensions). • Reporting and Business Intelligence (BI) Tools: SQL Server Reporting Services (SSRS), Power BI, QlikView, Tableau, Business Objects (BO), Excel Reporting • Big Data and Cloud Services: Azure Data Factory(ADF), Azure Functions, Azure Logic Apps, Azure Data Lake, Azure Databricks (Delta Lake, Medallion Architecture), Azure Synapse (Dedicated and Serverless SQL), Azure SQL Server, Azure Cosmos DB (NoSQL), Hadoop, PolyBase Queries, Azure Scheduler. • Version Control and CI/CD: GIT Repository, Azure DevOps (CI/CD Pipelines, Artifact, ARM Templates), Team Foundation Server (TFS), Visual Source Safe (VSS), SVN (Subversion Control)