Recruiting the Talent. Staffing the Culture. Call Us: 847-945-7600

Job Seekers

Recruiting the Talent.

  • Share this Job

Sr. Data Warehouse Developer

Location : Kenosha, WI
Job Type : Temp/Contract to Direct
Hours : Full Time
Required Years of Experience : 5-10+
Required Education : Bachelors Degree Preferred
Travel : No
Relocation : No

Job Description :
Position Responsibilities

  • Design and develop enterprise and departmental business intelligence and data warehousing solutions.

  • Collaborate with project leads, business analysts, end users and third-party contacts to design, implement and test data warehouse applications.

  • Design and implement ETL processes in support of business analytics and reporting.

  • Develop and perform unit, system, performance and regression testing on ETL mappings.

  • Create source-to-target mapping specifications for ETL development.

  • Follow established coding standards, perform code reviews and improve standards to assure compliance.

  • Support and improve production data integration system and environment.

  • Provide technical and business knowledge support to the team.

  • Ensure effective communication of user requirements.

Required Qualifications :
Minimum Requirements

  • Bachelor's degree in IT or related major.

  • 8+ years of data-related experience.

  • 5+ years of hands-on experience in design and implementation of ETL framework for complex data warehouse projects using Informatica PowerCenter or Informatica Data Quality (equivalent experiences in IBM DataStage are acceptable).

  • Strong analytical skills to troubleshoot issues and identify resolutions.

  • Available for off-business hours implementation and support.

  • Excellent knowledge of relational data modeling (ERD), SQL and data warehousing.

  • Experience in multiple database platforms, including SQL Server, Oracle and DB2.

  • Hands-on experience in writing complex T-SQL and database performance tuning.

  • Strong knowledge of Microsoft BI technology (SSRS, SSIS, SSAS and Power BI).

Powered by AkkenCloud
Back to Top