Sr Data Warehouse Consultant

Candidate should be able to:
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.
Candidate should have:
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.
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 Power Center or Informatica Data Quality (equivalent experiences in IBM Data Stage are acceptable