Role: Cloud Data Engineer / Lead Location: Billerica Contract Job Description:
Senior Developer Azure Synapse with Strong SQL
- Looking for a senior Data Warehouse/Data Engineer with strong experience in the Azure Data Stack
- Must have 8-10 years + of SQL/Data Warehouse experience and 2 year of Azure Synapse experience
- Must have experience implementing Azure Synapse from end to end
- Should have expertise in migrating from SQL to synapse
- 5+ years of hands-on experience with Microsoft Azure components in particular, Azure SQL, Azure Analysis Services, Synapse (Synapse implementation experience is a must have)
- Proven relevant experience in systems integration and implementation (Synapse), or software development, or a related discipline
- Experience implementing ETL solutions, particularly utilizing Qlik Replicate and Compose
- Strong Database Development Skills, particularly implementing SQL solutions in Azure SQL, Synapse or Databricks
- Good experience with large datasets
- Experience improving Data Quality in Data Warehouses, particularly utilizing Informatica DataQuality
- Experience testing ETL solutions, particularly utilizing Informatica DVO product
- Experience using Enterprise Architecture modeling tools, frameworks and methodologies such as TOGAF, SPARX EA, UML, BPMN, Archimate etc
- Experience Designing Data Warehouses, applying Kimball’s Dimensional Modeling Techniques, Architecting ETL systems
- Experience working in Agile development software methodology, authoring technical documents / specifications
- Experience debugging complex software systems
- Significant experience implementing data-driven systems with large-scale relational or object-oriented databases
- Ability to work in a high pressure, result/deadline-oriented environment
- Bachelor's Degree in a technical discipline (Maths, Science, Engineering, Computing, etc.) or a related study, or equivalent project-related experience
Responsibilities: - Accountability Supporting Activities
- Data analysis Applies data analysis, data modelling, and quality assurance techniques, based upon a detailed understanding of business processes, to establish, modify or maintain data structures and associated components (entity descriptions, relationship descriptions, attribute definitions)
- Advises database designers and other application development team members on the details of data structures and associated components
- Database design Develops and maintains specialist knowledge of database concepts, object and data modelling techniques and design principles and a detailed knowledge of database architectures, software and facilities
- Analyses data requirements to establish, modify or maintain object/data models
- Evaluates potential solutions, demonstrating, installing and commissioning selected products
- Programming/software development Designs, codes, tests, corrects and documents complex programs and scripts from agreed specifications, and subsequent iterations, using agreed standards and tools, to achieve a well engineered result
- Takes part in reviews of own work and leads reviews of colleagues' work
- Systems design Specifies user/system interfaces, and translates logical designs into physical designs taking account of target environment, performance security requirements and existing systems
- Implementing and configuring Azure Synapse
- Design and develop ETL mappings and workflows using Qlik or Informatica
- Develop technical specifications for data loading rules
- Mentor and provide technical guidance for Software Engineers
- Design, implement, and architect software products
| | | |
To unsubscribe from future emails or to update your email preferences click here .
Post a Comment