2576 Data Warehouse/ETL Developer
Technology Project Group - Lake Elmo, MN

This job posting is no longer available on Technology Project Group. Find similar jobs: Data Warehouse ETL Developer jobs - Technology Project Group jobs

Data Warehouse/ETL Developer needed for 6 month contract opportunity. Local candidates preferred. There is no relocation assistance for this opening. General Summary The Data Warehouse/ETL Developer position works within team to provide ETL services as required by business and Technology projects.

This individual should be knowledgeable and proficient in ETL technologies, primarily SSIS. Experience in Master Data Services (MDS), Wherescape RED, SQL Server Reporting Services (SSRS) or Business Objects is highly desirable. Essential Duties This position will work with all functional teams to understand requirements, develop, test, implement and support ETL solutions, including Data Warehouse structures (ODS, EDW, MDM, etc.) in a SQL Server environment. This job also requires the availability to provide after-hour support as part of a rotation.

Capabilities: • Hands-on experience and demonstrated expertise in data warehouse technology. • Familiarity and experience with integrating data warehouse with vendor and other applications. • Demonstrated experience troubleshooting and resolving problems with MS SQL Server and other database engines. • Able to define and champion processes, identify and avoid potential data errors to ensure data integrity.

  • Performs capacity planning and properly identifies required hardware, software, data warehouse configuration/architecture needed to support application needs. • Designs and implements core services, processes and technologies to provide reliability, high availability, performance and scalability for creation, access, caching and lifecycle of data objects and entities. • Utilizes toolsets to diagnose and resolve production issues for data warehouse based project rollouts, or for post rollout support. Qualifications • Required for consideration: 2 year degree in Information Technology, Computer Science or related discipline.
  • 5 - 7 years professional experience in MS SQL Server. • Experience working with functional teams on data model and schema design, performance optimizations and data intensive tasks and architecture components. • 3+ years of design and development of high volume, high availability applications and systems. • 3+ years of experience developing and deploying database tables, stored procedures, views, SQL jobs, as well as data imports, migrations and transformations using SSIS.
  • Experience in MDS, Wherescape RED, SSRS or Business is also desired. • Strong understanding of Microsoft, VMware operating system, storage solutions, networking, security and web servers. • Ability to communicate effectively and work cooperatively with software, operations and QA engineers. • Deep understanding of performance, unit and load testing strategies.
  • Broad knowledge of common applications and technologies in Internet computing, including web servers, app servers, database servers, load balancers, etc.

Technology Project Group - 20 months ago - save job - copy to clipboard - block