What are the responsibilities and job description for the Technical Data Architect position at Derex Technologies?
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 :
Experience :
Technical Skills :
Preferred Qualifications :
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.
