Sr. Cloud Data Warehouse (CDW) Developer
Hire IT People, LLC
Job Seekers, Please send resumes to resumes@hireitpeople.com
Key Responsibilities:
Deliver high quality, transactional consistent and efficient enterprise ELT/ETL solutions Provide support, and documentation of new and existing ETL processes and solutions Present the solution to business user and communicate with end user solution details Work with Enterprise, ETL and Data Architect to define, develop and deliver Data Engineering Roadmap Develop, test & implement ETL solutions using an agile methodology Ability to handle multiple projects at once Collaborate with other ETL and / or application developers and business users Ability to work with on/off shore extended teams Be a proactive member of the data services team Maintain professional demeanor at all times while representing the company Regular and predictable attendance at assigned times is required Other duties as requiredKnowledge/ Skill Requirements:
Advanced knowledge of SQL databases and queries Advanced knowledge of CDC (Change Data Capture) & CT (Change Tracking) inner workings Experience developing and implementing CDW product like Snowflake., Azure DW , Redshift in Azure / AWS Experience of using various data connector from different vendors (ie. Ultipro, Successfactors, ExoInsight, Azure, AWS, Kafka etc..) Experience in cloud components like Data Lake Storage, Cloud ETL, Role base access, IAM , Cost monitoring in SaaS , PaaS, IaaS in platforms like but not limited to Azure, AWS, GCP Skill for Data Replicator product like Fiveran, HVR Data Orchestration product expertise is a plus like Matillion Data Loader Experience in implementing and supporting several different ELT/ETL solutions including SSIS, Azure Data Factory, SnowSQL or similar ETL/ELT solution in cloud or on premises Experience in working with many different data sets, large and small Experience working with data in multiple ERP and data movement technologies Experience with normalizing and de-normalizing data Knowledge of ETL/ELT best practices and standards Ability to quickly resolve issues Experience with SQL Server 2012 – SQL 2019, SQL Server Reporting Services Ability to present ideas in concise, business-friendly and user-friendly language Excellent written, interpersonal and verbal communication skills Experience with managing and collaborating with multidisciplinary teams Experience in data visualization product like Tableau, Power BI, QlickView Experience with design and development of EDW (Enterprise Data warehouse) is preferred Any recent experience in conceptualizing and implementing DaaS (Data As a Service ) is a plus.Education/ Experience:
Bachelor’s Degree in Engineering/Computer related discipline, or equivalent experience required / Master's preferred 5+ years of CDWELT/ETL Design, development and implementation experience 5+ years of SQL/No SQL Development Experience 5+ years of experience defining and managing ELT/ETL using tools and industry standard practices. 3+ years of SQL Server Reporting Services or other similar platform to supply data from enterprise data hubExperience required: 5 Years
Confirm your E-mail: Send Email
All Jobs from Hire IT People, LLC