Senior Data Warehouse Developer Job Description Template
Our company is looking for a Senior Data Warehouse Developer to join our team.
Responsibilities:
- Design and implement ETL processes in support of business analytics and reporting;
- Support and improve production data integration system and environment;
- Design and develop enterprise and departmental Business Intelligence and data warehousing solutions;
- Create source-to-target mapping specifications for ETL development;
- Follow established coding standards, perform code reviews and improve standards to assure compliance;
- Collaborate with project leads, business analysts, end users and third-party contacts to design, implement and test data warehouse applications;
- Develop and perform unit, system, performance and regression testing on ETL mappings.
Requirements:
- Experience in multiple database platforms, including SQL Server, Oracle and DB2;
- Strong knowledge of Microsoft BI technology (SSRS, SSIS, SSAS and Power BI);
- Strong analytical skills to troubleshoot issues and identify resolutions;
- Available for off-business hours implementation and support;
- 8+ years of data-related experience;
- Bachelor’s degree in IT or related major;
- Hands-on experience in writing complex T-SQL and database performance tuning;
- Microsoft Certification in Azure Data Solutions is preferred;
- Excellent knowledge of relational data modeling (ERD), SQL and data warehousing;
- Experience working with offshore resources is desired;
- 10+ years of experience in designing and implementing data warehouses, at least 4 years with Cloud data warehouses;
- A Bachelor s Degree in a technology area of study, preferably in Computer Science, MIS or Analytics;
- Experience with Informatica Cloud application integration (ICRT) tool is desired;
- 8+ years of hands-on ETL development experience using Informatica integration tools, PowerCenter and Informatica Cloud;
- Excellent knowledge of relational Datamodelling (ERD), SQL and data warehousing.