Informatica Cloud Data Integration

Informatica Cloud Data Integration Engineer Jobs

2 jobs found

6d ago

Sr Cloud Data and AI Engineer

The Hartford Columbus, OH

Columbus, OH

6d ago

$117k - $176k/yr Full time Agentic Ai Ai Agent Ai Agent Platform

Apply Now

Job Description

The Hartford is seeking a Senior Cloud Data and AI Engineer to design scalable cloud data solutions and apply AI and automation capabilities that help accelerate Employer Benefits actuarial insights and improve operational efficiency. The role combines technical leadership, customer collaboration, and delivery of modern data and AI capabilities.

Location and Work Arrangement

Location: Columbus, OH
Work model: Full time, Hybrid or Remote
Office expectation: Candidates near an office location are expected to work in the office 3 days per week (Tuesday through Thursday). Candidates not near an office will maintain the current work arrangement, with the expectation of coming into the office as business needs arise.

Job Ref: R2627133-174

Category: Data & Analytics

Employment Type: Full time

Key Responsibilities

Continuously engage in education and act as a technical expert across Informatica IDMC, Snowflake, AI and Generative AI platforms, cloud-native data services, CI/CD tooling, environment management, Oracle, metadata-driven architectures, and enterprise data quality processes.
Evaluate, prototype, and operationalize emerging AI technologies, including Generative AI, Agentic AI workflows, Retrieval Augmented Generation (RAG), and Model Context Protocol (MCP)-based integrations.
Design and develop scalable data solutions that support pricing and reserving activities for the Employer Benefits Actuarial team.
Synthesize, reconcile, and explain differences between GB actuarial outputs and other standard published data.
Develop deep understanding of actuarial applications, data elements, and business processes.
Collaborate with Actuarial customers during current financial month close to address time-sensitive issues while ensuring strategic solutions are planned for the next release cycle.
Provide technical leadership and mentorship to junior engineers, fostering collaboration across onshore and offshore teams to deliver innovative, scalable, and sustainable data solutions.
Discover, analyze, and integrate data from diverse sources to enable informed decision-making and support mission-critical business processes.
Consult with cross-functional partners to understand business needs and build solutions that are reliable, effective, and maintainable.
Work directly with customers to understand requirements and deliver solutions aligned to those needs.
Develop and maintain scalable data pipelines and ETL processes supporting insurance processing, actuarial analysis, and reporting.
Use Enterprise GitHub for version control, documentation, code collaboration, and technical project management.
Research, evaluate, and champion modern data technologies, frameworks, and best practices to drive operational excellence and accelerate data-driven innovation within agile delivery approaches, partnering to enhance enterprise data assets and capabilities.

Required Qualifications

Bachelor’s degree with at least 7 years of applicable work experience.
Required experience with Snowflake, IDMC, Informatica, and Oracle.
Hands-on experience with AI-assisted engineering tools, including Snowflake Cortex and Agentic AI capabilities; Generative AI platforms; Model Context Protocol (MCP); cloud-based AI services; and intelligent automation frameworks.
Experience building AI-powered self-service analytics, intelligent data catalogs, automated reconciliation frameworks, or knowledge management solutions.
Demonstrated passion for continuous learning in Artificial Intelligence, cloud architecture, automation, and emerging technologies.
Experience with CI/CD, GitHub, Autosys, and SQL.
7+ years experience in ETL, data analysis, or warehouse technologies.
Strong data warehouse knowledge, preferably within the insurance domain, with demonstrated expertise in data analysis, data quality, and reconciliation processes.
Strong experience with Python, R, and other modern languages, including building APIs, automation frameworks, AI-driven applications, and cloud-native data services.
Experience modernizing data pipelines from on-premises to cloud to leverage full cloud capabilities.
Experience in Agile and Kanban methodologies.

Preferred Qualifications

Group Benefits business knowledge is a plus.
Knowledge of AWS and cloud-based data solutions is a plus.

Compensation

Annual base pay range: USD 117,200 - 175,800
Note: Actual base pay may vary based on performance, proficiency, and demonstrated competencies required for the role.

Work Eligibility

Candidate must be authorized to work in the US without company sponsorship.
The company will not support the STEM OPT I-983 Training Plan endorsement for this position.

Relevant Technologies

Informatica IDMC, Informatica
Snowflake, Snowflake Cortex
AI, Generative AI
Cloud-native data services
CI/CD tooling, environment management
Oracle
Metadata-driven architectures
Enterprise data quality processes
Agentic AI workflows
Retrieval Augmented Generation (RAG)
Model Context Protocol (MCP)
Intelligent automation frameworks
AI-powered self-service analytics, intelligent data catalogs
Automated reconciliation frameworks, knowledge management solutions
GitHub, Autosys, SQL
Python, R, APIs
AWS
Agile, Kanban
ETL, data pipelines

View full job page →

1mo ago

Informatica and Snowflake Data Engineer

SMART TECH SKILLS LLC Tallahassee, FL

Tallahassee, FL

1mo ago Closed

Full time Business Systems Cloud Cloud Data Engineering

This position is no longer accepting applications (closed Oct 20, 2026).

Job Description

SMART TECH SKILLS LLC is hiring a Senior Informatica and Snowflake Data Engineer to design, build, and support enterprise data integration solutions. This hybrid role in Tallahassee, FL focuses on Informatica-based ETL/ELT development, Oracle SQL/PL-SQL performance tuning, Snowflake data loading and optimization, and hands-on production support for critical pipelines.

Role Overview

You will own ETL workflow development and maintenance using Informatica PowerCenter and Informatica Cloud Data Integration, while also delivering Oracle-based ingestion and query optimization. The work includes coordinating source-to-target mappings, documenting data flow and design specifications, and improving reliability and performance in production environments.

Responsibilities

Develop and maintain ETL workflows in Informatica PowerCenter, including mappings, sessions, workflows, and reusable transformations.
Ingest data from multiple heterogeneous sources (flat files, APIs, relational databases, and mainframe extracts) into Oracle databases.
Develop and support cloud-based ETL/ELT solutions using Informatica Cloud Data Integration.
Write and optimize Oracle SQL/PL-SQL, including stored procedures, packages, and performance tuning for ETL-related queries.
Load data into Snowflake, including support for schema design and query performance optimization.
Troubleshoot and resolve data quality issues, job failures, and performance bottlenecks in production ETL pipelines.
Gather data requirements, perform source-to-target mapping, and document data flow and design specifications.
Analyze user requirements and operational procedures to identify opportunities for automation or system improvement.
Support batch data loads using scheduling/orchestration tools such as Control-M, Autosys, or the Informatica scheduler.
Collaborate with business and technical stakeholders to deliver scalable data engineering solutions.
Confer with organizational units to analyze current procedures and define input/output and reporting requirements.

Requirements

8+ years experience as a Data Engineer/Systems Analyst designing, developing, and supporting data integration solutions in an enterprise environment.
8+ years hands-on experience developing and maintaining Informatica PowerCenter ETL workflows.
8+ years experience ingesting data from multiple heterogeneous sources into Oracle databases.
8+ years strong working knowledge of Oracle SQL/PL-SQL, including stored procedures, packages, and performance tuning.
8+ years experience with Snowflake, including data loading, schema design, and query performance optimization.
8+ years experience with Informatica PowerCenter and Informatica Cloud Data Integration for cloud-based ETL/ELT development.
8+ years experience gathering data requirements, performing source-to-target mapping, and documenting data flow/design specifications.
8+ years experience troubleshooting data quality issues, job failures, and performance bottlenecks in production ETL pipelines.
8+ years experience with job scheduling/orchestration tools for batch data loads (e.g., Control-M, Autosys, or Informatica scheduler).

Technologies

Informatica PowerCenter
Oracle SQL/PL-SQL
Oracle databases
Snowflake
Informatica Cloud Data Integration
Control-M
Autosys
Informatica scheduler
SAP Business Objects Universe

Benefits

Competitive salary

Location

Hybrid in Austin, TX

Location is also listed as Tallahassee, FL (hybrid).

Preferred Qualifications

Experience with SAP Business Objects Universe design and/or maintenance.
Experience working in a state government or large enterprise IT environment, following formal SDLC and change management processes.

Core Skills & Attributes

Strong analytical and problem-solving skills with a detail-oriented approach to data engineering.
Excellent written and verbal communication skills for engaging business and technical stakeholders.
Comfort working within structured SDLC environments and formal change management processes.
Strong troubleshooting mindset for production support and performance optimization.
Collaborative and adaptable, able to work effectively across business and technical teams.

View full job page →

Informatica Cloud Data Integration Engineer Jobs

Sr Cloud Data and AI Engineer

Informatica and Snowflake Data Engineer

Get Informatica Cloud Data Integration Engineer Jobs alerts