As a Lead Data Engineer at offshore, I've played a pivotal role in the Walnut Enterprise Data DivestCo project for Albertsons since November 2023. This initiative emerged from the Kroger and Albertsons merger, aiming to streamline data and migrate Divested stores' details to a new environment within Snowflake for third-party vendor CNS.My responsibilities have been diverse and impactful. From direct client interaction to effectively gathering requirements, I've ensured alignment with stakeholder expectations. Leading offshore teams, I've orchestrated seamless collaboration, ensuring efficient delivery of project milestones. Working closely with Data Engineering teams, I've facilitated the setup of Business Objects Data (BOD's) and resolved data flow issues with detailed Root Cause Analysis (RCA). Leveraging Unix scripts, I've streamlined data population processes and automated testing through iCEDQ and Python programming, enhancing project efficiency.Utilizing Snowflake's advanced features such as Stages, Streams, SnowPipe, and Stored Procedures, I've optimized data processes and ensured smooth deployments through Continuous Integration/Continuous Deployment (CI/CD) using GitHub actions. Additionally, I've managed production deployment Change Requests (CR) and actively contributed to daily stand-up meetings, regression runs, and production support.My commitment to team management, knowledge transfer, and mentoring activities has fostered a collaborative and dynamic work environment, driving continuous improvement. Overall, my leadership and expertise have been instrumental in the successful execution of the Walnut Enterprise Data DivestCo project, delivering value and innovation in the retail domain.

As an Intermediate Data Engineer I spearheaded the Data Quality and Governance project for Albertsons within the retail domain from March to November 2023. Leveraging a suite of cutting-edge technologies including SQL Server, Denodo, ADLS, Snowflake, iCEDQ, and Alation, I implemented robust strategies to ensure data accuracy, completeness, uniqueness, consistency, and validity. Through direct client interaction and efficient requirement gathering, I developed performance-efficient logic tailored to client specifications. My responsibilities encompassed conducting data profiling activities to comprehensively understand dataset structures and relationships, facilitating informed decision-making. I also developed stored procedures to visualize sales trends by commodities, enhancing strategic insights. Vigilant issue reporting and bug resolution processes ensured seamless project progression.By implementing SQL rules within iCEDQ and Alation, I standardized data processes, fostering governance protocols and improving overall data integrity. Utilizing Denodo, I ensured consistency between source and target data, bolstering reliability.Active participation in daily stand-up meetings, regression runs, and team management activities underscored my commitment to project success. As part of production support, I conducted data analysis and issue resolution, contributing to sustained operational excellence.In summary, my leadership in the Data Quality and Governance project drove enhanced accuracy, reliability, and governance, positioning Albertsons for data-driven success in the competitive retail landscape.

Contributed as a primary Data Engineer on the project undertaken by Cognizant Technology Solutions (CTS) for Albertsons clint which focused on EDM Remediation, spanning from April 2022 to February 2023. As a Data Engineer, the project aimed to revolutionize data governance practices by implementing a solution-based approach. The project utilized various frameworks to anticipate and mitigate data loss during stages of data transfer, ensuring consistency between source and target datasets.Roles and Responsibilities:- Analyzed the flow of data between different stages, identifying potential points of data loss.- Designed and implemented a framework to capture record counts at each stage of data flow, providing visibility into data integrity.- Conducted thorough analysis of data at both source and target to ensure accuracy and reliability.- Developed stored procedures to run at scheduled intervals, capturing real-time data counts across stages.- Utilized Python for executing SQL queries on different environments and dynamic SQL coding to adapt to changing requirements.- Implemented stored procedures for real-time execution, ensuring timely data monitoring.- Conducted unit testing to validate the functionality of implemented solutions.- Participated in daily stand-up meetings, providing updates on project progress.- Managed team activities including knowledge transfer and mentoring, fostering collaboration and skill development.- Engaged in daily regression runs and provided support for production issues, performing data analysis and resolution as needed.Overall, the project focused on enhancing data governance practices through proactive monitoring and mitigation of data loss, ensuring the reliability and integrity of Albertsons' data assets.

Worked as a Jr. Data Engineer on the project undertaken by Cognizant for Albertsons Clint which focused on Data Governance, spanning from December 2021 to April 2022. As a DataEngineer the role involved developing, implementing, testing and deploying business driven SQL Rules using a suit of tools such as Snowflake, iCEDQ, Alation and Denodo. Roles and Responsiblities:- Developed SQL query tailored to cusrtomer requirements utilizing of various join operations.- Conducted in depth analysis of data integrity on various dimentions such as (Consistancy, Accuracy, Uniqueness, Completeness, Validity)- Enguaged in issue reporting and clarification process, including the identification and logginf of product - related Bugs.- Implemented SQL rules within Alation and iCEDQ platforms to enforce data governance policies and procedures.- Leveraged denodo to check data consistance between Source and Target system, ensuring data integrity throughout the process.Overall, the project focused on utilizing a combination of tools and SQL expertise to enhance data governance practices for Albertsons, enduring the reliablity and accuracy of their data assets.

Started my career as a SQL Developer in Maxpertise Technology Labs and later promoted as Snowflake developer effective from 01/04/2020. Finally served the organization for 1+ year in this role and concluded the work at the organization on 08/10/2021.