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