Data Integration Engineer II - Informatica (ETL/ELT)

Weill Cornell Medicine; New York (NY); On-site; USD 130,000 - 143,000; Full time

Job summary

Weill Cornell Medicine is seeking a Data Integration Engineer II- Informatica (CEMI) for a 2-year term appointment located at Midtown, NYC. The role focuses on designing, developing, and maintaining data integration pipelines across enterprise systems and cloud platforms to support analytics and reporting.

The candidate should have 8–10 years of hands-on data integration experience, proficiency with SAP BW/BODS and cloud data warehouses, and strong SQL skills along with excellent communication

Qualifications

• Bachelor's degree in Computer Science or related field preferred.
• Equivalent work experience will be considered.
• Minimum 8–10 years of hands-on data integration/engineering experience.
• Experience with SAP data platforms and cloud data warehouses.
• Strong SQL development skills including queries, scripting, and stored procedures.

Responsibilities

• Design and develop ETL/ELT pipelines to integrate data from multiple source systems into enterprise data platforms.
• Build and maintain backend data models to support reporting and analytics.
• Develop and optimize data movement using SAP BODS, Informatica, and cloud-native services.
• Support SAP BW and cloud environments such as Amazon Redshift.
• Perform data transformation, cleansing, and validation for data quality and integrity.
• Monitor, schedule, and troubleshoot batch jobs and data pipelines.
• Collaborate with analysts and developers to translate requirements into technical data solutions.
• Document data flows, data models, and technical specifications for maintainability and governance.
• Provide support for production issues and participate in system enhancements.

Skills

SQL

Data modeling

ETL/ELT

Analytical thinking

Communication

Education

Bachelor's degree in CS or related field

Equivalent work experience considered

Tools

SAP BW

SAP BODS

Informatica

Amazon Redshift

Job description

Weill Cornell Medicine is seeking a Data Integration Engineer II- Informatica (CEMI) for a 2-year term appointment located at Midtown, NYC. The role focuses on designing, developing, and maintaining data integration pipelines across enterprise systems and cloud platforms to support analytics and reporting.

The candidate should have 8–10 years of hands-on data integration experience, proficiency with SAP BW/BODS and cloud data warehouses, and strong SQL skills along with excellent communication