Data Integration Engineer (IDMC)

Hi, this is Srikanth from Reliable Software. We have an opportunity with one of our direct clients, and I'd like to share the details with you. Please review the information below and let me know if you're interested. Kindly share your updated resume if you'd like to be considered.

Job Title: Data Integration Engineer (IDMC)

Location: Remote

Job description:

The Data Integration Engineer is a technical professional role responsible for designing, developing, and maintaining modern data pipelines on the Informatica Data Management Cloud (IDMC) platform. This role plays a critical part in enabling data ingestion, transformation, and integration in support of the company s cloud-first data architecture and enterprise data warehouse.

The engineer is accountable for implementing scalable and maintainable data workflows using IDMC's full suite of tools, including Mass Ingestion, Application Ingestion, Data Integration, and API Integration. The role supports both project-based and operational data movement requirements and ensures high-quality, well-documented, and reliable data flows across environments.

Success in this role requires hands-on IDMC expertise, strong SQL and Redshift familiarity, and a DevOps mindset for managing change and deployment across non-production and production environments. This role partners closely with the broader data services team and requires strong collaboration skills.

Qualifications:

• The functional / technical skills you must demonstrate include:
• Expertise in IDMC Data Integration components including Mass Ingestion, Application Ingestion, Taskflows, and API-based integration.
• Expert understanding of cloud architecture.
• Expertise in engineering, optimizing and troubleshooting ETL solutions at scale.
• Advanced proficiency in translating business requirements into scalable technical solutions.
• Strong problem-solving and debugging skills for resolving data pipeline and performance issues.
• Proficiency with Redshift and PostgreSQL, including hands-on experience with DDL/DML, table creation, and stored procedures.
• Proficiency with DevOps practices for data (e.g., version control, deployment pipelines).
• Excellent verbal and written communication skills for interacting with both technical teams and business stakeholders.
• Excellent time management.

Experience

• 12+ years of experience in ETL development.
• 8+ years of experience in ETL development using Informatica PowerCenter or Informatica Data Management Cloud (IDMC).
• 8+ years of direct experience with AWS products, preferably Redshift.
• 7+ years of direct experience with DevOps tools and practices (e.g., Git, CI/CD, automated deployments).

Experience with RESTful services, JMS messaging, or other integration patterns (SOA, EDA).

• Experience working in the property & casualty insurance industry or other regulated industries with compliance requirements (e.g., SOX, audit)

Educational Qualifications:

• Required - Bachelor s degree in Computer Science, Information Technology, Computer Engineering or closely related or equivalent.
• Preferred - Master s degree in Management Information Systems (MIS), Computer Science, Big Data or Analytics or equivalent.

Travel:

• Open to travel based-up on the nature of the engagement.

Thanks & Regards

Srikanth Donkani

Lead Talent Acquisition Specialist

(w):

(E):

;/p>

2260 Haggerty Road, Suite 285 Northville, MI 48167

Equal Employment Opportunity

Reliable Software employment does not discriminate on the basis of race, religion, gender, sexual orientation, age or any other basis as covered by federal, state, or local law.

Employment decisions are based solely on qualifications, merit and business needs.