ETL Developer 1
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.