Demo

ETL Developer 1

IMRI Technology & Engineering Solutions
New York, NY Full Time
POSTED ON 2/7/2025
AVAILABLE BEFORE 5/5/2025

Job Description

Job Description

ETL Developer

Job Summary :

We are seeking a highly skilled ETL Developer to design, build, and maintain robust data pipelines and workflows for geographic and non-geographic data. The ideal candidate will have expertise in extracting, transforming, and loading data, integrating APIs, and optimizing data processes. This role involves collaboration with GIS analysts, developers, and business stakeholders to ensure data integrity, availability, and performance.

Key Responsibilities

Data Extraction and Transformation :

  • Extract geographic and non-geographic data from Oracle and SQL Server databases, ensuring data integrity and quality.
  • Transform raw data into structured formats suitable for analysis, reporting, and system integration.
  • Design and implement efficient data pipelines for handling large datasets.
  • Automate ETL integrations using SQL Server Integration Services (SSIS).
  • Perform data analysis to support key business objectives.

ETL Development and Maintenance :

  • Develop, test, and maintain ETL workflows and scripts to automate data processing.
  • Monitor ETL processes for reliability, scalability, and performance.
  • Document ETL processes, data models, and API specifications for transparency and knowledge sharing.
  • Troubleshoot and resolve data-related issues promptly.
  • Database and API Development :

  • Perform data modeling and database design to support application development and product implementation.
  • Create APIs for 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.
  • Collaboration and Technical Support :

  • Work closely with GIS analysts, developers, and stakeholders to understand data requirements.
  • Collaborate with business analysts and development teams during design, development, testing, and support phases.
  • Mentor and guide team members on database-related tasks.
  • Provide technical support and knowledge transition to team members and end users.
  • Performance Optimization and Best Practices :

  • Monitor and optimize database performance, scalability, and capacity utilization.
  • Ensure high availability and redundancy in database environments.
  • Follow best practices in data modeling, including naming conventions and standardized processes.
  • Define and implement data testing strategies in collaboration with stakeholders and QA teams.
  • Qualifications & Skills

    Required :

  • Bachelor’s degree in Computer Science, Information Systems, GIS, or a related field.
  • Minimum of 5 years of experience as an ETL Developer, Data Engineer, or similar role, with a focus on geographic data.
  • Proficiency in T-SQL and PL / SQL for Microsoft SQL Server, Oracle, and PostgreSQL databases.
  • Experience with SSRS, SSAS, and SSIS, as well as data warehousing concepts like ETL, dimensions, facts, and cubes.
  • Strong programming skills in Python, C#, or other relevant languages for ETL and API development.
  • Experience with API frameworks (e.g., Flask, FastAPI, Django REST Framework).
  • Familiarity with geographic data formats (e.g., shapefiles, GeoJSON) and geospatial tools (e.g., ArcGIS, QGIS).
  • Ability to write and optimize complex SQL queries, stored procedures, triggers, and functions.
  • Preferred :

  • Knowledge of ETL tools like Talend, Apache Nifi, or Informatica.
  • Experience with cloud platforms (e.g., AWS, Azure, GCP) and related data services.
  • Familiarity with application lifecycle management (ALM) tools such as Azure DevOps and GitHub.
  • ETL certifications on Microsoft SQL Server or Oracle.
  • IMRI offers top-tier benefits that include : medical coverage through nationally recognized carriers, ancillary coverages, paid vacation and sick leave in compliance with all state and local laws, 401(k) with company match, company paid life insurance and LTD, and several additional voluntary coverages.

    Pay will be commensurate with the experience, skills, and qualifications that the candidate brings to the position.

    EQUAL EMPLOYMENT OPPORTUNITY

    EEO / Affirmative Action Statement and Non-Discrimination Policy IMRI is an Equal Employment Opportunity employer committed to maintaining a non-discriminatory, diverse work environment. In accordance with Title VII of the Civil Rights Act of 1964, Section 503 of the Rehabilitation Act of 1973, Vietnam Era Veteran's Readjustment Assistance Act of 1974 (VEVRAA), Americans with Disabilities) (ADA), and other federal, state, and local anti-discrimination laws, IMRI does not unlawfully discriminate against any person on the basis of race, color, religion, sex, national origin, ancestry, genetic information, age, marital status, sexual orientation, physical or mental disability, or status as a special disabled veteran or other veteran. IMRI will take affirmative action to assure equal opportunity for employment is provided with regard to all personnel actions. This is including but not limited to : recruitment, selection, compensation, benefits, training, promotion, demotion, layoff, termination and all other terms and conditions of employment.

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a ETL Developer 1?

    Sign up to receive alerts about other jobs on the ETL Developer 1 career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $91,609 - $116,575
    Income Estimation: 
    $115,838 - $142,817
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $91,609 - $116,575
    Income Estimation: 
    $115,838 - $142,817
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $68,745 - $88,154
    Income Estimation: 
    $87,428 - $116,878
    Income Estimation: 
    $91,609 - $116,575
    Income Estimation: 
    $129,640 - $165,363
    Income Estimation: 
    $151,182 - $194,086
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $129,640 - $165,363
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at IMRI Technology & Engineering Solutions

    IMRI Technology & Engineering Solutions
    Hired Organization Address Sacramento, CA Full Time
    Senior Project Manager – Sacramento, CA Location : Sacramento, California Industry : Information Technology Certificatio...

    Not the job you're looking for? Here are some other ETL Developer 1 jobs in the New York, NY area that may be a better fit.

    ETL Developer

    Princeton IT Services, New York, NY

    ETL Developer

    Eclaro, White Plains, NY

    AI Assistant is available now!

    Feel free to start your new journey!