fix: resolve env path and respect dependency overrides in lifespan

feat: adding full working local ETL Pipeline