ETL Architect with IDMC - Cymansys Solutions LLC

ETL Architect with IDMC

Location: Cincinnati, Ohio

Duration : Long Term

Primary Skill: IDMC

Secondary : IICS, Snowflake

We are looking for an ETL Architect to join our Data leverage team a team of high-energy individuals who thrive in a rapid-pace and agile product development environment. You will provide inputs to planning, estimation, scheduling, and coordination of technical activities related to ETL-based applications.

You will be responsible for meeting development schedules and delivering high-quality ETL-based solutions that meet technical specifications and design requirements ensuring customer satisfaction. You are expected to possess good experience in these ETL tools IDMC and Informatica.

Responsibilities

Experience in Informatica Cloud Data Integration -- processes by constructing mappings, tasks, task flows, schedules, and parameter files

Good understanding of ETL and ELT best practices and experience with ETL and ETL Mapping documentation

Good understanding of database designs / SQL

Good understanding of SDLC and Agile Methodologies

Experience with Linux and Windows Server environments

Strong problem-solving skills and analytical skills with proven strength in applying root-cause analysis

Ability to communicate verbally and in technical writing to all levels of the organization in a proactive, contextually appropriate manner

Strong teamwork and interpersonal skills at all levels

Dedicated to excellence in one's work; strong organizational skills; detail-oriented and thorough

Hands on experience on support activities, able to create and resolve the tickets Jira, ServiceNow

Skills & Experience

Strong experience in ETL tools IDMC(Primary), Informatica (Secondary)

Experience of working in Onsite/Offshore model

2+ years of experience in IDMC inclusive