Data Integration Engineer

6 days ago

Andover, United States SNI Technology Full time
Job Details

The Data Integration Engineer is a technical professional role that ensures our data integration needs are identified and implemented on the Informatica Data Management Cloud (IDMC) platform. IDMC is a critical component of our data warehouse solution architecture and the Data Integration Engineer will engineer data integration components to build and maintain our Enterprise Data Warehouse.

To achieve this goal, the Data Integration Engineer 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. Essential Functions
  • 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.
Competencies / KSA's The core competencies for a person to perform this job at a skilled level are:
  • Informatica development focused on Data Engineering and Integration.
  • Administration and management of the IDMC solution through a Data Management Lifecycle.
This job requires certain knowledge, skills, and abilities as follows:
  • DevOps methodologies and best practices.
  • Expert analytical skills to troubleshoot issues with system performance, connectivity to various data sources, space and system logging.
  • Experience in SOX requirements, Audit reports and DR/BC needs that are mandatory for running the data management platform.
  • Eligible candidate will be trained in the role of Advanced Data Engineering and Integration using IDMC.
Key Performance Indicators An individual's success is determined by their performance of the following Company's core values:
Be a Champion with:
  • Integrity and Trust: The ability to skillfully interact from top to bottom and bottom to top requires integrity and trust, which starts at the top.

Value Everyone by:
  • Having a Customer Focus: We collectively service customers every day. Getting firsthand customer information and using it for improvements is essential.
  • Focused on Peer Relationships: quickly find common ground and solve problems as a cooperative team player who can collaborate, be candid, and gain the trust and support of peers.

Be an Expert by:
  • Priority Setting: Often priority setting occurs at the individual level but requires managerial guidance and vice versa. Skilled priority setting establishes this collaborative norm.
  • Being Functionally / Technically proficient: Has the functional and technical knowledge and skills to do the job at a high level of accomplishment.
  • Problem Solving: Probes all fruitful sources for answers.

Rise to the Occasion by:
  • Learning on the Fly: With the increasing pace of change, being quick to learn and apply first-time solutions is a crucial skill.
Required Education and Experience
  • Required:
  • Bachelor's degree in Management Information Systems, Computer Information Systems, Computer Science or Engineering.
  • 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
Preferred: 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. Work Environment This job operates in a professional office environment. This role routinely uses standard office equipment such as laptop computers and smartphones. Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Position Type and Expected Hours of Work This is a full-time position. Days and hours of work are Monday through Friday, 8:15 am to 4:30 pm and must work 37.5 hours each week to maintain full-time status.

Work schedules may differ based upon responsibilities demanding before or after hours to meet a business need.

Remote working for those that are eligible is at the discretion of Management.
Other Duties Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

Get job alerts by email. Sign up now

  • Data Integration Engineer

    6 days ago

    Andover, United States SNI Technology Full time

    *US Based Domestic applicants only. Must be US Citizen or Green Card holder. No Visa Sponsorship**This is a 100% on-site position and will require the candidate in the office 5-days a week. Relocation will not be provided.***No C2C agenciesThe Data Integration Engineer is a technical professional role that ensures our data integration needs are identified...

  • Senior Systems Engineer

    3 weeks ago

    Andover, Massachusetts, United States RTX Full time

    Company OverviewWe are a leading aerospace and defense company dedicated to helping our nation and allies defend freedoms and deter aggression. Our team solves tough, meaningful problems that create a safer, more secure world.SalaryThe estimated salary range for this role is $118,000 - $246,000 per year.Job DescriptionWe are seeking an experienced systems...

  • Data Engineer

    3 weeks ago

    Andover, United States Rockstar Games Full time

    At Rockstar Games, we create world-class entertainment experiences. A career at Rockstar Games is about being part of a team working on some of the most creatively rewarding and ambitious projects to be found in any entertainment medium. You would be welcomed to a dedicated and inclusive environment where you can learn, and collaborate with some of the most...

  • Senior Data Engineer

    3 weeks ago

    Andover, United States Rockstar Games Full time

    At Rockstar Games, we create world-class entertainment experiences. Become part of a team working on some of the most rewarding, large-scale creative projects to be found in any entertainment medium - all within an inclusive, highly-motivated environment where you can learn and collaborate with some of the most talented people in the industry. Rockstar is...

  • Senior Data Engineer

    3 weeks ago

    Andover, United States Rockstar Games Full time

    At Rockstar Games, we create world-class entertainment experiences. Become part of a team working on some of the most rewarding, large-scale creative projects to be found in any entertainment medium - all within an inclusive, highly-motivated environment where you can learn and collaborate with some of the most talented people in the industry. Rockstar is...

  • Big Data Architect

    15 hours ago

    Andover, Massachusetts, United States Rockstar Games Full time

    Senior Data Engineer PositionWe are seeking an experienced Senior Data Engineer to join our team at Rockstar Games. As a key member of our data engineering team, you will be responsible for designing and implementing large-scale data systems that enable data-driven decision making across the organization.The ideal candidate will have a strong background in...

  • Lead Technical Systems Integrator for Air Force FAB-T Program

    3 weeks ago

    Andover, Minnesota, United States MAINSAIL Group Full time

    Job OverviewThis exciting opportunity is a Lead Technical Systems Integrator role supporting the United States Air Force Family of Advanced Beyond Line-of-Sight Terminals, BITI, or FAB-T Program at Hanscom AFB MA. The position is hybrid with 1-2 days a week on site.About the RoleThe successful candidate will be responsible for conducting thorough reviews of...

  • Business Integration Analyst

    2 weeks ago

    Andover, United States Integrated Resources Full time

    Job Description: POSITION SUMMARY Assist PDM Compliance Lead responsible for managing and delivering the harmonization and integration of documents acquired through acquisitions by applying document management and technical transfer business standards using appropriate document management systems and corporate training systems, perform QC of Standard...

  • Business Integration Analyst/Support

    2 weeks ago

    Andover, United States Aequor Technologies Full time

    Job Title: Business Integration Analyst/Support Contractor Work Location - Andover, MA 01810 Duration:12 months contract - Hybrid role Work schedule - Flexible hours to accommodate eastern (primary) and western time zones. Interview - Teams Meeting or Onsite Request ID# 32834-1 Hybrid office position requires sitting and ability to travel to Pharmaceutical...

  • Senior Logistics Support Engineer

    3 weeks ago

    Andover, Massachusetts, United States Raytheon Full time

    About the RoleAt Raytheon, we are committed to delivering innovative solutions that protect our nation and allies. As a Logistics Systems Specialist, you will be an integral part of our Life Cycle Engineering (LCE) team, working closely with stakeholders to ensure the development and maintenance of detailed logistics supportability analysis, provisioning...

  • Data Architect Lead

    15 hours ago

    Andover, Massachusetts, United States MKS Instruments Full time

    Job SummaryMKS Instruments is seeking a highly skilled Data Architect Lead to join our IT Infrastructure team. This role requires a deep understanding of database architecture, data modeling, and database management systems.The ideal candidate will be responsible for designing, implementing, and maintaining our database systems to ensure optimal performance,...

  • Logistics Systems Engineer, Supply Chain Optimization Specialist

    3 weeks ago

    Andover, Massachusetts, United States Raytheon Careers Full time

    Raytheon Careers is a leading aerospace and defense company that values innovation, diversity, and inclusion. We are seeking a highly skilled Logistics Systems Engineer, Supply Chain Optimization Specialist to join our team.The successful candidate will be an integral part of our Life Cycle Engineering (LCE) team, working closely with stakeholders to develop...

  • Systems Engineer, DoD Program

    3 weeks ago

    Andover, United States MAINSAIL Group Full time

    Job DescriptionJob DescriptionCome join the MAINSAIL Team and support the United States Air Force and the Base Information Transport Infrastructure Team located at Hanscom AFB MA. This position is hybrid with 1-2 days a week on Hanscom AFB.Responsibilities include:Conduct reviews on program portfolio to evaluate and/or recommend alternative plans, improve...

  • Lead Data Center Electrical Architect

    2 weeks ago

    Andover, Massachusetts, United States Schneider Electric Full time

    Schneider Electric is seeking a skilled Senior Power Systems Electrical Engineer to join our team. This position offers an exciting opportunity to work on cutting-edge data center electrical architectures and collaborate with cross-functional teams.About the RoleThis Senior Power Systems Electrical Engineer will be responsible for creating innovative power...

  • Systems Engineer, DoD Program

    1 month ago

    Andover, United States MAINSAIL Group Full time

    Job DescriptionJob DescriptionCome join the MAINSAIL Team and support the United States Air Force Family of Advanced Beyond Line-of-Sight Terminals, BITI, or FAB-T Program at Hanscom AFB MA. This position is hybrid with 1-2 days a week on Hanscom AFB.Responsibilities include:Conduct reviews on program portfolio to evaluate and/or recommend alternative plans,...

  • Engineering Logistics Specialist

    7 days ago

    Andover, Massachusetts, United States Raytheon Full time

    We are seeking an experienced Logistics Systems Engineer II to join our Life Cycle Engineering (LCE) team at Raytheon. As a key member of this team, you will be responsible for developing and maintaining supportability analyses and provisioning data for hardware within a specific product line.Key Responsibilities:Data Analysis: Develop and maintain...

  • Logistics Systems Engineer, II

    2 months ago

    Andover, United States Raytheon Careers Full time

    *Date Posted:* 2024-10-22*Country:* United States of America*Location:* MA600: Andover, MA 366 Lowell St 366 Lowell Street , Andover, MA, 01810-5423 USA*Position Role Type:* OnsiteAt *Raytheon*, the foundation of everything we do is rooted in our values and a higher calling – to help our nation and allies defend freedoms and deter aggression.  We bring...

  • Senior Manufacturing Engineer

    1 month ago

    Andover, United States Raytheon Technologies Full time

    Date Posted:2024-09-13Country:United States of AmericaLocation:MA114: Andover MA 354 Lowell Suffolk 354 Lowell Street Suffolk, Andover, MA, 01810 USAPosition Role Type:OnsiteAt Raytheon, the foundation of everything we do is rooted in our values and a higher calling - to help our nation and allies defend freedoms and deter aggression. We bring the strength...

  • Logistics Systems Engineer, II

    2 weeks ago

    Andover, United States Disability Solutions Full time

    Date Posted: 2024-10-22 Country: United States of America Location: MA600: Andover, MA 366 Lowell St 366 Lowell Street , Andover, MA, 01810-5423 USA Position Role Type: Onsite At Raytheon, the foundation of everything we do is rooted in our values and a higher calling – to help our nation and allies defend freedoms and deter aggression.  We bring the...

  • Logistics Systems Engineer, II

    2 months ago

    Andover, United States Raytheon Full time

    Date Posted: 2024-10-22 Country: United States of America Location: MA600: Andover, MA 366 Lowell St 366 Lowell Street , Andover, MA, 01810-5423 USA Position Role Type: Onsite At Raytheon, the foundation of everything we do is rooted in our values and a higher calling – to help our nation and allies defend freedoms and deter aggression.  We bring the...