About

Vivekanand Bandekar is an accomplished Application Developer, BI at CommScope with over 6 years of experience in ETL development using Informatica and Oracle SQL/PL-SQL. He is well-versed in Streamsets data ingestion tool and Snowflake database and has worked on automation using Unix shell scripting. Vivekanand has exposure to Python programming and visualization tools such as Tableau and Microsoft Power BI. He possesses a strong understanding of database concepts and is proficient in writing efficient SQL queries to check the dataset. Vivekanand has worked with various companies in the past, including Saama and Syntel, where he gained valuable experience in enhancing data warehouse projects using Informatica ETL tool, automating manual processes of code review and migration using Unix shell scripting, and working with Hadoop technologies and Tableau reporting tool. He also participated in the Hackathon event in 2019 to develop a product using Python programming. As an Informatica Developer at Syntel, Vivekanand was responsible for the requirement gathering phase based on the tickets received from the clients. He developed detailed design documents as per the requirements and created/modified Oracle objects such as tables, views, stored procedures, triggers, index, etc. He also developed Informatica source/target definitions, mappings, mapplets, sessions, and workflows as specified in the detailed design documents. Vivekanand prepared test case documents to test the mappings created as per the assigned tasks, created UNIX job scripts which run the workflows developed in the Informatica, debugged and fixed the issues encountered in the jobs/workflows, and worked with clients on few critical issues from the production and provided them with the alternate solutions which were successfully implemented. He also assisted the other team members in completing their tasks. Vivekanand's technical expertise includes SQL, Python, ETL, Snowflake, Data Warehouse, Hadoop, and test. With a relevant experience of 8.87 years, Vivekanand is a highly skilled and dedicated professional who is always eager to learn and grow in his field.