skillindiajobs
Register for Job
Hyderabad Jobs
Banglore Jobs
Chennai Jobs
Delhi Jobs
Ahmedabad Jobs
Mumbai Jobs
Pune Jobs
Vijayawada Jobs
Gurgaon Jobs
Noida Jobs
Oil & Gas Jobs
Banking Jobs
Construction Jobs
Top Management Jobs
IT - Software Jobs
Medical Healthcare Jobs
Purchase / Logistics Jobs
Sales
Ajax Jobs
Designing Jobs
ASP .NET Jobs
Java Jobs
MySQL Jobs
Sap hr Jobs
Software Testing Jobs
Html Jobs
IT Jobs
Logistics Jobs
Customer Service Jobs
Airport Jobs
Banking Jobs
Driver Jobs
Part Time Jobs
Civil Engineering Jobs
Accountant Jobs
Safety Officer Jobs
Nursing Jobs
Civil Engineering Jobs
Hospitality Jobs
Part Time Jobs
Security Jobs
Finance Jobs
Marketing Jobs
Shipping Jobs
Real Estate Jobs
Telecom Jobs

Lead SQL Developer -MNC @ Mumbai

8.00 to 13.00 Years   Mumbai City   19 Jan, 2023
PES HR Services
Job LocationMumbai City
EducationNot Mentioned
SalaryNot Disclosed
IndustryIT - Software
Functional AreaApplication Programming / Maintenance
EmploymentTypeFull-time

Job Description

    We have immediate opening for SQL Lead @ MumbaiExp : 8+ YearsJob Location : Seepz,AndheriJob role :* Min. 8 years of experience.* Deep understanding and implementation experience in designing and developing ETL processes that populate star schemas using a variety of source data on data warehouse implementations supporting a product on both cloud as well as on premise.* Solid understanding of design patterns and implementation experience in data modeling in SQL, NoSQL spanning OLTP to OLAP (dimensional analysis and fact design).* Solid understanding of design patterns and implementation experience in data pipelines - Streaming (real-time) and Batch processing.* Design and develop SQL procedural logic, functions, data materialization and triggers to be used during the ETL process.* Hands-on with proactive and reactive performance tuning instance-level, database-level and query-level.* Strong data analysis implementation experience - exploratory, time-series, data profiling etc.* Will be responsible for success of the engagement working closely with the client stakeholders (Technical SPOC)* Primary contact for the client team on technical aspects* Experience in the requirements gathering process and ability to design the business process dimensional models.* Work with data providers to fill data gaps and/or to adjust source-system data structures to facilitate analysis and integration with other company data.* Basic understanding of scripting such as using Python.* Good understanding and preferably experience in all data areas on Cloud platforms.* Good working experience on data visualization and reporting.* Good working experience with Data Governance - row-level security, role-based access strategy, encryption and masking of data, passwordless authentication etc.* Perform analysis on source data to determine the feasibility of using this data to solve business needs.* Good understanding and previous implementation experience in high availability and disaster recovery implementation on premise.* Write scripts for automated testing of data in the target facts and dimensions.* Prepare and establish update process for technical artefacts such as data catalog, ER diagrams, Non-Functional requirements, data flow diagrams etc.* Experience in conducting and responding to database audits information during all phases of the ETL process including code reviews and refactoring recommendations.* Excellent troubleshooting skills.* Whatever else asked for the good of the company goals and initiatives.* Implementation experience on Google Cloud Platform - BigQuery, Composer and Cloud Data Fusion.If interested kindly revert with following details on hidden_email:Total Experience:Relevant Experience :CCTC:Notice Period:Reason For Change:Current Location:DOB:Thanks & Regards, Pranjali IT Recruiter-TLhidden_email

Keyskills :
nosqlolapdata modelingoltpsqletlperformance tuningfunctionssql lead

APPLY NOW

Lead SQL Developer -MNC @ Mumbai Related Jobs

© 2020 Skillindia All Rights Reserved