GIS ETL Developer Job at TechNix LLC, New York, NY

RmdDQmhQVFFxZlhrbU9YSWFPdWlEeEVWblE9PQ==
  • TechNix LLC
  • New York, NY

Job Description

Position: GIS ETL Developer

Duration: 1 year

Location: New York NY

Job Description:

Provide an ETL (Extract Transform Load) Developer (Consultant) who has significant experience in software system development projects and software development lifecycle (SDLC) practices and specializes in geographic data transformations to perform data extractions and transformations between Oracle Microsoft SQL Server and PostgreSQL databases and create APIs and data pipelines to enable data integration and accessibility for the Geosupport Linear Integrated Ordered Network (LION) ETL Redesign . The ideal candidate will play a critical role in designing developing and maintaining ETL processes across heterogeneous database platforms onpremise and in the cloud and will work closely with crossfunctional teams to ensure data accuracy consistency and availability for geospatial applications and services.

SCOPE OF SERVICES

  • Extract geographic and nongeographic data from Oracle and SQL Server databases ensuring the integrity and quality of the data.
  • Transform raw data into structured formats suitable for analysis reporting and system integration.
  • Design and implement data pipelines for efficient handling of large datasets.
  • Automate ETL integrations using SQL Server Integration Services (SSIS).
  • Perform data analysis to drive key business objectives.
  • Document ETL processes data models and API specifications for transparency and knowledge sharing.
  • Develop test and maintain ETL workflows and scripts to automate data processing.
  • Monitor ETL processes to ensure reliability scalability and performance.
  • Perform data modeling and database design for application development and product implementation initiatives under the guidance of Database Administrator and Architect.
  • Create reporting solutions using SQL Server Reporting Services (SSRS) by analyzing user needs and information availability.
  • Troubleshoot and resolve datarelated issues promptly.
  • Create APIs to enable data access and integration with various applications and systems.
  • Ensure APIs are secure performant and adhere to industry standards.
  • Collaborate with developers and analysts to design API endpoints that meet business requirements.
  • Work with GIS analysts developers and stakeholders to understand data requirements.
  • Participate in requirements definition analysis and design.
  • Work closely with business analysts subject matter experts and development teams in design development testing implementation and support of application projects.
  • Facilitate creation migration and maintenance of database objects across development/QA/production environments.
  • Follow best practices in data modeling including use of standard naming conventions processes and templates to ensure consistency of data models.
  • Monitor and optimize database performance and capacity utilization to provide high availability and redundancy.
  • Take ownership of database performance scalability and security.
  • Define and implement data testing strategies with business stakeholders application development teams and QA groups.
  • Participate in the software testing process including identification and resolution of defects.
  • Contribute to and support rollout strategies.
  • Participate in and contribute to formal/informal technical reviews and presentations.
  • Accurately estimate time required to complete development tasks.
  • Demonstrate the ability to cooperate with a variety of people and achieve results.
  • Mentor and guide development team members on databaserelated tasks.
  • Provide technical support and knowledge transition to team members and end users as needed

Vendors Minimum Requirements:

  • Minimum of five (5) years prior experience providing professional technology staffing services.
  • Consultants should be able to work in person at Broadway 30th Floor New York NY 10271 complying with New York City and policies.
  • The consultant cannot work more than 35 hours per week.

DESIRABLE SKILLS/EXPERIENCE: Note: candidates who do not have the required skills will not be considered.

The selected candidate must have excellent verbal and written communication skills and have the ability to interact professionally with a diverse group including executives managers and

subject matter experts. The candidate should be a team player.

Job Tags

Similar Jobs

KBS - Kellermeyer Bergensons Services, LLC

Janitorial Crew Member Job at KBS - Kellermeyer Bergensons Services, LLC

 ...oportunidad inmediata para unirse a nuestro equipo de servicios de limpieza como miembro del equipo . Si busca un horario flexible para...  ...oportunidades de liderazgo en un entorno dinmico, este es el trabajo ideal para usted! Acerca de KBS Kellermeyer Bergensons... 

Metro Honda

PARTS DRIVER Job at Metro Honda

 ...As a driver you will me making deliveries to body shops and mechanical repair shops. Some of the Responsibilities will include: # Loading and unloading of delivery vehicle without assistance. # Responsibility to match part numbers on invoice with correct items being... 

Luxury Bath Technologies

Call Center Representative Job at Luxury Bath Technologies

 ...Call Center Representative Luxury Bathis one of the fastest growing brands in the acrylic bath remodeling industry. We are looking...  ...experience, customer service experience, be available to work evenings and weekends, and be able to resolve conflicts and issues. Base... 

State of Iowa Talent Gateway

Education Program Consultant (Continuous Improvement) Heartland Job at State of Iowa Talent Gateway

 ...Job Description Iowa Department of Educations mission is ensuring all students experience a world-class education. To accomplish...  ...to achieve their full potential. The Education Program Consultant (Continuous Improvement) will be an integral member of the... 

Crisis Connections, Inc.

Domestic Violence Victim Advocacy Services offered by King County Prosecuting Attorney in Seattle Job at Crisis Connections, Inc.

 ...Domestic Violence Victim Advocacy Services offered by King County Prosecuting Attorney in Seattle 516 3rd Avenue, King County Courthouse, #W-554, Seattle, WA 98104 Located in downtown Seattle on 3rd Ave between Jefferson & James. Call King County Metro at (206) 553...