Sr Data Warehouse Engineer

Vadodara, Gujarat
Permanent
Full-time

2 months ago

Exp 7+ yrsLocation - Remote (Initially the person has to come down at our Vadodara office for 5 days - Travel and hotel stay provided) and then its remote.CTC upto 23 LPAShift - 3PM to 12 (midnight)Key ResponsibilitiesData Warehouse Development: Responsible for managing a single version of the truth and turning data into critical information and knowledge that can be used to make sound business decisions.Dimensional Modeling: Convert business entities into facts and dimensions to provide a structured and efficient data model that supports accurate and insightful business analysis.Data Integration: Collaborate with cross-functional teams to integrate data from various source systems such as Oracle NetSuite, Salesforce, Ragic, SQL Server, MySQL, and Excel files.Data Transformation: Develop and maintain ETL processes using Microsoft SSIS, Python or similar ETL tools to load data into the data warehouse.Performance Optimization: Optimize queries, indexes, and database structures to improve efficiency.Requirement Analysis: Work closely with key users and business stakeholders to define requirements.Documentation: Maintain comprehensive technical documentation for data warehouse processes, data integration, and configurations.Team Collaboration: Mentor and guide junior team members, fostering a collaborative environment.

Must have
Bachelors or Masters degree in Computer Science, Information Technology, or a related field.
7+ years of experience with Microsoft SQL Server.
Expertise in building Data Warehouse using SQL Server.
Hands-on experience Dimensional Modeling using Facts and Dimensions.
Expertise in SSIS and Python for ETL development.
Strong experience in Power BI for reporting and data visualization.
Strong understanding of relational database design, indexing, and performance tuning.
Ability to write complex SQL scripts, stored procedures and views.
Experience with Git and JIRA.
Problem-solving mindset and analytical skills.
Excellent communication and documentation abilities.

Nice to Haveo Experience with cloud-based SQL databases (e.g., Azure SQL, Azure Synapse).o Experience with cloud-based ETL solutions (Azure Data Factory, Azure Databricks).o Familiarity with CI/CD for database deployments and automation tools.o Knowledge of big data technologies like Snowflake

Expertia AI Technologies

Apply Now