AJAY B

Dedicated and proficient Azure Data Engineer with over 4 years of IT experience specialized in Azure and Hadoop ecosystems, leveraging a deep understanding of data ingestion, modelling, querying, processing, storage, analysis, and integration to implement robust, enterprise-level systems. Demonstrates a comprehensive grasp of Azure Data Services, including Azure Data Lake, Azure SQL Database, Azure Data Factory, Azure Synapse Analytics, Azure Databricks, and Blob Storage. Experience in Migrating SQL database to Azure data Lake, Azure SQL Database, Data Bricks and Azure SQL Data warehouse and controlling and granting database access and migrating on-premises databases to Azure Data Lake store using Azure Data Factory. Good experience on Azure Data bricks clusters, notebooks, jobs, and auto scaling. Designed and Developed ETL Processes in Azure data factory to migrate data from external sources like S3 and text Files into Azure synapse. Proficient in applying Kimball methodologies for the design and implementation of effective data models, with a focus on star schemas to enhance reporting and analytics capabilities. Hands on Experience interacting in Python, PL/SǪL, T-SǪL, and REST APIs, enabling the design, development, and execution of comprehensive data pipelines. Hands-on experience on Databricks Workspace UI, Managing Databricks notebooks, Azure Delta Lake with PySpark, and Spark SQL. Experienced in utilizing Azure DevOps tools for CI/CD pipelines, along with version control using Git and SVN. Gained experience on designing and implementing complete end-to-end Hadoop infrastructure using HDFS, MapReduce, Hive, HBase, Kafka, Sqoop, Spark, and No SǪL databases. Possesses strong SǪL capabilities across multiple dialects, including MySQL, PostgreSQL, Redshift, SǪL Server, Oracle, and Snowflake. Implemented complex business logic through T-SQL stored procedures, Functions, views, and advanced query optimizations. Experience in designing Cassandra tables and optimizing schemas for efficient data retrieval and storage. Familiar with a wide array of Azure technologies such as Cosmos DB, Virtual Machines, Kubernetes Services, Event Hubs, Logic Apps, HDInsight, etc. Collaborative team player, adept at coordinating with team members to meet project deadlines and updating Jira tickets to ensure project tracking and management. Versatile in the software development life cycle (SDLC), employing both waterfall and agile (Scrum) methodologies to drive project success.