Sr Data Warehouse/ETL Developer

As a candidate for this role, you will be responsible for the following key responsibilities: - Support and improve production data integration system and environment. - Design and implement ETL processes in support of business analytics and reporting. - Develop and perform unit, system, performance, and regression testing on ETL mappings. - Follow established coding standards, perform code reviews, and improve standards to assure compliance. - Provide technical and business knowledge support to the team. - Ensure effective communication of user requirements. - Create source-to-target mapping specifications for ETL development. - Collaborate with project leads, business analysts, end-users, and third-party contacts to design, implement, and test data warehouse applications. - Design and develop enterprise and departmental business intelligence and data warehousing solutions. In order to be considered for this position, you should possess the following qualifications: - Experience in multiple database platforms, including SQL Server, Oracle, and DB2. - Strong knowledge of Microsoft BI technology (SSRS, SSIS, SSAS, and Power BI). - Solid analytical skills to troubleshoot issues and identify resolutions. - Excellent knowledge of relational data modeling (ERD), SQL, and data warehousing. - Hands-on experience in writing complex T-SQL and database performance tuning. - 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). As a candidate for this role, you will be responsible for the following key responsibilities: - Support and improve production data integration system and environment. - Design and implement ETL processes in support of business analytics and reporting. - Develop and perform unit, system, performance, and regression testing on ETL mappings. - Follow established coding standards, perform code reviews, and improve standards to assure compliance. - Provide technical and business knowledge support to the team. - Ensure effective communication of user requirements. - Create source-to-target mapping specifications for ETL development. - Collaborate with project leads, business analysts, end-users, and third-party contacts to design, implement, and test data warehouse applications. - Design and develop enterprise and departmental business intelligence and data warehousing solutions. In order to be considered for this position, you should possess the following qualifications: - Experience in multiple database platforms, including SQL Server, Oracle, and DB2. - Strong knowledge of Microsoft BI technology (SSRS, SSIS, SSAS, and Power BI). - Solid analytical skills to troubleshoot issues and identify resolutions. - Excellent knowledge of relational data modeling (ERD), SQL, and data warehousing. - Hands-on experience in writing complex T-SQL and database performance tuning. - 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).