| JD II Data Engineer II Full Time at Raleigh, North Carolina, USA |
| Email: [email protected] |
| From: MOHINI DEVI, Synkriom Inc [email protected] Reply to: [email protected] Hi, Hope you're doing well. Kindly find the job description below and if you are comfortable with the requirement, Please share your updated resume. Location: Raleigh, NC Position: Fulltime Technical skills for search: SQL server versions 2016 and above, SSIS 2015 and 2019, AWS/GCP, Microsoft Azure, Azure Data Factory and Python Essential Functions Capable of developing Data Warehouse solutions using cloud-based tools in an Azure (primary) and AWS (secondary) cloud environment Develop automated processes using ETL tools such as SSIS and Azure Data Factory Analyze data and create sound database designs using dimensional and relational models as needed Experience integrating data processes with various web services technologies (RESTful API, SOAP, RPC) Ability to triage issues and provide 3rd tier technical support in both production and non- production environments to resolution Capable of communicating issues, developing plans and recommendations for corrective actions to mitigate future recurrences Desire to become a subject matter expert in the data and processes utilized to maintain the platform with a keen eye towards improving Design tables, stored procedures, views, and other database objects within SQL Server on prem and in the cloud Advanced SQL-querying proficiency Ability to troubleshoot and improve database performance issues including indexing strategies for various workloads Perform unit testing and prepare data and processes for QA/UAT Work with team manager to track progress on projects and update tracking systems. Experience with Git repositories for source control and CI/CD pipelines Collaborate with members of the BI team and operations to understand business requirements and develop effective solutions. Special Skills Strong Enterprise Data Warehousing skills and thorough understanding of methodologies including managing various flavors of slowly changing dimensions Understanding of ETL Frameworks, utilization of templates, design patterns and metadata to build supportable data integration processes. Proven experience using Cloud based technologies, especially regarding ELT software or other similar tools Must be well organized and able to clearly and concisely present documentation of issues and potential resolutions to technical and non-technical teams Enthusiasm for exploring new technologies - with an eye on maintainability Desire to deliver high quality customer service Ability to adhere to organizational and departmental policies and goals Excellent problem solving and interpersonal skills Demonstrate the strong written and verbal communication skills required in a disparate work environment Required Education and Experience Bachelors degree in Computer Science or similar discipline or equivalent work experience Experience executing in an Agile environment Demonstrated expertise delivering technical solutions as per tickets, specified plans and deliverables Experience developing Data Lakes / Data Warehouses Exposure to data streaming technologies and methods, ESB, pub/sub models Preferred Education and Experience At least 10-12 years of experience 2+ years experience with cloud computing (AWS, Microsoft Azure, Python) Strong automation and programming skills experience Demonstrated knowledge of various scripting tools Keywords: continuous integration continuous deployment quality analyst business intelligence North Carolina |
| [email protected] View all |
| Wed Nov 01 02:17:00 UTC 2023 |