Senior Data Engineer - ETL/Data Warehousing

Role/Title: Senior Data Engineer Experience: 6-10 Years' experience Location: Pune Notice period: 0-30days only. Key Skills: Oracle HCM Cloud, Fast formulas, HDL, OTBI, BI Publisher Job Summary: As a Senior Data Engineer, you will support the European World Area using the Windows & Azure suite of Analytics & Data platforms. The focus of the role is on the technical aspects and implementation of data gathering, integration and database design. Job Ingestion and Integration : Collaborate with Product Owners and analysts to understand data requirements & design, develop, and maintain data pipelines for ingesting, transforming, and integrating data from various sources into Azure Data Services. Data Modelling: Assist in designing and implementing data models, data warehouses, and databases in Azure Synapse Analytics, Azure Data Lake Storage, and other Azure services. Data Transformation: Develop ETL (Extract, Transform, Load) processes using SQL Server Integration Services (SSIS), Azure Synapse Pipelines, or other relevant tools to prepare data for analysis and reporting. Data Quality and Governance: Implement data quality checks and data governance practices to ensure the accuracy, consistency, and security of data assets. Monitoring and Optimization: Monitor and optimize data pipelines and workflows for performance, scalability, and cost efficiency. Documentation: Maintain comprehensive documentation of processes, including data lineage, data dictionaries, and pipeline schedules. Collaboration: Work closely with cross-functional teams, including data analysts, data scientists, and business stakeholders, to understand their data needs and deliver solutions accordingly. Azure Services: Stay updated on Azure data services and best practices to recommend and implement improvements in our data architecture and processes. Skills Required: 6-10 years of experience in Data Warehousing with On-Premises or Cloud technologies Strong practical experience of developing ETL packages using SSIS. Strong practical experience with T-SQL or any variant from other RDBMS. Knowledge of Power BI, concentrating on Data Modelling rather than visualizations Graduate degree educated in computer science or a relevant subject. Strong analytical and problem-solving skills. Strong communication skills in dealing with internal customers from a range of functional areas. Willingness to work flexible working hours according to project requirements. Technical documentation skills. Fluent in English. Preferred PL/SQL. Experience in working on Azure Services like Azure Synapse Analytics, Azure Data Lake. Working experience with Azure DevOps paired with knowledge of Agile and/or Scrum methods of delivery. Languages: French, Italian, or Spanish would be an advantage. Agile certification. (ref:hirist.tech)

Location: Pune, IN

Posted Date: 4/24/2024