• 3.3+ years of hands-on experience in BI technologies that include Data Management, Analysis, Time Estimation, Design, and Development of ETL data pipelines using multiple technologies.
• Optimizing ways to load Petabytes of data in the latest trended EMC Greenplum database and HAWQ (works with HDFS database)
• Good experience in the development and optimization of complex SQL queries with different window functions
• Currently working as a Data Engineer at clouding Ltd., Banglore.
EXPERIENCE
National Stock Exchange of India, Mumbai (System Analyst) (Aug 2018 – Sep 2021)
• Involved in the development of data mart for different projects.
• Involved in design, development, and reporting part of various projects
• Development of multiple ETL data pipelines, creation of Universes in SAP Business Objects, dashboard creation using Tableau
• Development of SCD (Slowly Changing Dimensions) mappings and fact tables
• Developed multiple MIS reports for Senior Management and Business Users
• Worked on different BI tools such as Python, Informatica Power Center (ETL tool), SAP BO(Reporting), Tableau (Analysis/Reporting/Dashboards), Shell Scripting, PostgreSQL, GreenPlum (MPP architecture)
• Troubleshooting, Debugging issues and bugs.
• Impact Analysis.
• Implement best practices of Data Warehousing.
