Hyderabad Jobs |
Banglore Jobs |
Chennai Jobs |
Delhi Jobs |
Ahmedabad Jobs |
Mumbai Jobs |
Pune Jobs |
Vijayawada Jobs |
Gurgaon Jobs |
Noida Jobs |
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 |
Job Location | Pune |
Education | Not Mentioned |
Salary | Rs 10 - 16 Lakh/Yr |
Industry | IT - Software |
Functional Area | General / Other Software |
EmploymentType | Full-time |
Dear Candidate,Greetings of the day!We are Hiring forData warehouse DeveloperUnderstand business requirements and effectively translate them into a dimensional model. Work with the infrastructure team to ensure uptime and timely backups of the database Build and manage data pipelines from operational systems till the Enterprise Datawarehouse (EDW). Implement data validations, data cleansing and profiling on the data as a part of the data pipeline. Adapt to multiple data platforms as per the needs of the organization. Create and change stored procedures, user-defined functions, tables, views, indexes. Optimize SQL queries to achieve faster execution times and performance. Assist in loading the processed data to BI tools and dashboards. Maintain documentations for the data warehouse tables and all the ETL processes.Candidate Profile Description:5-7 years experience in Data Warehousing. Extensive experience in writing SQL queries in a Data Warehousing environment. Hands on experience in writing ETLs using stored procedures and functions. Good troubleshooting skills in fixing issues and doing query optimizations Has an in-depth knowledge and experience with writing ETLs, dimensional modeling and design, data cleansing, data validations, data profiling, star and snowflake scheme architectures, 3NF data marts. Have the ability to communicate in a lucid and clear manner with the team and Knowledge of SQL and programming constructs like stored procedures, user-defined functions on MySQL 8.0. Should be familiar with Git. Exposure to AWS would be an added advantage. Knowledge of Python/Java, bash scripting, linux command line would be desirable. Exposure to Kafka, Spark, Hadoop, ELK Stack would be good to have.Regards,HR Team
Keyskills :
data warehousingsqldashboardssql serverprogrammingjavalinuxmysqlpythondatawarehouse