Data Integration Architect
Data Integration Architect
Posted on :
21-07-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Boston - Data Architect Role
Seeking a Data Integration Architect. In this role you will be will lead data integration requirements and develop change and/or maintain data source connectors data workflows and transformations other Data Integration components and assets. Candidates should have extensive experience with Informatica preferably with Informatica Intelligent Data Management Cloud. This role will require candidates to be onsite 4 days per week.
Skills:
- 8 years of experience
- Integration (Informatica)
- Cloud Integration (IDMC)
- Excellent communication skills
IDMC is a critical component of our data warehouse solution architecture and the Data Integration Architect will architect data integration components to build and maintain our Enterprise Data Warehouse.
To achieve this goal the Data Integration Architect will lead data integration requirements and develop change and/or maintain data source connectors data workflows and transformations agents other Data Integration components and assets. Your technical acumen of IDMC must be significant to perform day to day operational and project activities with a high degree of quality.
Your role also provides the opportunity to work and lead the larger data warehouse team on implementing more complex requirements that drive changes within IDMC across the non-production and production environments. Providing support and coordination of the overall data management process in this way requires an attention to detail and being customer focused to ensure needs are effectively addressed by the IT organization.
Assist with requirement definition on data integration designs and take ownership to resolve JIRA tickets within Sprints with a high quality outcome.
Review analyze and where necessary author functional requirements and mapping documents.
Develop standard to complex ETL components such as connectors mappings sessions and workflows based on the prepared low-level design requirements.
Be a steward of quality in your work by applying design patterns use cases thinking and validation of work through unit testing.
Debug mappings and identify errors and error rows so that they can be corrected and re-loaded into a target system.
Author and implement a performance tuning of mappings processes and load routines.
Assist with QA by acting as a peer reviewer and coaching more junior resources.
Act as an expert resource on IDMC application repositories dependencies scheduling mechanism object and various dependencies within Andovers solution architecture to other members of the team.
Profile data to gain insights into Data Integration strategies identify technical dependencies and design integration components.
Monitor IDMC environments and troubleshoot service and job related issues.
Assess ramification of issues and prioritize tasks based on business impact for operational and project support activities.
Provide reporting related to IDMC operational job trending and other resource utilization within the nightly batch schedule.
Provide guidance to the Cloud support team to improve monitoring measuring and reporting system health performance and uptime metrics.
Leverage IDMC existing and new features by evaluating/reviewing installing and configuring new software releases upgrades and patches through planning and coordination with the larger team.
Maintain appropriate documentation of system infrastructure data architecture ETL processes data modeling and reporting capabilities providing oversight.
Lead Data Lifecycle Management processes and procedures related to change management.
Recommend updates to Data Lifecycle Management to improve efficiency and reduce risk related to changing our architecture data models and IDMC components
Other duties as assigned to support technical/operational activities.
Required:
o Bachelors degree in Management Information Systems Computer Information Systems Computer Science or Architecting.
o Minimum of 5 year professional experience with Informatica Power Center or Informatica Data Management Cloud.
o Competent in PostgreSQL to implement database objects on AWS Redshift
o Experience working with application integration technologies such as Service Oriented and Event Driven Architectures (SOA / EDA) JMS messaging SOAP and RESTful services.
o Experience with AWS data products.
o Experience within the P&C Insurance industry in a data architecture role.
Employment Type
Full-time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
