Prakhar Gupta

4+ years of work experience

Oct 20241 yr 9 mosPresent

Pune District, Maharashtra, India

• Working for a Pharmaceutical client in their Commerical data management and Next Best Action portfolio. • Involved in project cycle plan for the data warehouse, source data analysis, data extraction process, and transformation and loading strategies. • Actively involved in weekly client meeting. • Used Informatica for migrating data from various OLTP servers/databases. The data migration included identifying various databases where the information/ data lay scattered, understanding the complex business rules that need to be implemented and planning the data transformation methodology. • Extensively used Informatica client tools - Source Analyser, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager. • Worked with Variables and Parameters in the mappings to pass the values between sessions. • Extensively worked with Debugger using breakpoints and various test conditions to test the logic and the validity of the data moving through the mappings. • Analysed data flow requirements and developed a scale able architecture/plan for staging data/loading data. • Designed Sequential Workflow using Workflow Manager, Workflow Monitor for whole process. • Involved in Performance Tuning of the mappings. • Involved in the End user training and worked in testing and production support environments

Jul 20224 yrsPresent

• Architected, developed, and optimized 21+ ETL pipelines using Informatica IICS and Snowflake, achieving 99.9% uptime across pharmaceutical datasets (anti-obesity, diabetes, cardiovascular therapies). • Systematized end-to-end data workflows using Python and SQL, reducing data processing time by 35% and improving pipeline efficiency and reliability. • Built and maintained centralized data warehouse on Snowflake using star/snowflake schema and fact & dimension modeling, enabling consistent analytics and compliance reporting. • Integrated structured and semi-structured data (JSON, CSV, Parquet) into Snowflake, improving report delivery speed by 30%. • Leveraged AWS services (S3, EC2, IAM, Lambda) for cloud-based data ingestion, storage, and orchestration; collaborated with stakeholders to translate business needs into scalable data models. • Enforced data quality checks and validation frameworks; participated in Agile/Scrum ceremonies via Azure DevOps (ADO).