What are the responsibilities and job description for the Sr.Data Engineer position at Xlysi?
Qualification
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Additionally, the qualifications listed below are representative of the knowledge, skills, and/or abilities required in this position:
Required:- Experience in developing enterprise solutions for data extraction, transformation and aggregation from multiple file formats for analyzing & transforming the data
- Experience with MS SQL Server Integration Services (SSIS), T-SQL programming, stored procedures, and triggers
- Experience in Database Design and development with Business Intelligence using SQL Server 2014/2016, Integration Services (SSIS), DTS Packages, Star Schema and Snowflake Schema.
- Expert Level - Big Data technologies, Azure, AWS, Hadoop, Spark, Hive, Kafka, Flume, NoSQL stores (HBase, Cassandra, DynamoDB, MongoDB).
- Experience working in an Azure DevOps environment with CI/CD pipelines
- Excellent communication skills with excellent work ethics and a proactive team player with a positive attitude
- Expertise in various phases of project life cycles (Design, Analysis, Implementation and testing)
- 4 years of experience with Database Management, preferably SQL Server
- 4 years of experience creating ETL solutions, preferably using SQL Server Integration Services (SSIS) is preferred.
- 2 years of experience creating tabular model solutions using SQL Server Analysis Services (SSAS) is preferred.
- Experience with Azure Devops, Microsoft TFS
- Excellent understanding of T-SQL, stored procedures, indexes, stats, functions, and views
- Experience with relational SQL databases (MS SQL Server)
- Excellent communication, facilitation, and interpersonal skills required.
Only W2 consultants are considered for this position.
