Nitesh Rathore

Data Engineer with 4+ years of experience in ETL development, data warehousing, SQL development, Snowflake, Python, AWS, PySpark, Apache Spark, and data pipeline development. Experienced in building scalable ETL pipelines, reusable data ingestion and connector frameworks, data validation and data quality processes, Snowflake data warehouse schemas, SQL query optimization, backend services, and CI/CD automation. Improved pipeline performance by 40% through complex SQL query optimization.

Data Engineer / Software Engineer at PowerSchool India Pvt Ltd (2021-12 – 2025-12)

• Designed and developed scalable ETL pipelines using Python and SQL for large-scale datasets and data warehouse processing.
• Developed backend logic and data processing modules using Java and Python to support data workflows.
• Optimized complex SQL queries and transformation logic, improving pipeline performance by 40%.
• Developed reusable data ingestion and connector frameworks to automate extraction, transformation, validation, and loading of source data.
• Designed Snowflake data warehouse schemas for analytics workloads and downstream reporting.
• Implemented data validation, data quality, and consistency checks across ETL and data processing workflows.
• Developed APIs and backend services supporting data workflows and system integrations.
• Automated data pipelines and deployment workflows using CI/CD, Git, GitHub/GitLab, and YAML configuration.
• Worked with AWS services including S3, EC2, and IAM for cloud-based data processing.
• Collaborated with data, backend, and product teams to deliver scalable data and software solutions.

B.Tech – JECRC

Senior Secondary – Saurabh Sr. Sec. School