ETL Data Warehouse Developer
JOB TITLE: ETL Data Warehouse Developer
LOCATION: Boston Campus ~ Waltham, MA
Dassault Systèmes, the 3D Experience Company, provides business and people with virtual universes to imagine sustainable innovations. Its world-leading solutions transform the way products are designed, produced, and supported. Dassault Systèmes’ collaborative solutions foster social innovation, expanding possibilities for the virtual world to improve the real world. The group brings value to over 150,000 customers of all sizes, in all industries, in more than 80 countries. For more information, visit www.3ds.com.
CATIA, SolidWorks, ENOVIA, SIMULIA, DELMIA, 3D VIA, 3DSwYm, EXALEAD and Netvibes are registered trademarks of Dassault Systèmes or its subsidiaries in the US and/or other countries.
Develop and enhance ETL mappings from source systems into the data warehouse to support and generate standard and ad hoc BI capabilities from new and existing data sources. Develop and modify queries, analyze source data of different types and design programs for data integration. Configure and customize OBIEE server meta data (Administration Tool), OBIEE hierarchies, and DAC Sequencer. Work with Siebel EIM processes and perform unit testing in the development instance as the project reaches the Build/Test stages. Assist with additional testing as the projects progress through to production release
Bachelor's degree in Computer Science, Information Systems or related field of study plus 5 years of experience in the position offered or five years of experience as a Programmer Analyst. A Master's degree in Computer Science, Information Systems or related field of study plus three years of experience will be accepted in lieu of the Bachelor’s plus five requirements.
Demonstrated knowledge of or experience with ETL development with Informatica and Business Intelligence systems; Siebel Analytics; OBIEE, XML, SQL, PL/SQL, T-SQL, SMTP, DTS, SSIS, Oracle Databases, SQL Server Databases; MSMQ and API; business processes and information systems and concepts; PC and desktop applications; applicable methodologies, tools, standards and procedure; and using formal development processes and/or methodologies required.
Demonstrated knowledge or experience with computer science; all Windows OS development environments including MS Visual Studio, Visual C++, MFC and STL; linear algebra, geometry, math and related programming skills; design and implement software algorithms as part of an overall complex software system; programming skills with a working knowledge of CAD systems; user facing applications and programming with geometric kernels (like Parasolid, ACIS, etc.) required.
COMPENSATION & BENEFITS:
Dassault Systèmes offers an excellent salary with potential for bonus, commensurate with experience that is above average in the local community. Benefits include a choice of plans providing comprehensive coverage for medical, dental, vision care for employee & dependents as well as employee life, short & long term disability, tuition reimbursement, immediate 401K enrollment, 401K match, 3 weeks’ vacation and 8 paid holidays plus 4 floating holidays.
AN EQUAL OPPORTUNITY EMPLOYER:
Dassault Systèmes is committed to a policy of non-discrimination and equal opportunity for all employees and qualified applicants without regard to race, color, religion, sex (including pregnancy), sexual orientation, gender identity, marital status, national origin, ancestry, age (40 and above), disability, veteran status, military service, application for military service, genetic information, receipt of free medical care, or any other characteristic protected under applicable law. DS will make reasonable accommodations for qualified individuals with known disabilities, in accordance with applicable law.
To apply: Please mail your resume to Dassault Systemes SolidWorks Corporation, Attn: Sue Rothwell, 900 North Squirrel Road Suite 100, Auburn Hills, MI 48326. Please refer to Job ID: SW2012-0013 when applying.