Bromley Business Centre, 27 Hastings Road, Bromley, Kent BR2 8NA, UK

Data Modeler

Our client is looking for an experienced Data Modeler to join an exciting project. This is a remote position with HQ in Romania.
Qualifications:
· Significant proven experience in applying rigorous data management principles and industry standard development approach to model complex and high-volume data assets to build, maintain conceptual, logical, and physical data models
· Demonstrable experience using data modeling tools – e.g., ErWin
· Evaluate existing data models and physical databases for variances and discrepancies
· Experience with managing meta data for data models
· Experience with large-scale, Hadoop big data methods, such as Spark, Scala, NiFi,
· Demonstrable experience in developing, publishing, and maintaining all documentation for datamodels
· Work with Business Analysts, Data Architects, Software developers, DBAs to achieve project objectives – delivery dates, cost objectives, quality objectives, business customer satisfaction objectives, etc.
· Create entity-relationship diagrams for relational systems and dimensional diagrams for the existing and proposed Data Warehouse, Data Marts, and data cubes
· Define ownership, obtain approvals, and communicate data models to Technology teams. Ensure consistent enterprise view and usage of data assets across the global functions and standards
· Provide architectural expertise in Data warehouse construction and engineering, data source identification, engineering, and migration on latest DB technologies – Snowflake, NoSQL
· Provide feedback to Business Intelligence project and management team to improve data acquisition (structured and unstructured), warehousing methodologies and tools
· Experience in Agile development processes
· Ability to independently learn new technologies and data related approaches
· Effective writing and presentation skills
Skills
· Data Modeling concepts (Advanced Level)
· ErWin, Snowflake, DB/MS SQLServer, NoSQL experience is must.
· Modeling experience across large volume based (Tb/Petabytes) environments
· Over-All understanding of Database space (Databases, Data Warehouses, Reporting, Analytics)
· Open to learn new technologies in-line with organizational needs / direction
· Experience with the technologies in the Hadoop ecosystem like Hadoop, HDFS, Spark, and Hive. Additional skillset of MapReduce and Pig is plus
· Well versed with Data Modeling platforms like Erwin, ER STUDIO etc.
· Strong skills in Entity Relationship Modeling (ERWin modeling software preferred)
· Good knowledge about Database Designing / Administration, Advanced Data Modeling for Star Schema design
· Good understanding of Normalized / Denormalized / Star / Snowflake design concepts
· SQL query development for investigation and analysis
· Experience with Data Profiling Tools and BI tools like MicroStrategy will be plus

Azure Architect – Infrastructure

Job Description: Azure Architect – Infrastructure

Expected to drive and contribute to research, design, documentation, and modifications to software specifications throughout the production life cycle with optimal technical solutions across the Azure Infrastructure platforms stack.
Detailed knowledge and implementation skills of Azure Patterns and Design and Migration best practices.
Primary responsibilities include designing, testing, debugging and analysing Infrastructure components and Fabric.

Roles and responsibilities:

· Designs, develops, implements, owns and maintains IT solutions for clients within an agile development lifecycle.
· Contribute to planning, design, implementation, testing, operations, and process improvement.
· Develops high-quality, efficient, IaaS and PaaS components to meet business requirements and in accordance with industry best practices.
· Participates in development of technical solution addressing business issues.
· Participates in requirements discussions and meetings as necessary.
· Generates statistics and prepares reports for management and/or team members on the status of the project.
· Strong customer focus, ownership, ability to dive deep into customer requirements, navigate through ambiguity and undefined problems.

Required Mandatory experience
· 8+ years hands on experience with Azure Services, Windows/ Linux platform.
· In depth knowledge with Azure architectures, operations and implementations.
· In depth knowledge of the Azure computing platform, its many services and dimensions of scalability including but not limited to:
· Azure Storage, Virtual Network, Compute, Premium Storage, Load Balancing, ARM templates for Azure Orchestration, Network Watcher, Operation analytics, Azure SQL, Traffic Manager, Azure Site Recovery, Azure Active Directory.
· Experience working with Automation tools, Cloud management tools
· Knowledge of federated authentication and authorization models

Required industry experience:
· Minimum of 8+ years of professional experience in designing and administering cloud-based services across a large enterprise and diverse environment.
· 5+ years experience on Azure Services Architecture and Implementations.

Required Technical experience
· In depth knowledge of IP networking, VPNs, DNS, load balancing and firewall technologies.
· Demonstrated experience, training or certification with a major Public Cloud platform such as Microsoft Azure, Amazon AWS, Google Cloud Platform, IBM SoftLayer, etc.
· Develop and manage Azure Compute engine (VM, App Service, Azure Container Services etc).
· Configuration and changes to VLANs, firewalls, Express Route, NSG, Network peering and VPN.
· Configuration and changes to Storage, Database, Replication, Backup, DR and migration.
· Provide expert technical recommendations for resilience and reliability.
· Provide support for system modification via automated change management system.
· Maintain proficiency with industry best practices in IT Security, Integration, and Testing.
· Write infrastructure related scripts to automate all manual tasks plus streamline operational activities.
· Evaluate and recommend necessary changes in performance tuning, infrastructure design and monitoring.
· Conduct long range strategic plans of IT infrastructure plus operational aspects of application execution within infrastructure.
· Handle organization-wide windows-based application projects of complex to ensure applications optimal performance and related infrastructure.
· Execute application-level SSL plus configure mutual validation for back-end system communication.
· Support install applications for system production and test to ensure maximum support through applying best practices.
· Execute technology successfully by minimal downtime as well as disruption.
· Provide general framework plus environment to assist application developers and maintain activities.
· Work independently and as part of a team.
· Ability to think critically about problems and arrive at a practical solution.
· Advanced SQL and database skills.
· Very good communication skills.
· Strong problem-solving and analytical skills.
· Self-motivated, independent, detail oriented, and an accountable team-player.

Big Data Test Lead

My Client delivers disruptive digital solutions across capabilities such as Design Thinking, Product Engineering, Data Analytics, Digital Front Office, and Digital Infrastructure through a team of 2,600+ experts technologically elevating 200 companies globally. Our core values of Customer success, We Care, Entrepreneurial (mind set) and Excellence – drive everything that we do, from the very first day.

Analytics Practice
Our Analytics Practice provides future ready solutions to our clients by developing enterprise grade data solutions, embedded with statistical and machine learning models to augment our clients decision making with actionable intelligence. We do this by leveraging digital age technologies (such as Azure DataBricks, AWS EMR, PySpark, Machine Learning, and Design led dashboards).

Roles & Responsibilities:
Lead BIDWH testing and Data lake testing strategy, planning and execution; understanding FinTech business process and the Business Requirements.
Technical Specifications:

· Test strategy definition & test planning
· Design test cases for all scenarios (i.e. positive, negative testing, boundary) including expected outputs from the Business Requirements and Functional to ensure maximum coverage.
· Requirement traceability from business requirements through test cases and defects.
· Validate Test Preparation and verify all teams are aligned with what needs to occur, to build and prepare the test plan.
· Test data creation for systems and integration testing
· Manually Validate the Data against source and target on various platforms layers
· Update & maintain documentation of the executed test cases
· Good in converting complex business rules to SQL test scripts
· Proficient in Test management tools, HP ALM, Jira (Zephyr)
· Good knowledge of Azure DevOps (specifically around managing Test Plans, Suites and Cases)
· Defining and tracking QA metrics like defect count by stages and cycles, defect creation and closure rates, test productivity – creation and execution
· Imparting the process knowledge to the testing team members and publish best practices on an ongoing basis
· Facilitating development of knowledge repository

Requirements:
· Overall 8+ years of experience in DWH and Report software testing, especially in leading Quality Assurance activities for such projects
· Expertise in Data Ingestion Testing, Data Processing Testing, Data Storage Testing and Data Migration Testing Expertise in work with Data Warehousing, Data Migration and ETL
· Successfully worked with technical teams in delivering quality solutions with agile software development methodology.
· Experience in Big Data Testing tools is a plus
· Good skills in writing SQL queries and good knowledge on database
· Experience in designing automation test suite
· Experience in Agile development, knowledge on using Azure Devops/Jira
· Good analytical skills and communications skills
· Good understanding of testing in Azure Databricks (PySpark), Azure Data Factory is desirable
· Prior Financial services industry experience is a plus
· Adopt quickly with different technologies and tools

Big Data Test Engineer

My Client delivers disruptive digital solutions across capabilities such as Design Thinking, Product Engineering, Data Analytics, Digital Front Office, and Digital Infrastructure through a team of 2,600+ experts technologically elevating 200 companies globally. Our core values of Customer success, We Care, Entrepreneurial (mind set) and Excellence – drive everything that we do, from the very first day.

Analytics Practice
Our Analytics Practice provides future ready solutions to our clients by developing enterprise grade data solutions, embedded with statistical and machine learning models to augment our clients decision making with actionable intelligence. We do this by leveraging digital age technologies (such as Azure DataBricks, AWS EMR, PySpark, Machine Learning, and Design led dashboards).

Roles & Responsibilities:
Conduct BIDWH testing and Data lake testing; understanding FinTech business process and the Business Requirements.
Technical Specifications:

· Validate the Data against source and target on various platforms layers.
· Work with Test lead to write test cases for all scenarios (i.e. positive, negative testing, boundary) including expected outputs from the Business Requirements and Functional to ensure maximum coverage.
· Test data creation for systems and integration testing
· Help the test lead with requirement traceability from business requirements through test cases and defects.
· Understanding of test strategy definition & test planning
· Developing and executing formal test plans/test scripts for quality releases
· Update & maintain documentation of the executed test cases
· Proficient in converting complex business rules to SQL test scripts
· Good knowledge in Test management tools, HP ALM, Jira (Zephyr)
· Good knowledge of Azure DevOps (specifically around managing Test Plans, Suites and Cases)

Requirements:
· Overall 2+ years of experience in DWH and Report software testing.
· Expertise in Data Ingestion Testing, Data Processing Testing, Data Storage Testing and Data Migration Testing
· Expertise in work with Data Warehousing, Data Migration and ETL Successfully worked with technical teams in delivering quality solutions with agile software development methodology
· Excellent skills in writing SQL queries and good knowledge on MS SQL databases
· Knowledge of one scripting languages Python, Java etc.
· Good to have hands on experience in Testing in Azure Databricks (PySpark), Azure Data Factory
· Experience in Big Data Testing tools is a plus
· Experience in implementing automation test suites
· Experience in Agile development, knowledge on using Azure Devops/Jira
· Good analytical skills and communications skills
· Prior Financial services industry experience is a plus
· Adapt quickly with different technologies and tools