-Should work as per USA timings
- we will pay in INR
clinical healthcare/pharma experience is huge plus butnot 100% need.
Azure Elasticsearch are the two biggest needs!!! (AzureData Bricks and Data Lakes especially)
Must have with ETL, data manipulation and data cleansing, very large datasets. Azure experience is a musthave. SQL Server databases (don’t need Oracle/PL-SQL candidates), Elasticsearch, and Spark are also required.
Expertise in datawarehousing, Python programming, data modeling and cloud technologies isrequired.
Consult with stakeholders on software specifications and solutions
Design and develop data integration / transformation solutions supporting both on premise and cloud-based data architectures.
Perform code reviews, analyze execution plans, and re-factor inefficient code, understand index types and usage best practice, and have working knowledge of T-SQL performance tuning.
Follow data standards, resolve data issues, develop appropriate unit testing use cases, understand and perform full regression testing, and complete system documentation for ETL processes.
Ability to excel in an integrated environment, working closely with various business segments, and user teams to accomplish objectives
Communicate effectively across multiple LOB and with stakeholders to review business requirements and propose solutions
In-depth knowledge of relational databases, OLAP query tools, data mining, data structure, and data manipulation techniques.
Previous Experience with Healthcare / PHI
Design and implement OLAP solutions with SSAS (multi-dimensional and/or tabular mode).
Azure data experience
Direct experience with large data warehouses.
Hands-on experience with Python, Spark and Elastic Search
SSIS 2008-2012 or higher programming experience.
Data Warehousing development experience.