Job Description :
Job title: Data Architect Location: Dallas TX Duration: Long term Technology Data Warehouse & ETL Key Skills/Pre requisites Must have worked on Data Warehouse and ETL Technologies for at least 6 yrs. Must have working experience on Azure on services like Azure Data Factory v2, Azure Synapse for at least 1-2 yrs Total Experience required-10-14 Years. Job Description Technical Experience Hands-on experience in design and implementation of Data Warehousing solutions Have built at least two Enterprise Data Warehouses from scratch Must possess complete hands-on experience in anyone RDBMS such as SQL Server Knowledge on Columnar databases such as Microsoft Azure SQL Data Warehouse / Azure Synapse etc. Strong knowledge on SQL and procedural languages such as T-SQL, PL/SQL etc Hands-on experience on any of the ETL Tools such as SQL Server Integration Services (SSIS), Oracle Data Integrator (ODI), etc End to end Data Integration working experience using Azure Data Factory (ADF) Good experience in Dashboard development using Power BI , SSAS Fair knowledge on NoSQL databases such as MongoDB, HBase, Cassandra etc. Fair Knowledge on Data Governance best practices Designing Skills Must have hands-on experience of relational and dimensional modelling In depth knowledge on at least one designing / modeling tools such as ERwin, ER Studio, Power Designer, etc. Must have experience in understanding business vision to prepare ETL solution architecture Well experienced in designing ETL/ELT approaches while authoring the data flows Identifying solutions to key technical challenges in projects concerning data warehousing and business intelligence Technical Skills Exposure to conducting maturity assessments of existing data warehousing / ETL solutions Fair Knowledge on Hadoop technologies (Cloudera / Hortonworks) Fair knowledge on scripting languages such as Shell Scripts, PowerShell, Perl, Python etc

Similar Jobs you may be interested in ..