Data Warehouse ETL Specialist

2 weeks ago


Purchase, New York, United States Ampcus Full time

**Job Title:** Data Warehouse ETL Specialist

We are seeking an experienced ETL specialist to join our team at Ampcus. As a key member of our data warehouse team, you will be responsible for developing and supporting ETL code in Informatica PowerCenter.

Salary: $120,000 - $180,000 per year

Company Overview

Ampcus is a leading provider of technology solutions. We offer a dynamic and challenging work environment that allows our employees to grow and develop their skills.

Job Description

The ETL specialist will be primarily responsible for developing and supporting ETL code in Informatica PowerCenter for an enterprise data warehouse.

  • Develop new ETL and enhancements and modify existing code using Informatica PowerCenter.
  • Work independently to develop, configure, and unit test programs from specs (source to target mappings).

Role Responsibilities

  1. Design and document ETL solutions for projects, estimate work effort, and provide status of tasks.
  2. Provide technical support for the administration and production support of Informatica.
  3. Present all work in design and code review sessions to senior team members.
  4. Prepare documents that describe and support code developed.
  5. Identify improvements to the data warehouse environment. Work with the team to implement these solutions.
  6. Escalate issues to the right party when required.
Required Skills and Qualifications
  • 5+ years of hands-on experience in ETL development for a data warehouse.
  • 5+ years of hands-on experience in development, maintenance, and enhancements of Informatica Mappings, Workflows, and processes.
  • Expertise with integration technologies and processes.
  • Experience working with complex SQL.


  • Purchase, New York, United States Damco Solutions Full time

    Data Warehouse Solutions Expert Wanted!We're looking for an experienced Data Warehouse Solutions Expert to join our team at Damco Solutions. As a key member of our team, you'll be responsible for designing, implementing, and maintaining data warehouses that meet the needs of our clients.Key Responsibilities:Design and implement data warehouses using...


  • Purchase, New York, United States Ampcus Full time

    About AmpcusAmpcus is a leading provider of data analytics solutions, and we are currently seeking a skilled Data Warehouse Specialist to join our team.


  • Purchase, New York, United States Damco Solutions Full time

    InsurTech Data Analyst Job OpeningDamco Solutions is seeking an InsurTech Data Analyst to join our team. As an InsurTech Data Analyst, you will play a critical role in helping us drive business growth through data-driven insights.Key Responsibilities:Extract OLTP data specifically for a data warehouseWork with Guidewire Policy center to develop and maintain...


  • Purchase, New York, United States Ampcus Full time

    **Job Title:** PowerCenter Development ExpertWe are seeking an experienced PowerCenter developer to join our team at Ampcus. As a key member of our data warehouse team, you will be responsible for developing and supporting ETL code in Informatica PowerCenter.Salary: $120,000 - $180,000 per yearCompany OverviewAmpcus is a leading provider of technology...


  • Purchase, New York, United States Ampcus Full time

    **Job Title:** Informatica Developer PositionWe are seeking an experienced Informatica Developer to join our team at Ampcus. As a key member of our data warehouse team, you will be responsible for developing and supporting ETL code in Informatica PowerCenter.Salary: $120,000 - $180,000 per yearCompany OverviewAmpcus is a leading provider of technology...


  • Purchase, New York, United States Ampcus Full time

    The RoleAs a Business Intelligence Developer at Ampcus, you will be responsible for designing, implementing, and maintaining data warehousing solutions that meet the needs of our clients. You will work closely with business stakeholders and IT teams to analyze and resolve data issues, create source-to-target mapping documents, and load data into the...


  • Purchase, New York, United States Crossover Health Full time

    Job OverviewCrossover Health, a leader in innovative primary care, seeks an onsite Nurse Practitioner to join our team at the Pepsico Primary Care Clinic in Purchase, NY. This is an exciting opportunity for a motivated and experienced healthcare professional to provide high-quality patient-centered care in a dynamic environment.About Crossover HealthWe are a...

  • Sr Data Analyst

    5 months ago


    Purchase, United States Damco Solutions Full time

    Title : Sr Data Analyst (Data Warehouse) Location : Purchase, NY or Florham Park, NJ; (Day 1 onsite with Hybrid model)Required skills: Guidewire Policy center Datawarehouse Informatica TECHNICAL QUALIFICATIONS 10 + years of data analysis experience extracting OLTP data specifically for a data warehouse 5 + years P&C Insurance subject matter experience...


  • Purchase, United States Ampcus Full time

    Data Warehouse Support Analyst - Long Term Contract Must have Strong SQL Hybrid Role on site Tues, Wed and Thurs in any of the following locations Conshohocken, PA; Florham Park, NJ; New York, NY; Purchase, NYThe DataWarehosue Support Data Analyst is a hands-on position with a focus on supporting the data accuracy and completeness within the enterprise data...


  • Purchase, United States Vimerse Infotech, Inc. Full time

    Production Support Data Analyst Onshore - SI Office Preferred Locations: Purchase, NY; Morristown, NJ Acceptable Offices: Charlotte, NC; Chicago, IL; Colorado Springs, CO; Dallas, TX; Fargo, ND; Garden City, NY; Houston, TX; Jacksonville, IL; Lenexa, KS; Lubbock, TX; Mt Juliet, TN; New York, NY; Topeka, KSThe Production Support Data Analyst is a hands-on...

  • Informatica Developer

    1 month ago


    Purchase, United States Ampcus Full time

    Informatica DeveloperHybrid Schedule/Partial Remote: Candidate must be willing to work in the office three days per week (Tuesday, Wednesday, Thursday) in one of the following locations: Alpharetta, GA; Boston, MA; Charlotte, NC; Chicago, IL; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Florham Park, NJ; Jacksonville, IL; Lenexa, KS; Lubbock, TX; Mt...