LiveEnd-to-End Automated Geospatial ETL Pipeline for Power Line Data (Apache NiFi + PostGIS)
Designed and deployed a streaming batch geospatial ETL pipeline using Apache NiFi to automate ingestion, transformation, and loading of GeoJSON power line data into PostgreSQL/PostGIS. Engineered data validation and regex-based transformation workflows to handle malformed and semi-structured inputs, improving data quality and reliability to ensure reliable storage of LineString geometries for scalable spatial analysis.
