About

Mayank Porwal is a Principal Software Engineer at ConcertAI with over 12 years of relevant experience. He is a Python Backend Developer and an avid Stack Overflow contributor. Mayank is skilled in various programming languages including Python, ETL tools such as Informatica PowerCenter 8.6 and Talend Studio 5.x, and databases like Teradata, Oracle, and Vertica. He is also proficient in data processing tools such as Pandas, Numpy, Hadoop, Hive, Pig, and SQL. Currently, Mayank works at amdocs as a Subject Matter Expert in ETL development. He is responsible for building a data warehouse for a Telecom Giant and developing ETL processes for loading data, which is used for reporting purposes for profit maximization. In his role, he works closely with business users to finalize the optimum design and implementation. He also understands the requirements from Data Architects, Clients, and requirement specification documents. Mayank has extensive experience in creating and enhancing Informatica processes from Teradata tables and flat files, burning surrogate keys, and creating LRFs to be loaded to target tables. He has used concurrent execution of workflows to speed up the process. Additionally, he has created and modified load scripts using Teradata utilities like tpt, bteq, and mload. Mayank has also worked on Bteq Scripts to generate detailed and summarized extracts from the summary tables. Mayank has worked from start to finish on development, covering the whole project life cycle from Initial Impact analysis, Development, Unit Testing till deployment support. He reports to the management on a daily and weekly basis. Mayank holds a Bachelor's Degree in IT from Vellore Institute of Technology, which he completed in 2011. He also attended St. Joseph's Co-ed School, Bhopal, from 2000 to 2006. Mayank's tech stack includes Software Engineering, Python, SQL, Backend, Hadoop, Pandas, AWS, Snowflake, ETL, Flask, QA, Microservices, Apache Hive, Postgres, Frontend, Amazon Athena, Big Data, HDFS, RabbitMQ, and Web.