Data Warehouse ETL Developer

SIRVA is a leading partner for corporations to outsource their mobility needs, relocating and moving their executives and staff globally. SIRVA offers an extensive portfolio of mobility services across approximately 170 countries providing an end-to-end solution to deliver an enhanced mobility experience and program control and security for customers. SIRVA has a portfolio of well-known and recognizable brands including Allied Van Lines, northAmerican Van Lines, SMARTBOX, and Allied Pickfords. For more information please visit www.sirva.com.
SIRVA brings together strong, collaborative people in a dynamic culture of mutual respect, support, and passion for the brand and product. We believe innovation drives winning performance, and we constantly challenge ourselves to be the very best we can in every aspect of our business. You will be surrounded by some of the brightest and most driven people in the industry. At SIRVA, you will be in great company!
The Data Warehouse ETL Developer is an experienced ETL developer with various Data Warehousing and Business Intelligence technologies that are necessary to deliver integrated, quality data for business reporting and analytics need.
70% Design, develop, and implement ETL codes
25% Support production ETL bug fixes
5% Coordinate, lead, and mentor offshore ETL developers
Min. 3 years of hands-on experience with RDBMS platforms (ie. Oracle, MS SQL Server), SQL, ETL tools (Informatica PC, Oracle Data Integrator, Business Objects Data Integrator, SSIS, Talend and others)
At least 3 years of Data Warehouse ETL workflow design, development and maintenance with successful implementation of large Enterprise BI solutions
Translate business requirements into Detailed Data Requirements by performing source data profiling and requirement analysis
Demonstrated knowledge of database concepts of data modeling and mapping including normalization, dimensionality, referential integrity, indexes, keys, common dimensions, star and snowflake schemas, master data and metadata (MUST know how to read models and mappings)
Ability to integrate various data sources including Transactional databases, MS Excel, Web Services, Hive, No-SQL databases, and unstructured data sources
Demonstrated across numerous data warehousing / data integration projects the ability to work to with other project team members and business users to resolve moderately complex data integration issues.
Must be well versed with Data integration best practices, standards, and processes
Demonstrated experience in various phases of the Systems Development Life Cycle
Ability to work with minimal supervision
Hands on experience working on Windows and Linux environments and UNIX scripting
Must be self-starter and able to demonstrate experience working in an agile environment to deliver robust & well tested ETL programs
Able to stay on mission some nights/weekends during Team Sprints and production support
DBA or database development experience (a plus)
SIRVA is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, military status, genetic information or any other consideration made unlawful by applicable federal, state, or local laws. SIRVA also prohibits harassment of applicants and employees based on any of these protected categories. It is also SIRVA's policy to comply with all applicable state and federal laws respecting consideration of unemployment status in making hiring decisions. The Federal EEO Law Poster may be found at http://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf If you need a reasonable accommodation because of a disability of any part of the employment process, please send an email to Human Resources at HRSIRVA@SIRVA.com and let us know the nature of your request and your contact information.
Other details
Pay Type Salary
Oakbrook Terrace, IL, USA

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.

More Jobs

Warehouse Cargo Agent
Elk Grove Village, IL DAL Global Services
Distribution and Warehouse Manager
Crystal Lake, IL Cardinal Health
Warehouse Team Member
Rockford, IL LOWE'S
Warehouse Worker - TW Metals, LLC
Carol Stream, IL O'Neal Industries, Inc.
Warehouse Worker - Receiving
Elk Grove Village, IL Bunzl