Sr. Data Integration Engineer

Ergotron, Inc.•Eagan, MN

3h•$145,018 - $153,000•Remote

About The Position

Ergotron, Inc. has an opening for a Sr. Data Integration Engineer in Eagan, MN. 40 hrs/week. Job duties: Create, maintain, monitor and support optimal application integration solutions leveraging API’s, web services and system-specific functionality to execute business processes; Design, develop and deploy solutions for batch and continuous (near-real time) data integration solutions; Design and implement solutions using API-led Integration and Agile Development processes; Administer, monitor and support data movement infrastructure (Informatica environments, ETL and IOT processes, scripts and utilities); Work closely with Oracle ERP, Salesforce and Power BI Developers, Architects and Analysts to implement appropriate data integration and ETL processing solutions; Manage ETL defects, enhancements and new functionality requests to meet changes in systems and business needs; Identify and resolve problems with data processing infrastructure, processes, systems and tools; Recommend solutions for improvement and standardization; Assist with leveraging Informatica Intelligent Cloud Services new features, software installation, upgrade and patching; Lead DevOps process maturity supporting a Continuous Integration strategy across key systems in the IT portfolio; Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs; Engage with colleagues to implement End to End digital solutions that utilize cloud, AI, automation, IoT, API and other multi-vendor capabilities; Support “Lean Business Enterprise” initiatives for continuous process improvement and waste elimination.

Requirements

Requires a Bachelor’s degree, or foreign equivalent, in Engineering, Computer Science, Information Systems, or related IT field, plus 5 years of experience as a Data Integration Developer/Engineer or in a related role/capacity engaged in the design, analysis, and development of Databases, Reporting, Data Warehouse, ETL Design, and BI applications
5 years of experience developing application integration solutions leveraging SaaS applications and their API’s or requisite methods to enact enterprise integration patterns
3 years of experience developing Informatica Intelligent Cloud Services integration solutions, including those involving Salesforce and Oracle ERP
5 years of experience utilizing Informatica Intelligent Cloud Services (IICS)
5 years of experience utilizing relational SQL databases, including Oracle and SQL Server
3 years of experience utilizing Salesforce
3 years of experience utilizing Change Data Capture methods for data integrations
3 years of experience utilizing object-oriented/object function scripting languages: Python, Java, or Java Script
5 years of experience developing application message solutions leveraging REST services, JSON, and XML

Responsibilities

Create, maintain, monitor and support optimal application integration solutions leveraging API’s, web services and system-specific functionality to execute business processes
Design, develop and deploy solutions for batch and continuous (near-real time) data integration solutions
Design and implement solutions using API-led Integration and Agile Development processes
Administer, monitor and support data movement infrastructure (Informatica environments, ETL and IOT processes, scripts and utilities)
Work closely with Oracle ERP, Salesforce and Power BI Developers, Architects and Analysts to implement appropriate data integration and ETL processing solutions
Manage ETL defects, enhancements and new functionality requests to meet changes in systems and business needs
Identify and resolve problems with data processing infrastructure, processes, systems and tools
Recommend solutions for improvement and standardization
Assist with leveraging Informatica Intelligent Cloud Services new features, software installation, upgrade and patching
Lead DevOps process maturity supporting a Continuous Integration strategy across key systems in the IT portfolio
Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs
Engage with colleagues to implement End to End digital solutions that utilize cloud, AI, automation, IoT, API and other multi-vendor capabilities
Support “Lean Business Enterprise” initiatives for continuous process improvement and waste elimination