What are the responsibilities and job description for the Integration Architect position at Smart Bot Systems?
Job Details
Location - Minneapolis, MN or Hartford, CT(Hybrid)
Skill (Primary) Microsoft-Azure Cloud-Azure
Responsibilities:
* 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.
* 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.
* API Development:
* Design, develop, and test RESTful APIs.
* Ensure API security and performance.
* Document API specifications and maintain API documentation.
* Data Quality and Governance:
* Implement data quality checks and validation rules.
* Ensure data integrity and consistency across systems.
* Contribute to data governance initiatives.
* 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.
