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
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).
ABOUT US: OUR WORKPLACE IS FUN AND FAST-PACED:We are Cervello. We believe in the power of connected data. We are laser focused on helping organizations harness the interconnectedness of digital, data and decision-making. We are problem solvers and builders focused on helping our clients win with data. Our culture is cool and innovative. Our environment is casual and conducive to collaboration and problem solving. We take our work seriously but not ourselves. It?s the perfect balance of freedom and accountability. If you want to be part of something great ? join us!
Equal Employment Opportunity and NondiscriminationCervello prides itself on providing a culture that allows employees to bring their best selves to work every day. Our people can feel comfortable, confident, and joyful to do great things for our firm, our teams, and our clients. Cervello aims to build diverse capabilities to help our clients solve their most mission critical problems. Cervello is committed to building a diverse, unbiased and inclusive workforce. Cervello is an equal opportunity employer; we recruit, hire, train, promote, develop, and provide other conditions of employment without regard to a person?s gender identity or expression, sexual orientation, race, religion, age, national origin, disability, marital status, pregnancy status, veteran status, genetic information or any other differences consistent with applicable laws. This includes providing reasonable accommodation for disabilities, or religious beliefs and practices. Members of communities historically underrepresented in analytics and consulting are encouraged to apply.