Demo

Technical Data Architect

Derex Technologies
Union, KY Full Time
POSTED ON 2/12/2025
AVAILABLE BEFORE 5/11/2025

Company Description

Derex Technologies Inc specializes in providing IT consulting, staffing solutions and software services. Globally headquartered in Harrison New Jersey since 1996 Derex delivers the highest quality technology professionals and an array of customized IT talent solutions designed to improve productivity and drive results to global clients throughout North America.

With over two decades of unparalleled experience, Derex provides supports to its clientele, across such industries as Systems Integration, Banking and Finance, Telecommunications, Pharmaceutical and Life Sciences, Energy, Healthcare, Technology, Transportation, and local and federal Government agencies.

Job Description

Role : Technical Data Architect

Primary Skill : IDMC, Data Modelling, Snowflake

Location : Cincinnati, Ohio - 2 times in a month Travel is required.

We are seeking an experienced ETL Architect with in-depth expertise in Informatica Intelligent Data Management Cloud (IDMC) and Snowflake. The ETL Architect will be responsible for designing, implementing, and optimizing robust ETL / ELT solutions to manage, process, and transform large data sets. The role requires hands-on technical leadership, architecture design, and collaboration with various teams to ensure efficient data integration workflows that meet business requirements.

Key Responsibilities :

ETL / ELT Architecture Design :

  • Architect and design scalable, robust ETL / ELT frameworks using Informatica / IDMC and Snowflake to support complex data integration and transformation needs.
  • Define best practices for data integration, data quality, error handling, logging, and performance optimization.
  • Solution Development :
  • Develop and maintain complex data pipelines to extract, transform, and load data from various sources into Snowflake using Informatica IDMC.
  • Collaborate with data engineers and developers to implement high-performance, fault-tolerant data integration solutions.
  • Data Modeling & Warehousing :
  • Design and implement data models within Snowflake to support analytics, reporting, and business intelligence.
  • Optimize database designs for performance, scalability, and cost-efficiency in cloud-based environments.
  • Cloud Integration :
  • Architect solutions that leverage Informatica Cloud for data integration across hybrid, multi-cloud environments.
  • Implement data migration strategies to move data from on-premise systems to Snowflake in the cloud.
  • Collaboration & Leadership :
  • Provide technical leadership and mentoring to junior developers and data engineers.
  • Collaborate with cross-functional teams, including business analysts, data scientists, and other stakeholders, to translate business requirements into technical solutions.

Performance Optimization :

  • Monitor, analyze, and optimize ETL / ELT job performance.
  • Implement efficient query strategies within IDMC and Snowflake to ensure high performance and low latency for data operations.
  • Compliance & Security :
  • Ensure data governance, compliance, and security standards are adhered to in all ETL processes.
  • Implement data encryption, masking, and access control in Snowflake and Informatica IDMC environments wherever applicable.
  • Experience :

  • 10 years of experience in ETL architecture and data engineering.
  • Strong experience with Informatica Intelligent Data Management Cloud (IDMC) and Snowflake
  • Expertise in Snowflake architecture, data warehousing, and performance optimization.
  • Hands-on experience with cloud platforms such as AWS, Azure, or GCP.
  • Technical Skills :

  • Proficiency in designing ETL / ELT pipelines using Informatica IDMC.
  • Deep understanding of Snowflake's data sharing, time travel, and multi-cluster architectures.
  • Strong SQL skills for database querying and optimization.
  • Experience with data modeling techniques for both OLAP and OLTP environments.
  • Knowledge of data integration best practices, data governance, and cloud-based data migration.
  • Preferred Qualifications :

  • Certifications in Informatica IDMC and Snowflake.
  • Experience with SQL, Python, Scala, or other programming languages for data manipulation and integration.
  • Experience with real-time data integration and streaming architectures.
  • Familiarity with DataOps principles and methodologies
  • Regards,

    Manoj

    Derex Technologies INC

    Contact : 973-834-5005 Ext 206

    Qualifications

    Additional Information

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

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Technical Data Architect?

    Sign up to receive alerts about other jobs on the Technical Data Architect career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $170,841 - $219,163
    Income Estimation: 
    $159,552 - $206,899
    Income Estimation: 
    $170,841 - $219,163
    Income Estimation: 
    $159,552 - $206,899
    Income Estimation: 
    $116,726 - $151,072
    Income Estimation: 
    $147,901 - $186,323
    Income Estimation: 
    $89,551 - $118,439
    Income Estimation: 
    $116,726 - $151,072
    Income Estimation: 
    $124,724 - $161,246
    Income Estimation: 
    $81,769 - $104,543
    Income Estimation: 
    $89,551 - $118,439
    Income Estimation: 
    $103,228 - $139,671
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Derex Technologies

    Derex Technologies
    Hired Organization Address Jersey, NJ Full Time
    Job Description Job Description Company Description Derex Technologies Inc specializes in providing IT consulting, staff...
    Derex Technologies
    Hired Organization Address Woonsocket, RI Full Time
    Company Description Derex Technologies Inc specializes in providing IT consulting, staffing solutions and software servi...
    Derex Technologies
    Hired Organization Address NJ Full Time
    Company Description Derex Technologies Inc specializes in providing IT consulting, staffing solutions and software servi...
    Derex Technologies
    Hired Organization Address Richmond, VA Full Time
    Company Description Derex Technologies Inc specializes in providing IT consulting, staffing solutions and software servi...

    Not the job you're looking for? Here are some other Technical Data Architect jobs in the Union, KY area that may be a better fit.

    Technical Data Architect

    Derex Technologies Inc, Cincinnati, OH

    Technical Data Architect

    RELQ TECHNOLOGIES LLC, Cincinnati, OH

    AI Assistant is available now!

    Feel free to start your new journey!