Job Description

Department: Client Delivery Team - EmpowerIndustry: Information Technology & Services, Computer Software, Management ConsultingLocation: Pune/Bangalore/Hyderabad/Remote (Anywhere in India)Experience Range: 5+ yearsBasic Qualification: Master/Bachelor of Engineering or EquivalentTravel Requirements: Not requiredWebsite:Whatxe2x80x99s the Role?Full-time job to work with Exusia's global (Americas, Europe, Africa, Asia) clients to deliver on bleeding-edge data-driven solutions by performing business and data analysis, data modelling, data mapping and translating functional requirements into technical specifications.Work with Client Product Owners & Business SMEs, Exusia Solution Architects and Senior Application Designers/Developers.xefxbbxbfCriteria for the Role!xc2xb7 Have a minimum of 5 years of experience working as a Data Analyst and Data Modelerxc2xb7 Master of Science (preferably in Computer and Information Sciences or Business Information Technology) or an Engineering degree in the above areas.xc2xb7 Experience working in an agile software delivery model is required.xc2xb7 Prior data modelling experience is mandatory preferably for DWH/Data martsxc2xb7 Self-motivated and proactive in a fast-paced environment.xc2xb7 Excellent communication, creative problem solver, flexible, proactive, attitude to learn newer tools/technologiesResponsibilitiesxc2xb7 Own and Lead Data Analysis and data modeling activitiesxc2xb7 Discuss & document data and analytics requirements with cross functional teams and business stakeholders.xc2xb7 Analyze requirements and come up with technical specifications, source-to-target mapping, data and data modelsxc2xb7 Data profiling and cleaning data for data analysis. Interpret data, analyze results, prepare data analysis reports.xc2xb7 Perform Data validation and testing to certify dataxc2xb7 Collect, analyze and disseminate significant amounts of information to project team & business stakeholders.xc2xb7 Manage changing priorities during the software development lifecycle (SDLC)Mandatory Skillsxc2xb7 Able to create Logical and Conceptual data models for business and functional usersxc2xb7 Understanding of ER and Dimensional modeling techniques like Star, Snowflake or Constellationxc2xb7 Hands on experience in implementing Star Schema and Relational (Normalized including 3NF) models is mandatoryxc2xb7 Should have implemented physical data models for a variety of RDBMS and cloud hosted databasesxc2xb7 Strong understanding of different types of facts and dimensionsxc2xb7 Hands on experience with data modeling tools like Erwin, ER Studio, InfoSphere Data Architect (IDA)xc2xb7 Strong SQL or python skills for carrying out data analysis and data profilingxc2xb7 Transforming business/functional requirements into technical specifications.xc2xb7 Capturing data mapping / data transformation and business rules logic using source to target mapping templatesxc2xb7 Hands-on exposure to SQL and NoSQL databases and able to write pseudo-code for ETL requirements.xc2xb7 Data validation and testing using SQL or any tool-based testing methodsNice to have skillsxc2xb7 Exposure to scrum master or product owner role will be desirablexc2xb7 Knowledge of data processing / ETL using Ab Initio / SAS / SSIS / Python / Scala / Apache Spark / Databricksxc2xb7 Exposure to one or more Cloud platforms xe2x80x93 Amazon Web Services (AWS), Microsoft Azure, Google Cloud Platformxc2xb7 Exposure to Data Governance projects including Metadata Management, Data Dictionary, Data Glossary, Data Lineage and Data Quality aspects.xc2xb7 Experience and knowledge of one or more domains xe2x80x93 Banking or Healthcare

Exusia