Pankaj has career-focused in Cloud and Big Data Engineering where my experience has revolved around the facilitation of modern data platform and New-Gen Analytics solution for leading Pharmaceutical and Banking clients. 

• Analytical and detail-oriented Data Engineer with a broad knowledge base of Data Integration, transformation, wrangling, modeling, and orchestration

• Designed logical data models and developed performant data pipelines  

• Expertise in performing data analysis and profiling using structured queries and Python for producing  insights

• Participated in Requirement gathering and Design workshops with business stakeholders

• Experience in source code development using Python, Java

• Extensive experience in Dimensional Modeling and Data warehousing

• Led a team for end-to-end implementation of cloud-based Data warehouse in Redshift

• Sound knowledge of Big Data stack: Hadoop MapReduce, Hive, Apache Spark using PySpark

• Extensive hands-on experience in data warehousing projects using Informatica PowerCenter 9.x/10.x 

• Expertise in database programming- PL/SQL, Database tuning, and Query optimization.

• AWS Certifed Solution Architect with sound knowledge and experience of AWS Cloud Services:- Redshift,  Redshift Spectrum, Athena, RDS, EC2, S3, Lambda, SNS, SQS, EMR, SES, Lambda, ELB, EKS, CloudFormation templates