Cloud Data Engineer - New Delhi, India - HTC Global Services

Description

The ideal candidate will have good understanding of Azure cloud and reporting for application hosted on Azure cloud, using ADF and Azure SQL.

· Experience working with Azure Services like

Azure Data Factory

, Logic App, Functions, Azure SQL DB, Blob Storage, Azure DevOps· Experience working with other Azure Services like Azure Database Migration Service, ADLS Gen2, Synapse Analytics is an added advantage.· Experience creating Azure Data Factory pipelines leveraging Data Movement activities, Data Transformation activities like Data Flow, Stored Procedure, Custom Activity, Azure Functions etc. and Control Flow Activities like web activity, lookup activity etc.· Deploy, schedule and monitor pipelines using Azure Data Factory.· Identify optimal data ingestion methods and develop batch processing solutions using Azure Data Factory.

Design, Develop, Migration, Integration and configuring an Azure infrastructureDetermining workloads requirements for Azure cloudRunning workloads securely on AzureImplementing Azure authentication and securing data on the cloudDesigning a business continuity strategy· Experience working with RDBMS preferably Azure SQL, Microsoft SQL Server.· Proficient in SQL, Transact-SQL and experience in developing Stored procedures.· Experience in any programming language, preferably C#, Python.· Expert level knowledge and usage of Azure Web Apps, Application Insights and Azure Active Directory· Must have expert level knowledge of Key Vault for application security for data in transit and rest.· Implementing Azure authentication and securing data on the cloud using Key Vaults and Azure AD· Good knowledge of Agile, DevOps delivery methodologies.· Interface with the business client to understand business needs and requirements, and to help develop and maintain the client relationship on a need basis.· Interface with the various IT teams in client to ensure that the reporting application meets all the requirements of the bank and stakeholders from multiple perspectives, including (but not limited to) Security, Redundancy, Storage, Performance, Mobile Readiness, etc.· Build stakeholder consensus and ensure everyone is on the same page, in agreement, and can visualize the solution being proposed· The candidate should have Advanced understanding of data integration, data virtualization, data federation, and database design techniques· The candidate should have Advanced knowledge of dimensional modeling, modeling for reporting applications, normalization techniques, forward-engineering, and reverse-engineering techniques· The candidate should have Knowledge of various process modeling techniques (activity hierarchy diagrams, data flow diagrams, sequence diagrams, workflow diagrams, system interface diagrams)· Maintain a comprehensive chronological trail of solution footprint and agreements and actively contribute to the technology stream of the project change control process.

Designing a business continuity strategy· Interface with the business client to understand business needs and requirements, and to help develop and maintain the client relationship on a need basis.· Interface with the various IT teams in Client to ensure that the application meets all requirements from multiple dimensions, including (but not limited to) Security, Redundancy, Storage, Performance, Mobile Readiness, Reporting etc.

Design, Develop, Migration, Integration and configuring of an Azure infrastructure· Build stakeholder consensus and ensure everyone is on the same page, in agreement, and can visualize the solution being proposed· Develop business cases, requirements, enterprise architecture blueprint, detailed blueprint and be the principle evangelize for the bespoke solution.· The candidate should be able to identity various solutions for a problem and provide the recommendation for a solution, based on identifiable and measurable factors.· Identify business and functional requirements by working with application end-users, and lead the collection, analysis, documentation, and coordination of those requirements· Maintain a comprehensive chronological trail of solution footprint and agreements and actively contribute to the technology stream of the project change control process.· Provide overall support to ensure the successful Analysis, Design, Development and Deployment of a cloud solution.

Also, provide support in developing training materials and conducting training from a technology platform perspective to various stakeholders.· Document and manage issues and actions for the various IT components in the solution· Prepare and make presentations using MS PowerPoint and Visio to project stakeholders and management· Participate in the evaluation of new products or initiatives to determine the technology support required· Evaluate applications and IT environments, and analyze gaps between current and desired states· Propose recommendations based on industry best practices