Extract Transfer Load Developer Jobs in Allen Park, MI

A Few Words About Us Integrated Resources, Inc is a premier staffing firm recognized as one of the tri-states most well-respected professional specialty firms. IRI has built its reputation on excellent service and integrity since its inception in 1996. Our mission centers on delivering only the best quality talent, the first time and every time. We provide quality resources in four specialty areas: Information Technology (IT), Clinical Research, Rehabilitation Therapy and Nursing.

Position Description 

Position will be responsible for the integration, expansion, and support of the North American Automotive and Insurance data warehouse solutions. The Data Warehouse Developer is responsible for interpreting, organizing, designing, executing, and coordinating technical assignments within the Data Warehouse. 

Candidates must have hands on experience with Oracle 10g or higher and Data Stage. Applicant will work closely with a multitude of groups throughout the organization, which will require the ability to communicate with associates with backgrounds ranging from DB development, Application Support, Networking, Operating System Administrators, Software Development Managers, and Business users from a wide range of operating units. 

Principal Accountabilities 

Develop code for Data Warehouse in support of business intelligence projects 

Ensure consistency of Logical and Physical Data Models for all Data Warehouse applications 

Possess a broad understanding of multiple technologies, including DBMS, ETL, Reporting, OLAP, performance tuning for high-end hardware and storage 

Maintain responsibility for global data definitions used in the Data Warehouse 

Integrate data from multiple source systems into Data Warehouse 

Adhere to standards for Data Warehouse, including security, archiving, backup, and recovery 

Participate in architectural decisions for data transitions from source to staging to ODS to EDW 

Communicate regularly and effectively with team members and supervisors 

Identify system and process issues then engage the team in problem solving 

Plan and participate in cross-training with team members 

Develop technical skills comparable to other developers 

Fill in for other developers as requested 

Recognize accomplishments and contributions of team members 

Promote an image of a high quality organization through expertise and responsiveness 

Take responsibility for assignment completion and follow-through 

Provide high level of customer service 

Establish and maintain good working relationships with internal and external customers 

Facilitate satisfactory communication and resolution of problems 

Minimum Requirements 

8+ years of IT experience 

3+ years of Data Warehouse experience 

3+ years of experience with extraction, transformation, and loading tools and development of strategies for loading data into production enterprise Data Warehouse 

3+ years of Data Warehouse development experience 

3+ years of production experience in an Oracle enterprise Data Warehouse 

3+ years of Data Stage ETL experience 

Ability to effectively present information and respond to questions from executives, directors, managers, clients and customers 

Must have dimensional modeling skills at the conceptual, logical, and physical levels, and experience documenting data models 

Ability to work in a rapid-development environment 

Ability to work closely with customers in analyzing requirements 

Ability to work flexible hours 

Project management and technical leadership 

Strong communication skills, written and spoken 

Comfortable working independently, but has experience working in a team environment 

Skills establishing and maintaining effective working relationships with clients and staff 

Ability to read, write, speak, and understand English required 

Can discern when escalation is needed 

Experience in Agile / SCRUM with sprint methodologies preferred 

Finance or Automotive Industry experience preferred 

BS and 6 + years or equivalent

Regards,

Sweta Verma

IT Recruiter

Integrated Resources, Inc.

Inc. 5000 - 2007-2014 (8th Year)

Certified MBE I GSA - Schedule 66 I GSA - Schedule 621I I GSA - Schedule 70

(Direct) 732 549 5907 | (W) 732 -549 - 2030 x 210| (F) (732) 549 5549