| ETL Developer (SSIS, Azure Synapse), No H1B at Remote, Remote, USA |
| Email: [email protected] |
| From: Shikha, KPG99 [email protected] Reply to: [email protected] Hi, Hope you are doing well. Please find the job description below and let me know your interest. Position: ETL Developer (SSIS, Azure Synapse), No H1B Location: onsite in St. Louis, MO (specifically Bridgeton, MO) Local only Duration: 12+ Months MOI: Phone and Video We had a few candidates interview for this role and either they were fake or the took another job. The manager has zero candidates and back to square one. Please be 100% sure the candidate has not been submitted as this was open a few weeks ago. The last time I sent this out, 85% of the candidates sent to me were fake. When you submit, please submit their authorization, LI account, current location and rate. ETL Developer (SSIS, Azure Synapse) Manager Notes Looking for onsite resource who has Azure Synapse skills, SSIS skills and Power BI skills as a third possibility Azure Synapse and SSIS are the primary skills we are looking for time support time development 5+ years of experience The resource will work closely with our Data Lead on support items on a day to day basis but will also work on development efforts Highlighted most important from below list of needs Design and maintenance of SQL server data warehouse, data management, various DataMarts SSIS packages and SSAS, business rules, various reports, Power BI dashboards, scoreboards, and other solutions requests. Job Description Closely work with other team members and different department leaders, architects to analyze and help design, develop, support Microsoft full stacks (SSIS, SSAS, SSRS and ADF.) Business intelligence reports, scorecards, data structures, and dashboards. Consulting with internal and external clients to model enterprise-wide complex data structures including master data management Participate in development and maintenance of the database architecture and recommend solutions to business needs including creating structure where none exists for reporting/analytics database solutions using modern techniques and programming language Designs, develops, tests, monitors, manages, and validates data warehouse data activities, including data extraction, transformation, movement, loading, cleansing and updating processes . Will participate in multiple projects simultaneously Works harmoniously in a cross-functional team comprised of managers, supervisors, business analysts, systems personnel and other developers in ensuring the delivery of EDW solutions as planned, on time and within the budget Develop and maintain the appropriate operational documentation for EDW solutions Ensure the accuracy, performance and consistency of the EDW information Perform health checks to ensure the integrity of the EDW data, and the synchronization of EDW. SQL Server EDW developer, including designing and developing solutions. Convert business requirements to concept/ technical specification Data modelling in preparing the data/ dimensional models in Azure Data lake Advance knowledge of Azure SQL DB & Synapse Analytics, Power BI, T-SQL, Logic Apps , Function Apps Monitoring day to day Data factory pipeline activity Knowledge of master data management, data warehousing and business intelligence architecture. Knowledge of Azure data lake is required and Azure Services like Analysis Service, SQL Databases, Azure DevOps, CI/CD Design and implementation of data integration that are innovative, scalable and high performing within SSIS & ADF. Rich understanding of EDW (data warehousing) concepts, architectures and business processes and ability to Perform systems and data analysis for implementation of EDW, ETL and DataMart Expert-level ability writing complex and performance queries in SQL. Rich understanding of data architectural and design patterns including normalized, dimensional, data vault, and multi-dimensional approaches. Willingness to learn and experiment with technologies outside of his/her comfort area. Excellent interpersonal skills and ability to work with all levels of personnel individually and within teams. Good communication skills, both verbal and written. Conduct or coordinate tests to ensure that intelligence is consistent with defined needs. Maintain library of model documents, templates, or other reusable knowledge assets. Create or review technical design documentation to ensure the accurate development of EDW solutions. Document specifications for business intelligence or information technology (IT) reports, dashboards, or other outputs. Keywords: continuous integration continuous deployment business intelligence database information technology Missouri |
| [email protected] View all |
| Wed Aug 23 23:56:00 UTC 2023 |