Senior Data Warehouse Developer

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.

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 Hands-on experience in writing complex T-SQL and database performance tuning. Strong knowledge of Microsoft BI technology (SSRS, SSIS, SSAS and Power BI)

Additional Information

All your information will be kept confidential according to EEO guidelines.