Job Description
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
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
💡 Quick Summary
Seeking a career-building opportunity? The Sr Data Warehouse Consultant position is now open for candidates interested in the Warehouse / Logistics Jobs sector. This role in Bangalore offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Warehouse / Logistics Jobs is a plus.