Integration Architect

TechDigital Group; Hartford (CT); On-site; USD 90,000 - 150,000; Full time

Job summary

Join a forward-thinking company as an Integration Architect, where you will design and develop complex integration architectures, including ETL processes and API interfaces. This role requires a strong background in integration development and data quality governance, with the opportunity to work with cutting-edge technologies. You will collaborate with cross-functional teams to ensure data integrity and contribute to innovative projects that drive the business forward. If you are passionate about data integration and have a knack for problem-solving, this is the perfect opportunity to make a significant impact in a dynamic environment.

Qualifications

• 8+ years of experience in integration architecture and development.
• Strong proficiency in ETL tools and API development principles.

Responsibilities

• Design and develop complex integration architectures and ETL processes.
• Collaborate with teams to understand requirements and monitor project progress.

Skills

Integration Architecture

ETL Development

API Development

Data Quality and Governance

Project Management

Problem-solving

Communication Skills

Tools

Informatica

Talend

SSIS

Apigee

Kong

SQL Server

Oracle

MySQL

Python

PowerShell

Job description

Responsibilities:

1. Integration Architecture:
   • Design and develop complex integration architectures, including ETL processes and API interfaces.
   • Define integration standards, guidelines, and best practices.
   • Evaluate and select appropriate integration technologies and tools.
2. ETL Development:
   • Design, develop, and maintain efficient ETL processes to extract, transform, and load data from various sources.
   • Optimize ETL processes for performance and scalability.
   • Troubleshoot and resolve ETL issues.
3. API Development:
   • Design, develop, and test RESTful APIs.
   • Ensure API security and performance.
   • Document API specifications and maintain API documentation.
4. Data Quality and Governance:
   • Implement data quality checks and validation rules.
   • Ensure data integrity and consistency across systems.
   • Contribute to data governance initiatives.
5. Project Management:
   • Collaborate with cross-functional teams to understand business requirements.
   • Estimate effort and plan project timelines.
   • Monitor project progress and identify potential risks.

Qualifications:

• 8+ years of experience in integration architecture and development.
• Strong proficiency in ETL tools (e.g., Informatica, Talend, SSIS).
• In-depth knowledge of API development and RESTful principles.
• Experience with API gateways and management tools (e.g., Apigee, Kong).
• Expertise in data modeling, data warehousing, and data quality concepts.
• Strong understanding of database technologies (e.g., SQL Server, Oracle, MySQL).
• Proficiency in scripting languages (e.g., Python, PowerShell).
• Excellent problem-solving and troubleshooting skills.
• Strong communication and interpersonal skills.