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 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 Description

Position Overview

We are seeking a skilled and detail-orientedETL Developerto join our team. This role is essential in managing and optimizing the data infrastructure that supports critical business and geographic information system (GIS) initiatives. The successful candidate will design, implement, and maintain ETL processes, APIs, and data pipelines, ensuring seamless integration and transformation of data for analysis, reporting, and application needs.

Key Responsibilities

Data Management and Transformation

  • Extract, transform, and load (ETL) geographic and non-geographic data from Oracle and SQL Server databases.

  • Ensure data integrity, quality, and consistency during processing.

  • Design and implement efficient data pipelines for handling large datasets.

  • Automate ETL processes using SQL Server Integration Services (SSIS) and related tools.

Data Analysis and Reporting

  • Perform data analysis to support organizational objectives and decision-making.

  • Create reporting solutions using SQL Server Reporting Services (SSRS) tailored to user needs.

  • Troubleshoot and resolve data-related issues promptly.

API and Integration Development

  • Develop secure, efficient APIs for data access and integration with various applications.

  • Collaborate with developers and analysts to design API endpoints that align with business requirements.

  • Ensure adherence to industry standards for API performance and security.

Database and Performance Optimization

  • Perform data modeling and database design for application development.

  • Monitor and optimize database performance, ensuring high availability and redundancy.

  • Follow best practices in database design and data modeling, maintaining consistency in standards and processes.

Collaboration and Support

  • Work closely with GIS analysts, developers, and stakeholders to understand and fulfill data requirements.

  • Provide technical guidance and mentoring to team members.

  • Document ETL processes, workflows, and API specifications to ensure knowledge sharing.

  • Facilitate the creation, migration, and maintenance of database objects across environments.

Required Qualifications and Skills

Education and Experience

  • 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.

Technical Proficiency

  • Strong expertise in T-SQL and PL/SQL with experience in Microsoft SQL Server, Oracle, and PostgreSQL databases.

  • Familiarity with SSIS, SSRS, SSAS, and data warehousing concepts, including ETL, dimensions, facts, and cubes.

  • Proficient in Python, C#, or similar programming languages for ETL and API development.

  • Knowledge of geographic data formats (e.g., shapefiles, GeoJSON) and GIS tools (e.g., ArcGIS, QGIS).

  • Experience with cloud platforms (e.g., AWS, Azure, GCP) and ETL tools like Talend, Apache Nifi, or Informatica.

  • Skilled in designing and integrating databases, data warehouses, and multidimensional databases.

Additional Skills

  • Familiarity with API frameworks such as Flask, FastAPI, or Django REST Framework.

  • Hands-on experience with version control and release management tools like Azure DevOps and GitHub.

  • Strong analytical and problem-solving skills with the ability to optimize complex SQL queries, stored procedures, and triggers.

  • Knowledge of data integration patterns and modeling principles.

Preferred Qualifications

  • Certifications in ETL tools (e.g., Microsoft SQL Server, Oracle).

  • Experience with code migration, database change management, and lifecycle management.

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...


  • 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...

  • 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...


  • 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...


  • 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...


  • 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...


  • 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...


  • 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...


  • 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...


  • 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...

  • SSRS (SQL Developer 2)

    7 months ago


    New York, United States PGMTEK Inc. Full time

    Job Description Looking for a SSRS developer with solid experience in data warehousing and ETL. This is a contractor assignment for an international financial services firm in NYC. 5 day work on-site is required. 10+ Years of experience as ETL developer with proficiency is the following technical skillset Optimize SSRS reports and queries for performance,...


  • New York, United States CoTalent Full time

    Senior Database Developer (Oracle, Datawarehouse, ETL)Asset ManagementNew York CityHybrid 3 days per week in office, 2 remotelyOur global investment management client with over $200 billion in assets, manages diverse equity and fixed-income strategies. The Investment Operations department supports the trade lifecycle across multiple divisions like...

  • 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...


  • 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...