Basant Nailwal
Summary
With over 14 years of experience in designing and implementing scalable data solutions, I bring a wealth of expertise in AWS, Snowflake, Python, and Oracle Data Warehousing. I have a proven track record of building robust ETL pipelines, automating workflows, and ensuring the highest standards of data quality. My skill set is complemented by a strong commitment to continuous learning and integrating emerging technologies to stay ahead of industry trends and deliver innovative solutions.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Technical Consultant
Fidelity International
12.2020 - Current
- Assisted in building a scalable data pipeline in Snowflake for batch and streaming data processing. Utilized Snowflake's features like Snow SQL, Snowpipe, and streams to support real-time data architecture. Aided in optimizing pipeline efficiency and reducing latency for effective data integration.
- Spearheaded design and implementation of batch and streaming data pipelines utilizing Snowflake for optimized data processing.
- Utilized Oracle GoldenGate and Spark-based frameworks to streamline data ingestion from multiple sources.
- Spearheaded establishment and maintenance of robust CI/CD workflows utilizing Snowflake CLI and GitHub Actions.
- Spearheaded solution design by collaborating with business stakeholders and cross-functional technology teams to align data solutions with organizational objectives.
- Facilitated agile ceremonies, including daily stand-ups, sprint planning, and retrospectives, to enhance team collaboration.
- Implemented advanced Snowflake features and best practices to enhance data processing workflows.
Technical Lead
Nagarro
08.2018 - 12.2020
- With extensive experience in Oracle Data Warehousing, I successfully designed, implemented, and optimized data solutions that deliver high performance and scalability. My expertise includes:
- Data Architecture & Modeling: Designed and implemented data models (star, snowflake, and normalized schemas) tailored to business requirements, ensuring seamless integration and easy access to business-critical information.
- ETL Development & Optimization: Built efficient ETL pipelines for data extraction, transformation, and loading (ETL) using Oracle SQL, PL/SQL ensuring timely and accurate data delivery.
- Performance Tuning: Applied advanced techniques for optimizing query performance, indexing, partitioning, Query Optimization and managing large datasets, which enhanced overall data warehouse performance and reduced query response times.
Technology Analyst
Tata Consultancy Services
05.2015 - 07.2018
- During my time at TCS, I worked on a financial domain project where I played a key role in developing and optimizing data solutions using Oracle Data Warehousing and Unix. My main responsibilities included:
- Oracle Data Warehousing: Designed, developed, and optimized data models, ETL processes, and data pipelines for the financial system, ensuring seamless integration and high-performance data access.
- SQL and PL/SQL Development: Wrote complex SQL queries and PL/SQL scripts to extract, transform, and load (ETL) data from various transactional systems into the data warehouse.
- Performance Tuning: Applied advanced Oracle performance tuning techniques, including indexing, partitioning, and query optimization, to enhance the performance of large-scale financial data processing.
- Unix Scripting: Utilized Unix shell scripting to automate various tasks.
Systems Engineer
Infosys Technologies Ltd
08.2011 - 04.2015
- Retail Domain Project at Infosys (P&G): As part of the P&G project at Infosys, I gained valuable hands-on experience in the retail domain, where I focused on learning and applying core database concepts, particularly with Oracle. As I was just starting my career, my primary focus was on acquiring foundational skills and practical knowledge, including:
- Oracle Database Fundamentals: Gained in-depth knowledge of Oracle database architecture, learning key concepts like data types, tables, indexes, and relationships.
- SQL and PL/SQL: Developed skills in SQL for querying databases and PL/SQL for creating stored procedures, functions, and triggers to manage and manipulate data.
- Hands-on Experience: Actively participated in database-related tasks, including data extraction, transformation, and loading (ETL) processes, learning how to structure and maintain data for retail applications.
- Retail Data Models: Gained exposure to how data is organized in the retail domain, learning about sales data, inventory management, and customer behavior analysis.
- Problem-Solving and Debugging: Worked closely with senior team members to troubleshoot database issues, optimize queries, and ensure smooth operation of retail-related data processes.
Education
Bachelor Of Technology (BTech) - undefined
Maharaja Agrasen Institute Of Technology
New Delhi08.2011
Skills
- Data Engineer
- Snowflake
- Snowpark
- Aws
- Python
- Github
- Control M
- Unix
- Oracle
- Etl
Certification
- SnowPro Certified, Snowflake 3/2025 - 3/2027
- Aws Data Engineer Certified, AWS 6/2024 - 5/2026
Language
English
Hindi
Hobbies
Data Engineering Podcasts, Cricket
Timeline
Technical Consultant
Fidelity International
12.2020 - Current
Technical Lead
Nagarro
08.2018 - 12.2020
Technology Analyst
Tata Consultancy Services
05.2015 - 07.2018
Systems Engineer
Infosys Technologies Ltd
08.2011 - 04.2015
Bachelor Of Technology (BTech) - undefined
Maharaja Agrasen Institute Of Technology