Nishant Rajput

Background

About Nishant Rajput

With over 13 years of experience in design, data modelling, development, analysis, and architecture, having deep expertise in Business Intelligence, Data Engineering, and Data Warehousing. My skills span the entire data lifecycle—from extraction and modelling to delivering insights via reporting tools—using both traditional on-premise technologies (Teradata, Informatica) and modern big data platforms ( Pyspark, Python, NIFI, Pandas, Datalake etc.). Currently part of a Data Analytics Team, responsible for requirement gathering, architecture, design and development efforts for large-scale customer data projects. My technical toolkit includes Azure, Databricks, Snowflake, Hadoop, hive, Informatica PowerCenter, power BI, SQL, PySpark, Python, Pandas, YML, NIFI, Oozie, and Unix scripting, with a strong focus on building data engineering solutions and big data applications. Key highlights- Proven leadership in managing and mentoring teams, including leading a 6-member team to maintain and enhance BI platforms and architecting end-to-end reporting solutions- Deep expertise in advanced data modelling, creating facts/dimensions, and working with OLAP/OLTP concepts- Experience in Power BI reporting and extensive knowledge of SQL development- Cross-industry exposure to Telecom, Banking, Media, and Telecommunications sectors- Recognized as a Knowledge Lead in Data Warehousing and skilled in modern cloud-based data platforms like Azure, Databricks, and Snowflake- Technical Skills Cloudera Big Data – Hadoop, Hive, Ozone, Key Vault etc. Programming Language– SQL, Pyspark, Pandas, Python ETL - Informatica PowerCenter 10.1.1 Data Collection Data Quality and Accuracy Data modelling using IBM Infosphere Data Architect Data Governance - Collibra, Apache Atlas Data Visualization & Reporting - knowledge on Power BI Data Processing - Databricks, Apache Spark, Azure Data Factory, Hadoop, Hive Data Storage - Azure Data Lake, Azure SQL Database, Snowflake, Cloudera Ozone Data flow Optimisation Data Management Previous on-premise tools – Informatica, oracle, Teradata, Unix Data flow Monitoring Process management - JIRA, Confluence