Senior Data Integration Engineer (Informatica Cloud)

United States Digital Space LLC; United States; Hybrid; USD 140,000 - 180,000; Full time

Job summary

United States Digital Space LLC is seeking a senior data integration engineer to deliver end-to-end data integration and analytics solutions using Informatica Cloud, scalable cloud data warehouses, and GenAI-enabled tooling.

You will design robust ETL workflows, optimize SQL, build dimensional models, and collaborate with product owners and analysts in a hybrid work environment to accelerate insights while ensuring data quality and governance.

Qualifications

• Extensive experience in Informatica Cloud development including mappings, tasks, and CLI usage.
• Proficiency in ETL design, data profiling, data quality, and performance optimization for large datasets.
• Advanced SQL skills: joins, window functions, and debugging on cloud data warehouses.
• Experience with Snowflake, BigQuery, or Amazon Redshift and dimensional modeling.
• GenAI basics applied safely for documentation and pattern exploration per governance.
• 7–10 years of data engineering or integration development experience.
• Strong communication in hybrid/remote collaboration and cross-functional teams.

Responsibilities

• Design and implement robust ETL workflows using Informatica Cloud.
• Develop and optimize mappings, tasks, and parameterized jobs for automated deployments.
• Optimize SQL queries to improve performance and reduce compute costs.
• Build scalable cloud data warehouse models with fact and dimension tables.
• Apply GenAI capabilities to accelerate development while ensuring governance.
• Collaborate with product owners, data architects, and analysts to translate requirements.
• Conduct thorough testing and monitoring of ETL pipelines and data loads.
• Document integration flows and runbooks for onboarding in hybrid work model.
• Provide guidance to peers on Informatica Cloud patterns and SQL tuning.
• Engage in agile ceremonies and deliver increments with measurable value.
• Coordinate with security to implement data protection and access controls.
• Evaluate new Informatica Cloud capabilities and GenAI tooling for improvements.

Skills

Informatica Cloud

ETL design

SQL optimization

GenAI basics

Data modeling

Tools

Informatica Cloud CLI

Snowflake

BigQuery

Amazon Redshift

Job description

United States Digital Space LLC is seeking a senior data integration engineer to deliver end-to-end data integration and analytics solutions using Informatica Cloud, scalable cloud data warehouses, and GenAI-enabled tooling.

You will design robust ETL workflows, optimize SQL, build dimensional models, and collaborate with product owners and analysts in a hybrid work environment to accelerate insights while ensuring data quality and governance.