Massachusetts Jobs

MassHire JobQuest Logo

Job Information

Cervello Inc Integration Engineer / Boomi developer in Boston, Massachusetts

What we need:

We are looking for a Integration Engineer/Boomi Developer to play a key role on our Software Engineering Team. The successful candidate will develop and maintain strong relationships with teammates while ensuring delivery of high quality Analytics solutions. This role requires the following responsibilities:

  • Architect and deliver data warehousing solutions that exceed customer expectations in content, usability, accuracy, reliability and performance

  • Design and implement Extract, Load and Transform (ETL) processes, programs and scripts

  • Apply advanced SQL query techniques, automate import/export tasks, perform complex data analysis and data quality assurance

  • Mastery of stored procedures, SQL coding, queries, index and database IO performance tuning

  • Ability to proactively identify, troubleshoot and resolve complex data integrity issues

  • Perform gap analysis for Data Models and ETL, creation of high-level and detailed design documentation and map client requirements

  • Design, configure, and document logical and physical data models

  • Develop test plans including test scripts for Unit, System, and User Acceptance Testing including resolution of bugs

  • Comprehensive understanding of Data Warehouse design principles

  • Advanced knowledge of data warehouse development and maintenance

  • Expert in Industry leading ETL/Data Integration tools

  • Work in complex environments while performing multiple activities on concurrent development projects and existing production processes

Technical Requirements:

  • Strong understanding of Data warehouse model and concepts

  • Overall ETL architecture/design experience in best practices

  • 3 -5 years of experience on PL/SQL, Oracle, SQL Server, Microsoft SQL Server Integration Services Boomi and (SSIS) and/or Informatica

  • ETL WorkFlow/Development planning and oversight

  • ETL Performance Optimization including leveraging database partitioning; Hands on experience with SQL Server Performance Optimiztion a plus.

  • ETL Workflow and error handling/reporting

  • Other Data Integration/ETL tools - IBM Infosphere Datastage, Ab Initio, SAP Data Services (Formerly BODI or Acta).