Overview
Work History
Timeline
Generic

MANIKANTA BATCHU

Hyderabad

Overview

6
6
years of professional experience

Work History

Azure Data Engineer

Zensar Technologies Ltd
Hyderabad
04.2021 - 07.2024
  • Requirement gathering by reading the JIRA or CONFLUENCE pages
  • Developing and implementing data using Azure cloud management solutions
  • Designing and managing data storage and data processing solutions in Azure
  • Integrating data sources and build data pipelines for data transformation and ingestion
  • Working with Storage accounts, external data sources, Data sets, Linked services, Pipelines, Power Queries and Various Activities for Data transformations
  • Ensuring data security and compliance with best practices
  • Writing complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the tables
  • Deep knowledge of SQL and best practices
  • Experience working with Oracle databases, preferably 11g or later release
  • Demonstrated ability to performance tune queries for maximum performance
  • Understanding the requirements and carrying out impact analysis
  • Proficiency using SQL Developer, TOAD or equivalent developer tools
  • Good working experience in support and development of Client-Server and web applications using Oracle
  • Developing conceptual, logical, and physical data models to support data analysis and business intelligence
  • Collaborating with business stakeholders to understand data requirements and ensure models meet business needs
  • Analyzing organizational needs and designing data models that support business processes
  • Analyzing and improving data warehousing processes and strategies
  • Ensuring data quality, integrity, and security
  • Creating and monitoring business reports and metrics
  • Utilize PySpark and Python for complex data processing tasks on large datasets within Azure Databricks
  • Collaborate with data analysts to understand data requirements and ensure data quality
  • Designing, building, and deploying data pipelines and workflows using Databricks
  • Developing and optimizing Apache Spark applications for data processing and analytics
  • Working with RDD’s, DataFrames and Spark SQL
  • Optimizing DataFrames performance using techniques like Partition, Z-Order By
  • Creating User Defined Functions using Python
  • Integrating Databricks with various data sources and platforms
  • Implementing data quality checks and monitoring processes
  • Managing and configuring the Databricks environment, including clusters and notebooks
  • Troubleshooting and resolving issues related to Databricks performance and functionality
  • Staying up-to-date with the latest ADF, Databricks and Pyspark features and best practices

PL/SQL Developer

Cognizant
Hyderabad
01.2021 - 04.2021
  • Strong knowledge in writing SQL Queries that varies from single table simple SQL’s to multiple table complex SQLs
  • Document concise design, development, and testing processes for assigned projects
  • Exceptional analytical and debugging skills
  • Coordinate with DBAs for tasks such as creating/rebuilding indexes, adding partitions, and analyzing tables
  • Proficiency using SQL Developer or equivalent developer tools
  • I have very good experience in SQL, expert writing complex queries and working with database objects like Tables, Views, Sequences, Synonyms, Indexes, Joins, Bulk Processing
  • Good working experience in support and development of Client-Server and web applications using Oracle database 11G and 12C
  • Thorough subject knowledge, strong analytical and troubleshooting skills with an ability to perform in a challenging environment

SQL/PLSQL Developer

Microspark Software Solutions Pvt Ltd
Hyderabad
05.2018 - 01.2021
  • Good knowledge in writing SQL Queries that varies from single table simple SQL’s to multiple table complex SQLs
  • Proficiency using SQL Developer or equivalent developer tools
  • Good working experience in support and development of Client-Server and web applications using Oracle database 11G and 12C
  • Create database tables, create various db queries and assist in data mapping/testing activities in support of project
  • Coordinate with DBAs for tasks such as creating/rebuilding indexes, adding partitions, and analyzing tables
  • I have very good experience in SQL, expert writing complex queries and working with database objects like Tables, Views, Sequences, Synonyms, Indexes, Joins, Bulk Processing
  • Work with the advanced features of PL/SQL like collections, nest table, ref cursors, materialize views and dynamic SQL

Timeline

Azure Data Engineer

Zensar Technologies Ltd
04.2021 - 07.2024

PL/SQL Developer

Cognizant
01.2021 - 04.2021

SQL/PLSQL Developer

Microspark Software Solutions Pvt Ltd
05.2018 - 01.2021
MANIKANTA BATCHU