Nikhil Kumar Sinha
Noida
Summary
Ambitious Technology Lead with 14 years successfully aligning internal and external technical resources to provide consistent and reliable progress toward business goals. Proponent of human-centric management approach and owner of deep technological expertise. Adept at combining scientific tools and common sense to maintain uptimes and exceed service level agreements.
Trained in Snowflake, DBT, Informatica & Azure Data Factory with extensive skills and history of proactivity. Dedicated to solution-oriented problem-solving.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Lead Technology
Iris Software Technologies Pvt Ltd
02.2021 - Current
- Responsible for leading the design and implementation of scalable, modern cloud-based data solutions, transitioning from legacy Oracle to Snowflake and Azure Data Factory at enterprise scale from 4 years.
- Architected and implemented end-to-end data solutions using Snowflake and Informatica, leading the migration of platforms and integrating data governance, metadata management, and documentation best practices under 1 year project.
- Designed, maintained, and optimized data models (star/snowflake schemas) for robust analytics and business reporting.
- Developed and orchestrated complex ETL/ELT pipelines in Talend and Informatica with Azure Data Factory, optimizing performance and enabling advanced reporting/dashboards.
- Collaborated closely with engineers, analysts, and stakeholders to gather business requirements and deliver scalable, technical solutions, ensuring alignment with business intelligence goals.
- Defined and enforced organizational best practices for data integrity, compliance, and security using cloud-native features (Snowflake auto-scaling, secure data sharing).
- Conducted technical code reviews and provided mentorship to junior team members, fostering knowledge sharing.
- Ensured compliance with privacy regulations and led technical due diligence for all data security matters.
- Project: Data Warehousing, Cloud Migration & Analytics Modernization
Technical Analyst
Coforge (Previous NIIT)
08.2019 - 12.2020
- Developed modern BI solutions from the ground up for British Airways, incorporating cloud data modeling and robust ETL automation within 6 months development cycle.
- Led end-to-end architecture of reporting solutions, maintaining data models and pipelines integrating on-prem and cloud AWS in 1 year delivery time.
- Designed and maintained dimensional models and ETL processes, aligning technical solutions to real-time business analytics needs for complete 1 year project.
- Implemented and orchestrated secure, high-performing data flows and optimized query performance.
- Documented all project phases, ensuring data lineage and best practices compliance.
- Conducted technical mentoring, code reviews, and enforced security and compliance in every phase.
- Project: Business Intelligence Operations Reporting (Airline/Cargo Domain)
Associate Technology L2
Sapient Consulting Pvt Ltd.
06.2014 - 06.2019
- Developed and managed robust Informatica ETL workflows using Informatica and Oracle, with increasing adoption of advanced DevOps/CI-CD frameworks for entirely 5 years of career span.
- Designed and maintained scalable data models for enterprise reporting, supporting large-scale analytics across business units in last 1 year of career .
- Ensured high standards of data quality, integrity, and compliance with enterprise data governance policies through out 5 years.
- Collaborated on requirement gathering, data profiling, and the creation of production support protocols.
- Contributed to the roll-out of management reporting solutions serving hundreds of users and generated multiple leadership/appreciation awards.
- Project: Management Reporting (Enterprise Domain)
Delivery Associate
Mphasis Pvt. Ltd
09.2011 - 09.2013
- Designed, monitored, and ensured success of Informatica ETL-based data loads, proactively managing cloud migration and automation initiatives in the beginning of 2 years in my career.
- Implemented core data security, role-based access, process optimization, and maintained rigorous documentation (knowledge repository) in 2 years.
- Participated in all lifecycle phases within an Agile methodology, including supporting L1/L2 operations, defect triage, and improvement sprints for all 2 years.
- Assisted in moving legacy systems toward cloud-friendly architecture for future scalability.
- Project: General Motors-Data Management Reporting (DMR) (Logistics Domain) for 2 years
Education
Bachelor of Science - CSE
PES College Of Engineering
Mandya, India05-2011
Higher Secondary Certificate - Science
St. Edmund's School
Jaipur, India06-2006
Matriculation Certificate - Science
Premalok Mission School
Patna, India05-2004
Skills
- Experienced in data modeling techniques
- Proficient in Informatica Power Center
- Oracle database management
- Skilled in Python development
- Talend ETL workflow management
- Cloud data solutions
- Snowflake data management
- Azure Data Factory
- SQL
- Salesforce CRM
- AWS Glue
- OBIEE
- Cognos
- Unix
Certification
IIT-D-AIML Certification, 02/01/24 - 08/31/24
References
NA
Timeline
Lead Technology
Iris Software Technologies Pvt Ltd
02.2021 - Current
Technical Analyst
Coforge (Previous NIIT)
08.2019 - 12.2020
Associate Technology L2
Sapient Consulting Pvt Ltd.
06.2014 - 06.2019
Delivery Associate
Mphasis Pvt. Ltd
09.2011 - 09.2013
Bachelor of Science - CSE
PES College Of Engineering
Higher Secondary Certificate - Science
St. Edmund's School
Matriculation Certificate - Science
Premalok Mission School
Similar Profiles
Kirti ChhokarKirti Chhokar
Senior HR Executive at Iris Software Technologies Pvt LtdSenior HR Executive at Iris Software Technologies Pvt Ltd
MANISH KUMARMANISH KUMAR
Team Lead at Iris Software TechnologiesTeam Lead at Iris Software Technologies
MAGESH JMAGESH J
Senior PLSQL Developer at Iris Software Technologies Private LimitedSenior PLSQL Developer at Iris Software Technologies Private Limited
Amartya SharmaAmartya Sharma
Web Analyst at Munivar Online Pvt LtdWeb Analyst at Munivar Online Pvt Ltd
Pinky AhlawatPinky Ahlawat
HR Administrative Assistant at LINTL Clothing Pvt. Ltd.HR Administrative Assistant at LINTL Clothing Pvt. Ltd.