ETL Developer 1

2 weeks ago

New York, United States IMRI Full time

ETL Developer 1

Apply Now

Back to search

Location: New York, New York

Posted: 12/10/2024

Location Name: New York

Wage Max: 135,000.00

Wage Min: 900,000.00

COMPANY OVERVIEW

Join our award-winning team at Information Management Resources, Inc. (IMRI), a small business leader in the technology industry known for our commitment to innovation, excellence, and authenticity. Founded in 1992, IMRI has been at the forefront of delivering advanced cybersecurity and IT solutions, safeguarding organizations against evolving threats. We have built a reputation for our expertise in Cybersecurity, Digital Transformation, Strategic Business Consulting, and Staff Augmentation. Guided by our core values of innovation, excellence, and a solution-driven mindset, we have served a diverse portfolio of customers that includes federal agencies, state and local governments, and Fortune 1000 companies.

At IMRI, we recognize the integral part our employees play in our ongoing success. To support this, we offer a comprehensive benefits package, tailored to meet the individual needs of our employees. We are committed to promoting their overall well-being and equipping them with the necessary tools to flourish in their careers. We welcome you to be a part of our ongoing mission as we continue to navigate the digital landscape, committed to empowering organizations with our innovative solutions.

ETL Developer

Job Summary:

We are seeking a highly skilledETL Developerto 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.

Apply Now

  • ETL Developer

    2 weeks ago

    New York, United States Avispa Technology Full time

    ETL Developer 321-1 A leading music streaming company is seeking an ETL Developer. The successful candidate will be responsible for designing, developing, and maintaining extract, Transform, load (ETL) processes to support the data warehousing and business intelligence needs of our audio entertainment company. This role will focus on efficiently gathering...

  • ETL Developer Senior

    3 days ago

    New York, New York, United States IMRI Full time

    Job Description:We are seeking a highly skilled ETL Developer Senior to join our team at IMRI. In this role, you will play a critical part in managing and optimizing the data infrastructure that supports critical business and geographic information system (GIS) initiatives.Your primary responsibilities will include designing, implementing, and maintaining...

  • SQL Server ETL Developer

    3 weeks ago

    New York, New York, United States Synechron Full time

    We are seeking an experienced ETL Developer with expertise in SQL Server and Informatica to support our data warehousing and analytics initiatives. As a key member of our team, you will be responsible for designing, developing, and maintaining ETL processes to ensure efficient data integration and transformation.Responsibilities:Design and implement ETL...

  • ETL Developer 2

    2 weeks ago

    New York, United States IMRI Full time

    ETL Developer 2 Apply Now! Back to search Location: New York, New York Posted: 12/10/2024 Location Name: New York Wage Max: 135,000.00 Wage Min: 100,000.00 COMPANY OVERVIEW Join our award-winning team at Information Management Resources, Inc. (IMRI), a small business leader in the technology industry known for our commitment to innovation, excellence, and...

  • ETL Developer for Data Integration

    3 days ago

    New York, New York, United States Synechron Full time

    At Synechron, we are seeking a skilled ETL Developer to join our team. As an ETL Developer, you will be responsible for designing, developing, and maintaining ETL processes using Informatica to extract data from various sources, transform it, and load it into SQL Server data warehouses.About the RoleThe ideal candidate will have extensive experience in SQL...

  • AWS ETL Developer

    7 months ago

    New York, United States Velocity Search Group Inc Full time

    AWS, Snowflake Data Warehouse ETL Developer Company : Leading Health Care Services Organization Location : Fully Remote (must work East Coast hours),New York City or...

  • Python Developer for ETL Processes

    3 weeks ago

    New York, New York, United States The Cypress Group Full time

    About the RoleWe are seeking a skilled Python/SQL Developer to join our team as an ETL Scripter. In this role, you will be responsible for developing and maintaining Python/SQL scripts for data extraction, transformation, and loading (ETL) processes.You will build data pipelines to support daily and weekly reporting requirements for account data, collaborate...

  • Senior ETL QA Developer

    3 days ago

    New York, New York, United States Resource Informatics Group Full time

    Join Resource Informatics Group as a Senior ETL QA Developer and play a critical role in ensuring the quality of our data processing pipelines on Amazon Web Services (AWS). In this position, you will be responsible for designing, developing, and deploying automated tests for ETL processes and data warehouse testing.The ideal candidate will have at least 10...

  • SQL Server

    2 months ago

    New York, United States Synechron Full time

    We are At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron's progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps,...

  • Data Engineer

    3 days ago

    New York, New York, United States CapB InfoteK Full time

    Job DescriptionThe Senior ETL Architect Hadoop will be responsible for designing, developing and implementing highly efficient and scalable ETL processes. The candidate is required to perform daily project functions with a focus on meeting the business objectives on time in a rapidly changing work environment.Key Responsibilities:Lead and drive globally...

  • AWS ETL Data Warehouse Developer

    3 weeks ago

    New York, United States Velocity Search Group Full time

    WS ETL Developer Our Client a leading Healthcare services organization is seeking a full time AWS ETL Developer to join their team. This is a remote position but the candidate must be located on the east coast. Responsibilities : Design and develop solutions using AWS Glue or Boomi, Snowflake, Salesforce CRM, Salesforce Service Cloud, and GitHub...

  • ETL Expert

    3 weeks ago

    New York, United States Actus Consulting Group Full time

    Job DescriptionJob DescriptionJapanese IT solution service company is seeking a ETL expert=============================Summary of DutiesA professional capable of independently driving the entire ETL project lifecycle, including requirements gathering, development, and testing.ResponsibilitiesMaintain and enhance systems using ETL tools.Organize user...

  • Senior ETL Developer for Data Warehouse

    3 days ago

    New York, New York, United States The Dignify Solutions LLC Full time

    The Dignify Solutions LLC is committed to delivering high-quality data integration solutions. We are currently seeking a senior-level ETL Developer for Data Warehouse to join our team.Estimated Salary: $180,000 - $250,000 per year, depending on location and experience.About the Job:We require a candidate with 10+ years of hands-on experience in ETL...

  • ETL Solutions Architect

    2 weeks ago

    New York, New York, United States Tata Consultancy Services Full time

    Job Title: ETL Solutions ArchitectWe are seeking an experienced ETL Solutions Architect to join our team at Tata Consultancy Services.Estimated Salary: $130,000 - $155,000 per year.Job Description:Job SummaryThis role involves designing, developing, and implementing ETL solutions using Informatica PowerCenter.Key ResponsibilitiesThe successful candidate will...

  • ETL Specialist Lead

    4 days ago

    New York, New York, United States Fidelity Information Services Full time

    About the OpportunityWe are seeking an experienced ETL Specialist to join our team at Fidelity Information Services. As a key member of our team, you will be responsible for designing, implementing, and maintaining large-scale data integration solutions using DataStage v11.x. If you have a passion for ETL development and testing, and are looking for a...

  • Sr. QA ETL Tester

    1 week ago

    New York, United States VTal Technology Solutions Full time

    Seeking a highly motivated and experienced Sr. QA ETL Tester for a hybrid contract role with a leading insurance firm in NYC or Jersey City. In this role, you will play a crucial part in ensuring the quality and integrity of data warehousing and ETL processes. You will be responsible for developing and executing test plans, analyzing test results, and...

  • Senior ETL Architect Hadoop

    3 days ago

    New York, New York, United States CapB InfoteK Full time

    Job SummaryThe Senior ETL Architect Hadoop will be responsible for designing, developing and implementing highly efficient and scalable ETL processes. The candidate is required to have strong knowledge of working with relational databases like Teradata DB2 Oracle SQL Server and experience in data warehousing ETL tools MPP database systems.About the Job:Lead...

  • ETL Testing Expert

    3 days ago

    New York, New York, United States Fidelity Information Services Full time

    Job Description: As an ETL Testing Expert at Fidelity Information Services, you will play a crucial role in ensuring the quality and integrity of data across various systems and applications. Your primary responsibilities will include creating and maintaining processes for quality assurance, consulting on software development or operations processes, quality...

  • ETL Testing Specialist AWS

    4 days ago

    New York, New York, United States Resource Informatics Group Full time

    Are you a highly skilled ETL testing specialist looking for a new challenge? We're seeking an experienced professional to join our team as an ETL Testing Specialist AWS. In this role, you will be responsible for testing and validating our data processing pipelines on Amazon Web Services (AWS).The ideal candidate will have at least 8 years of Quality...

  • CloudBC Labs ETL Solutions Specialist

    3 days ago

    New York, New York, United States CloudBC Labs Full time

    About the Role">The Senior Data Warehouse Architect will be responsible for designing and implementing ETL solutions using Informatica PowerCenter. This role requires strong technical skills, leadership experience, and excellent communication skills.">Responsibilities">Develop new ETL and enhancements and modify existing code using Informatica...