Rajesh Dhandhukia

About Rajesh Dhandhukia

Professional experience in development of Applications design and reporting modules (Oracle/Informatica)* Apache Spark SQL, Hadoop HDFS, Hive and Impala.• Experience in areas of Project Management, Data Warehousing, Data Migration, Data Quality, Agile Methodology and Oracle Applications while managing complex projects and consulting assignments.• Business Analysis, Data Warehousing and Business Intelligence with extensive experience in multiple full life cycle DW/BI development projects including gathering business requirements, analysis of source systems, design suitable data model/architecture (both relational and dimensional including star schema) for data warehouses and data marts implementation.• Capable of adapting to working on New technologies & environments• Worked on performance tuning, identifying bottlenecks and resolving to improve performance at database level and Informatica mappings, session’s level.• Expertise in Oracle PL/SQL and database Performance Tuning by implementing Parallel Execution, Table Partition, materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes and also used the Explain Plan and SQL Tracing• Visualization, Design, and Development• Customizing Oracle Applications using Pl/SQL, Forms 6i and Reports 6i.• Envisioning Entire Designs of New Systems• Creation of Design Proposal, Project Planning• Mentoring, training, allocation of resources, client interaction, amicable conflict resolution, leadership responsibilities, communication and co-ordination with all internal and external stakeholders in the project.• Strong leadership with experience in client handling, onsite coordination and offshore team grooming.

Experience

1. Bigdata Cloud Engineer Ii

   Amazon Web Services (AWS)

   Aug 2020 — Present

   Subject matter expert in Hadoop infrastructure, Apache Spark and Hive with deep expertise in designing scalable data architectures and implementing enterprise-grade data solutions. Lead technical migrations and data engineering best practices for enterprise customers transitioning to AWS big data analytics services, including EMR, Glue, Redshift, EKS, DynamoDB and Lake Formation platform. Architect end-to-end data engineering solutions including data lakes, data warehouses, and real-time streaming pipelines using Spark, SQL, Kafka/MSK, and data lakes to meet complex customer analytics and reporting requirements. Optimize large-scale data processing workflows through advanced resource allocation, SQL query tuning, data partitioning strategies, and pipeline orchestration to improve performance by 40-60% and reduce processing latency. Design and implement comprehensive ETL/ELT data pipelines using Python, PySpark, AWS Glue, and custom frameworks ensuring efficient data ingestion, transformation, validation, and quality controls across huge volume datasets. Establish security controls including encryption, access management, and data governance to ensure compliance. Enhanced Spark and analytic application performance through cluster configurations, memory optimizations. Collaborate with cross-functional engineering teams and enterprise customers through technical workshops, architecture reviews, and solution design sessions to deliver data engineering solutions aligned with business objectives and technical requirements.

Education

• University of Mumbai

  Bachelor's degree, Computer Science

  2003 — 2005

• The ICFAI University, Tripura

  Master of Computer Applications (M.C.A.), Computer

  2006 — 2010

• ICFAI University

  Master's Degree

• Mumbai University

  Bachelor's Degree

Skills

• Sql
• Quality Center
• Software Development
• Team Management
• Java Enterprise Edition
• Agile Methodologies
• Full Sdlc
• Cloud Computing Iaas
• Databases
• Test Planning
• Data Modeling
• Design Patterns
• Data Warehousing
• Data Analysis
• Software Project Management
• Cloud Applications
• Ejb
• Web Services
• Testing
• Oracle Sql
• Manual Testing
• Performance Tuning
• Informatica
• Unix Shell Scripting
• Pl/Sql
• Requirements Analysis