Abstract <p>In short-baseline experiments such as LSND and MiniBooNE, an excess of electron neutrinos has been observed, originating from a muon neutrino beam. To address this anomaly, in the line of many works, we investigate various neutrino mixing schemes involving eV-scale sterile neutrinos alongside three active neutrinos. Using updated experimental and global fit data, we studied neutrinoless double beta decay for three different schemes such as 3 + 1, 1 + 3, and 2 + 2, which involve one sterile neutrino and three active neutrinos. We have done analysis of these schemes for normal hierarchy (NH) as well as for inverted hierarchy (IH) frameworks, and constrained the sterile neutrino mass in light of current and future neutrinoless double beta decay experiments. The 3 + 1 scheme is found to be the most viable and at the level of <InlineEquation ID="IEq1"> <EquationSource Format="TEX">\(3\sigma \)</EquationSource> <!--PhysPNLt2570151Priya-m1--> </InlineEquation> the mass of sterile neutrino with respect to the lightest neutrino mass (<InlineEquation ID="IEq2"> <EquationSource Format="TEX">\({{m}_{{{\text{lightest}}}}}\)</EquationSource> <!--PhysPNLt2570151Priya-m2--> </InlineEquation>) is restricted to 4.75 eV for the NH and 4.72 eV for the IH. Additionally, the limits on the sum of four neutrino masses squared are determined to be 4.81 eV² for the normal hierarchy and 4.78 eV² for the inverted hierarchy. The updated analysis of all these schemes would help us in understanding physics governing neutrinoless double beta decay and limit on the mass of sterile neutrinos.</p>