Chelsoft Solutions Co. · 5 months ago
Data Integration Architect with Informatica-IDMC_Hybrid in Boston, MA_ONLY ON W2
Boston, MA
Contract
Hybrid
Senior Level, Lead/Staff
8+ years expChelsoft Solutions Co. is seeking a Data Integration Architect to lead data integration requirements and develop various data integration components for their Enterprise Data Warehouse. The role involves extensive experience with Informatica and requires strong leadership in managing data workflows and transformations.
Information Technology & Services
Responsibilities
Lead data integration requirements and develop, change, and/or maintain data source connectors, data workflows and transformations, other Data Integration components and assets
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 Andover’s 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
Qualification
Required
8+ years of experience
Integration (Informatica)
Cloud Integration (IDMC)
Excellent communication skills
Bachelor's degree in Management Information Systems, Computer Information Systems, Computer Science or Architecting
Minimum of 5+ year professional experience with Informatica Power Center or Informatica Data Management Cloud
Competent in PostgreSQL to implement database objects on AWS Redshift
Experience working with application integration technologies such as Service Oriented and Event Driven Architectures (SOA / EDA), JMS messaging, SOAP and RESTful services
Experience with AWS data products
Experience within the P&C Insurance industry in a data architecture role
Company
Chelsoft Solutions Co.
Inc. 5000 Fastest Growing Pvt. Companies in USA 5 yr Honoree; Ingrams 4yr Honoree; 2014 MBE Award Winner in State of KS
51-200 employees
H1B Sponsorship
Chelsoft Solutions Co. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (15)
2024 (12)
2023 (21)
2022 (26)
2021 (18)
2020 (70)
Funding
Current Stage
Growth StageCompany data provided by crunchbase