Informatica/IICS/Data warehouse Consultant

Job Summary

Econosoft is hiring an Informatica/IICS/Data Warehouse Consultant to work onsite in Hyde Park, Hamilton County, US. This senior‑level role supports a critical data modernization initiative with a fixed annual salary of $102,956.89.

Key Responsibilities

• Collaborate with Econosoft’s internal data team to redesign and rewrite existing ETL processes.
• Develop and maintain data pipelines using Informatica Intelligent Cloud Services (IICS) to load data from new source systems into established warehouse tables.
• Optimize performance of data flows, ensuring scalability, reliability, and compliance with data governance standards.
• Conduct code reviews, troubleshoot data integration issues, and provide technical guidance to junior team members.
• Document data models, transformation logic, and operational procedures.
• Participate in sprint planning, daily stand‑ups, and stakeholder meetings to align delivery with business objectives.

Required Qualifications

• 5+ years of hands‑on experience with Informatica IICS and traditional Informatica PowerCenter.
• Strong background in data warehousing concepts, ETL design, and SQL (e.g., Oracle, SQL Server, Snowflake).
• Proficiency in scripting languages such as Python or Shell for auxiliary data tasks.
• Experience with cloud platforms (AWS, Azure, or Google Cloud) and modern data architectures.
• Excellent problem‑solving skills and ability to work independently on‑site from day one.
• Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience).

Preferred Skills

• Knowledge of data modeling tools (Erwin, PowerDesigner) and BI platforms (Tableau, Power BI).
• Familiarity with Agile/Scrum methodologies.
• Certifications in Informatica IICS or cloud data services.

Compensation & Benefits

Annual salary: $102,956.89. Full benefits package, professional development opportunities, and a collaborative on‑site environment.

Frequently Asked Questions

Is remote work allowed for this Informatica consultant position?

No. The role requires on‑site work in Hyde Park from day one.

What is the annual salary for the Informatica/IICS/Data Warehouse Consultant?

The position offers a fixed salary of $102,956.89 per year.

What experience is required with Informatica?

At least 5 years of hands‑on experience with Informatica IICS and strong ETL/data‑warehouse expertise.