IICS - IDMC Data Engineer

Role Description

IICS - IDMC Data Engineer

Location:

Cincinnati, OH, USA – Onsite

• Informatica experience of at least 5 years and 2 years in IDMC:
  Strong understanding of Informatica Intelligent Data Management Cloud (IDMC) including CDI and data integration concepts.
• Good knowledge of Snowflake architecture, data modeling, data ingestion, and data transformation concepts.
• Experience gathering, analyzing, and documenting business and functional requirements for data engineering initiatives.
• Ability to perform impact analysis across source systems, ETL processes, and reporting platforms.
• Strong SQL skills for data analysis, data validation, and troubleshooting.
• Understanding of Data Warehousing concepts, dimensional modeling, and ETL ELT methodologies.
• Experience working with Agile methodologies: user stories, backlog grooming, and sprint planning.
• Knowledge of data integration workflows and enterprise data architectures.
• Experience creating functional specifications, process flows, and solution documentation.
• Ability to coordinate between business stakeholders, architects, developers, and QA teams.
• Experience supporting solution validation, UAT, and requirement traceability.
• Familiarity with Azure, AWS, or GCP cloud data platforms.

• Exposure to Informatica Data Quality, Data Governance, or Metadata Management solutions.
• Knowledge of Python or scripting for data analysis.
• Familiarity with Jira, Azure Dev Ops, Confluence, or similar project management tools.
• Understanding of Data Quality, Data Governance, and Master Data Management concepts.
• Experience in Insurance or Financial Services domain.

• Strong communication and stakeholder management skills.
• Excellent analytical and problem‑solving abilities.
• Ability to translate business requirements into technical requirements.
• Strong documentation and presentation skills.
• Ability to facilitate discussions between business and technical teams.
• Collaborative mindset with strong interpersonal skills.
• Ability to manage multiple priorities and work in a fast‑paced environment.
• Proactive attitude with strong ownership and accountability.

• Approximately 7 years of experience gathering, analyzing, and documenting business and functional requirements for Data Engineering, ETL, or Data Warehouse projects.
• Working knowledge of Informatica IDMCIICS, Snowflake, SQL, and Data Warehousing concepts including data modeling and ETL ELT processes.
• Experience working with Agile methodologies and coordinating requirements between business stakeholders, architects, developers, and QA teams.
• Need to be productive by 3rd August 2026 without visa issues.

• Comprehensive Medical Plan covering medical, dental, vision.
• Short‑Term and Long‑Term Disability Coverage.
• 401(k) Plan with company match.
• Life Insurance.
• Vacation Time, Sick Leave, Paid Holidays.
• Paid Paternity and Maternity Leave.

The range displayed on each job posting reflects the minimum and maximum salary target for the position across all US locations. Within the range, individual pay is determined by work location and job level and additional factors including job‑related skills, experience, and relevant education or training. Depending on the position offered, other forms of compensation may be provided as part of overall compensation like an annual performance‑based bonus, sales incentive pay and other forms of bonus or variable compensation.

Actual compensation within the range will be dependent upon the individual's skills, experience, performance and internal equity.

Disclaimer:
The compensation and benefits information provided herein is accurate as of the date of this posting.

LTIMindtree is an equal opportunity employer that is committed to diversity in the workplace. Our employment decisions are made without regard to race, color, creed, religion, sex (including pregnancy, childbirth or related medical conditions), gender identity or expression, national origin, ancestry, age, family‑care status, veteran status, marital status, civil union status, domestic partnership status, military service, handicap or disability or history of handicap or disability, genetic information, atypical hereditary cellular or blood trait, union affiliation, affectional or sexual orientation or preference, or any other characteristic protected by applicable federal, state, or local law, except where such considerations are bona fide occupational qualifications permitted by law.