Title:  Subcontractor

Area(s) of responsibility

Should have 8-12 years of Mandatory Enterprise Data Warehousing Experience:

• 
  Should have excellent knowledge or RDBMS Oracle/Snowflake
• Excellent communication and interpersonal skills, with the ability to bridge the gap between business and technical teams
• Good working knowledge of EBS, OMEGA, GLOVIA ERP systems as source for their data warehouses.
• Experience with data modeling techniques and data warehousing concepts. 
• Should be able to design and implement scalable data warehouse solutions (Star/Snowflake schema).
• Develop and maintain data marts for various business domains. Optimize data storage and retrieval for performance.
• Maps current processes to the desired state and identifies gaps such as program functions, output requirements, input requirements and sources, data conversion strategies, and system techniques and controls.
• Strong analytical and problem-solving skills.
• Should have sound knowledge of ETL/ELT pipelines and be able to reverse engineering the
• ETL code. Tools preferred like Informatica, SSIS, Matillion.
• Should be able to troubleshoot and fix the Job failures.
• Perform data extraction, transformation, and loading from multiple sources and ensure data quality, integrity, and consistency.
• The candidate should have sound knowledge of at least 1 reporting tools such as Cognos/Tableau/Power BI Admin with excellent knowledge of Power BI Premium .
• Collaborate with business users to gather reporting requirements.
  Maintain and enhance existing BI reports/dashboards.
• Support business users for any kind of reporting issues.
• Document processes and maintain technical artifacts.