Data Migration Engineer

Job Description:

• Design and implement projects focused on collecting, aggregating, storing, reconciling, and making data accessible from disparate sources to enable analysis and decision making.
• Use comprehensive modern data engineer techniques and methods with Advanced Analytics to support business decisions for Avanade clients.
• Can collect, aggregate, and analyze structured/unstructured data from multiple internal and external sources and patterns, insights, and trends to decision-makers. Support the use of data-driven insights to help our Clients achieve business outcomes and objectives.
• Collect, aggregate, store, and reconcile data in support of Client business decisions. will help design and build data pipelines, data streams, reporting tools, information dashboards, data service APIs, data generators and other end-user information portals and insight tools.
• As a critical part of the data supply chain, ensuring that stakeholders can access and manipulate data for routine and ad hoc analysis to drive business outcomes using Advanced Analytics.
• Translate business requirements to technical solutions leveraging strong business acumen.
• Analyze current business practices, processes and procedures as well as identifying future business opportunities for leveraging Microsoft Azure Data & Analytics PaaS Services.
• Support the planning and implementation of data design services, providing sizing and configuration assistance and performing needs assessments.
• Deliver of architectures for transformations and modernizations of enterprise data solutions using Azure cloud data technologies.
• Design and Build Modern Data Pipelines and Data Streams.
• Develop and maintain data warehouse schematics, layouts, architectures and relational/non-relational databases for data access and Advanced Analytics.
• Implement effective metrics and monitoring processes.

Requirements:

• Demonstrated experience of turning business use cases and requirements to technical solutions.
• Experience in business processing mapping of data and analytics solutions.
• Ability to conduct data profiling, cataloging, and mapping for technical design and construction of technical data flows.
• The ability to apply such methods to solve busines s problems using one or more Azure Data and Analytics services in combination with building data pipelines, data streams, and system integration.
• Mastery of Python and SQL is required
• Knowledge of Azure Databricks, Azure Data Lake, Azure SQL Server, and Azure SQL is required.
• Experience preparing data and transforming Data.
• Experience in Data Migration is a plus.
• Demonstrated experience preparing data and building data pipelines
• Strong team collaboration and experience working with remote teams.
• Knowledge of Dev-Ops processes (including CI/CD) and Infrastructure as code fundamentals.
• Experience with Git/TFS/VSTS is a must.
• Travel as needed.
• Banking domain exp will be added advantage