About me

🚀 Data Specialist | IT Professional with 9+ Years of Experience 🚀 Greetings! I'm Abhijit Bangal, a seasoned Data Specialist with over 9 years of hands-on experience in the IT industry. Throughout my career journey, I've honed my expertise in Data Engineering and Data Warehousing, specializing in implementing both short-term and long-term projects with precision and efficacy. 🔍 Areas of Expertise: ✅ Automated Data Pipelines: Proficient in designing and implementing automated idempotent data pipelines utilizing ELT/ETL processes, primarily focused on batch processing. ✅ Enriched Data Layer Creation: Skilled in collaborating with business owners to understand data requirements and crafting enriched data layers tailored for insightful reporting and analysis. ✅ Cost Optimization: Adept at monitoring usage costs and optimizing ELT/ETL processes or SQL queries to drive efficiency and save on compute and storage expenses. ✅ Data Modeling and Secure Sharing: Experienced in data modeling and ensuring secure data sharing practices with external vendors, ensuring data integrity and compliance. 💻 Technologies I work In: Data Warehouse: Proficient in Snowflake (Snowpipe, Streams, Task, Directory Tables, Snowpark), Azure Synapse Analytics, and Teradata. Databases: Skilled in MSSQL, MySQL, Oracle, and IBM DB2. Languages: Proficient in Python, SQL, and SnowPark. ETL/Integration Tools: Experienced with Informatica Powercenter, IICS, IBM DataStage, Azure Data Factory, and AWS Glue. Cloud Storages: Well-versed in AWS S3 and Azure Blob Storage. Scheduling Tools: Familiar with CA7, IBM Tivoli, and Autosys. 🏢 Domain Experience: With a background spanning the BFSI and Retail sectors, I bring deep domain expertise to every project, understanding the unique challenges and opportunities within these industries. 🔧 Additional Skills: In addition to my core competencies, I have hands-on experience working with Mainframe systems, including JCL and Cobol modules, further enhancing my versatility and problem-solving abilities.