ETL Architect

Derex Technologies Inc

ETL Architect

Cincinnati, OH
Full Time
Paid
  • Responsibilities

    Job Description

    Role : ETL Architect

    Location: Cincinnati OH

    Long term

    Primary Skill: Informatica IDMC, Snowflake

    We are looking for a IDMC developer to join our Data leverage team – a team of high-energy individuals who thrive in a rapid-pace and agile product development environment. As a Developer, you will provide accountability in the ETL and Data Integration space, from the development phase through delivery. You will work closely with the Project Manager, Technical Lead, and client teams. Your prime responsibilities will be to develop bug free code with proper unit testing and documentation. 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 knowledge in one or more of these ETL tools – IDMC, Informatica, and Matillion.

    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
    • 5+ years of experience in Informatica, with 2+ years of experience in IDMC inclusive
    • 2+ years of experience in snowflake
  • Qualifications

    Additional Information

    All your information will be kept confidential according to EEO guidelines.