Job Description :
Hi,
We have an immediate requirement , Please find the below job description and if you have any Suitable profile please share to the . kindly share your updated resume.
Role: Data Scientist/Data Analyst (Datawarehouse Development)
Location: Richmond, VA
Job type: Long term
No OPT/CPT
Working knowledge on Click stream Analytics
Traffic Analysis,
Sales Funnel Analysis,
Personalization of High Net worth individuals,
Tracking Experiments,
Identity Stiching,
Discover New mediums
Datawarehouse principles, Data Analysis, Enrichment, Data definition, Transformation, Storage, Target Data Modeling. [Mandatory]
RDBMS
SQL Server [ Mandatory ]
Oracle,
MySQL
Programming Language:
Python 3.x.x [ Mandatory ]
C# ( Optional )
ETL Tools
Logstash,
Informatica,
SQLServer SSIS, [ Mandatory ]
Talend
Microsoft BI
Spark RDD [ Preferred ]
Storage Layer Tools [ One of the tools is Mandatory ]
Elastic Search
Mongo DB
AWS RedShift [ Preferred ]
Azure DW [ Preferred ]
Google BigQuery
Snowflake
Amazon S3/HDFS [ Preferred ]
Reporting Tools ( One of the tools is mandatory )
Power BI
Tableau
Kibana
Job Description:
Coordinate with cross-functional teams to understand the client and business requirements.
· Analyze requirements and determine technical feasibility.
· Good knowledge on Datawarehouse principles and sound database design skills.
· Thorough understanding of SQL queries, joins, triggers, cursors, packages, procedures. [Mandatory]
· Ability to understand and develop DataMarts based on the Business requirements and reporting needs.
· Ability to develop programs in Python that can be used to onboard click stream data into the Data Lake. [Mandatory]
· Ability to enrich the Data with other In House CORE Database models to produce strategic reports.
· Ability to work on Database designing for the reporting needs by understanding the unstructured data into suitable RDBMS schema. [Mandatory]
· Create point in time snapshots of the ClickStream Analytics and build knowledge-base based on the Analytics data with Algorithms.
· Ability to do Machine Learning through Spark RDD and Graph processing. [Preferred ]
· Working knowledge of MapReduce. [Preferred ]
Thanks,
Sikkander | IT Recruiter
AVTECH Solutions Inc.
EX 503 (Direct)
mailto: