WPP Hiring For 2024 | Azure Data Engineer | Apply Here !!

Required Qualifications & Skills:

• Bachelor’s degree in Computer Science, Engineering, Mathematics, or other technical fields is highly preferred.
• Experience in creating and managing SQL Server Integration Services (SSIS) processes and writing TSQL (views/functions/stored procedures).
• Experience with data modeling and working with star schema.
• Ability to understand and communicate business requirements from non-technical stakeholders while managing their expectations.
• Experience with the full development life cycle of an application stack – from architecture through test and deployment.
• Knowledge and experience with Master Data Management.
• Experience in data warehouse analysis and design, with full knowledge of data warehouse methodologies and data modeling.
• Experience in unit testing SQL scripts, stored procedures, ETL modules; Integration testing data transition points; Performance, load, and stress testing.
• Knowledge and experience in Agile development methodology and toolset.
• Experience with TFS/GIT code repository, branching strategies, Microsoft Release Management, deployment tools, and Jira.
• Experience with Azure cloud solutions; Knowledge of Azure Data Factory, Azure Automation, Azure Data Lake, and Azure Data Lake Analytics.
• Experience with APIs.
• Team player
• Organized and detail-oriented
• Excellent communication, presentation, and writing skills
• Thrives in a fast-paced, constantly changing environment

Job Description & Responsibilities:

• Assist in the build, development, and management of custom databases/solutions using SQL and SSIS both on-premise and in Azure.
• Clearly communicate technical terms to non-technical people and help them understand why changes might be required to achieve a specific goal or to complete a project.
• Design, build, and deploy ETL and data management processes. Develop and deploy ETL job workflow with reliable error/exception handling and rollback framework.
• Build and oversee data architecture & pipelines platforms and systems, managing the flow of data from internal and external sources by leveraging both distributed and local structures.
• Participate in developing, designing, configuring, and documenting database architecture.
• Conform to agile development practices – Evolutionary design, refactoring, continuous integration/delivery, test-driven development.
• Work collaboratively with the Business Partner Team and Business Stakeholders during project scoping and feasibility phases as an SME for concept investigation/viability and technical impact; Identify and communicate technical risks and mitigations.
• Provide production support for data load jobs.
• Write customized queries to generate automatic periodic reports.
• Build applications by writing SQL scripts to manipulate data and/or writing specific instructions for an off-shore programmer to write the scripts.
• Maintain or upgrade existing applications.
• Attend key design meetings and provide support.
• Perform other ad hoc duties as assigned.