Sr Data Warehouse Developer

Title: Sr Data Warehouse Developer
Location: Northern Illinois/Southern Wisconsin (onsite only - no remote)
Pay Rate: $110000 - $125000
Duration of Job: Full Time
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.

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).

Espo Corporation
Willowbrook, IL 60527

View all open jobs at
Leaders in Technical Recruiting & Staffing since 1965 We are an Equal Opportunity Employer and value the benefits of diversity in our workforce. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity and expression, national origin, disability, protected Veteran status or any other attribute or protected characteristic by law. {Want to learn more? Click here .} If you need assistance applying please contact us at