Job Description :

Job Details

Job Title: ETL Developer

Project Scope & Responsibilities

ETL & Data Engineering

  • Extract geographic and non-geographic data from Oracle and SQL Server databases while ensuring high data quality.

  • Transform raw data into structured formats suitable for analysis, reporting, and system integration.

  • Design and implement data pipelines for efficient processing of large datasets.

  • Automate ETL workflows using SSIS and other automation tools.

  • Develop, test, and maintain ETL processes and scripts for data processing and integration.

  • Monitor ETL jobs for reliability, scalability, and performance.

  • Perform data modeling and database design under guidance from senior database architects.

  • Conduct data analysis to support business objectives and geospatial applications.

API & Integration Development

  • Create APIs to enable secure and performant data access across applications.

  • Ensure API interfaces meet industry standards and align with business requirements.

  • Collaborate with developers/analysts to define API endpoints and integration workflows.

Reporting & Analytics

  • Develop reporting solutions using SSRS based on user needs.

  • Create and maintain database objects across development, QA, and production environments.

  • Follow best practices in data modeling naming standards, documentation, templates, etc.

  • Monitor and optimize database performance, ensuring security, scalability, and high availability.

Collaboration & Project Support

  • Work closely with GIS analysts, developers, business analysts, and subject matter experts.

  • Support all SDLC phases including requirements, design, development, testing, implementation, and post-production support.

  • Participate in code reviews, technical discussions, and presentations.

  • Accurately estimate task timelines and deliver work in a timely manner.

  • Troubleshoot complex data-related issues and support release strategies.

  • Contribute to application testing processes and assist in defect resolution

    We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.

             

Similar Jobs you may be interested in ..