Job Purpose :
Toperform data analytics and help in creation of dashboards usingvisualization tool.
To understand and transform datafrom multiple sources into a library which is scalable and can beused for analysis. Support IA team in extracting, transforming andloading of data from multiple sources into single source.
Analyze raw data : Assessing quality, cleansing,structuring for multiple analysis and usage
Design accurate and scalable transformation techniques inorder to create strong data warehouse for analytics
To work with functional business team in buildingscalable process and metrics; leveraging the knowledge of datawarehouse technical architecture, data structures, Extract,Transform & Load (ETL)and reporting / analytical tools andenvironment.
Understand from IA team therequirements to create analytical prototypes and transform dataaccordingly
Generate actionable insights foraudit function through data analysis and visualrepresentation
Maintain and performdaily / weekly / monthly scheduled batch-jobs & activitiesusing ETL for maintenance of analytics database
Expertise in analyzing, designing, developing, testingand deploying custom data warehouse systems / applications (Involvingvarious mappings for extracting data from sources like relationaltables and flat files).
Ability to understandsource systems, data dependencies, interfaces, integration, ETL,data integration and reconciliation
DataMining & Modeling (Analysis of business data &Preparing all Technical specifications)
Designdatabase structure, functional / Technical specifications.
Technical Skills &Expertise
Data Warehousing / ETL
Proficiency in SQL (Hands onExperience)
SAP HANA DB knowledge