Dhairya Sheel Rastogi

As an ETL Developer, I have extensive experience designing and implementing ETL processes to extract, transform, and load data from various sources into data warehouses. My work focuses on optimizing SQL queries for data analysis and improving stakeholder reporting capabilities. I ensure data integrity and quality throughout the ETL pipeline, enabling decision-makers to easily access and analyze the relevant information.

• Developed SQL queries to support data analysis and enhance reporting capabilities for stakeholders.
• Created incremental data load logic to detect changes and mark outdated records as inactive in the data warehouse using Pentaho.
• Designed and optimized stored procedures to meet complex business requirements.
• Collaborated with business teams to gather and analyze requirements for customized data solutions.
• Conducted on-site visits in the Philippines to standardize business requirements and ensure alignment with client needs.
• Utilized Synaptrics Intellview NXT to create detailed, analytical business reports that provided actionable insights for clients.

• Handled WhatsApp integration for order processing, ensuring seamless communication and order management.
• Implemented automation testing across various modules to enhance quality assurance and streamline testing workflows.
• Integrated multiple REST services into different modules, enabling smooth data exchange and system interoperability.
• Integrated PayU into the Oziva ecosystem to facilitate seamless subscription management and payments.
• Integrated Shopify Orders API into the Oziva accounts system, automating invoice generation and significantly reducing manual work.
• Technologies Used: Java, JSON, Maven, Servlets, REST API Services, TestNG, Selenium.