Shubham Bansal

WORK HISTORY

EDUCATION

ABOUT SHUBHAM BANSAL

Shubham is Python,Pentaho,SQL,GCP,Exasol Certified Professional Data Engineer with 5 years of industry experience including around 3 years of Experience in Big Data Technologies. Expertise in E2E life cycle of Data Warehousing project including Data-Modeling, Design, Transformation & Reporting with excellent technical and analytical skills. In Depth knowledge of Retail and Wholesale Banking domain and work who rank among the top in their industry. Outstanding communication skills, dedicated to maintain up-to-date IT skills and industry knowledge. His professiona Experience include –1.Data Quality analysis using Data Profiling techniques on source data2. Using Data Cleansing rules to enrich data quality and implement consistency3.Developed ETL Jobs in Pentaho using various steps (Meta Data Injection, Stream lookup, Merge Join, Sql/Java Script, All I/O steps, Variables, Email, Looping of Job, Parallel Execution, Value Mapper, Select Values, File Handling, Joins etc.).4.Ability to Multi-task in a fast-paced, deadline driven environment.5.Extensively used ETL to transfer and extract, pushed data from sources (S3 Bucket, Salesforce, Medallia, Csv Files, Flat Files, Oracle, LDAP, ASPEN, Exasol, Ftp Server, and API’s), and load the data into the target database.6.Published the Cube for full load and Delta Load for new migration as well as for existing Jobs also writes unit test cases, Unit Testing and Integration Testing.7.Responsible for Performance Tuning at the Transformation Level, Source Level and the Target Level for Slowly Changing Dimensions Type1, Type2 for Data Loads8.Provide Zero Distance Idea to Client, Implement the same in upcoming Sprints and training junior resources time to time, and involves in technical workshops.9.Design the RISK data model and developed the python framework for analyzing the credit risk across the globe with respect to GDP, Oil prices, COVID, Stock-Exchanges which helps the Risk business users to predict the credit risk.