Job Description

Job:
IRC173006


Location:
India - Nagpur


Designation:
Associate Consultant


Experience:
5-10 years


Function:
Engineering


Skills:
Data Warehousing

Description:

IT is seeking an experienced data warehouse engineer for our data engineering organization. As a member of our team, you will ensure all warehouse data is accurate and resolve any data issues. This role requires a deep understanding of data modeling and integration practices to efficiently ingest, transform, and provision data across various sources into an organized and unified data warehouse.

Requirements:

• 5+ years of substantive relevant data warehousing and data modeling experience required.
• Strong understanding of Normalized/Dimensional model disciplines and similar data warehousing techniques
• Expert in SQL and/or SQL-based languages and performance tuning of SQL queries
• Strong experience working with ETL/ELT concepts of data integration, consolidation, enrichment, and aggregation in large volume data sets.
• Working knowledge of Data Pipelines, stream processing and highly scalable \xe2\x80\x98big data\xe2\x80\x99 data stores
• Experience with various data storage technologies \xe2\x80\x93 e.g. RDBMS (Oracle, SQL Server, etc.), NoSQL (AWS DynamoDB, Azure CosmosDB), cloud storage (ADLS, S3).
• Experience with cloud-based data warehouses \xe2\x80\x93 e.g. Snowflake, BigQuery, Azure Synapse, RedShift, etc.
• Able to create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
• Collaborate with business users on normalizing and aggregating large data sets based on business needs and requirements.
• Data validation skills to verify data integrity, understand discrepancies, and resolve them with the highest sense of urgency.
• Strong analytic skills related to working with complex datasets required.
• Strong analytical and organizational skill.
• Strong interpersonal, oral, and written communication skills.
• Excellent attention to detail.
• Able to effectively work independently and as part of a team.
• Familiarity with Analytical/Reporting Solutions like Tableau, Power BI is a plus.
• Knowledge of CI/CD pipeline is a plus.
• Experience with scripting languages \xe2\x80\x93 e.g. PowerShell, Python, etc is a plus.

Preferences:

SQL, python,Snowflake, BigQuery, Azure Synapse, RedShift,data warehousing and data modeling, powershell

Job Responsibilities:

• Design, code, test, and deploy new data warehouse and tabular model features.
• Design and implement ETL procedures for intake of data from both internal and external sources, using star schema and dimensional modeling.
• Provide guidance on data modeling best practices for the warehouse and tabular models.
• Carry out monitoring, tuning, and database performance analysis.
• Troubleshoot production support issues.
• Ensure that the established standards are followed for application architecture, development, documentation and deployment.
• Work with the team to evaluate business needs and priorities, liaise with key business partners and address team needs related to data systems and management.
• Provide guidance on best practices for Business Intelligence data architecture.

What We Offer

Exciting Projects: We focus on industries like High-Tech, communication, media, healthcare, retail and telecom. Our customer list is full of fantastic global brands and leaders who love what we build for them. Collaborative Environment: You Can expand your skills by collaborating with a diverse team of highly talented people in an open, laidback environment \xe2\x80\x94 or even abroad in one of our global centers or client facilities! Work-Life Balance: GlobalLogic prioritizes work-life balance, which is why we offer flexible work schedules, opportunities to work from home, and paid time off and holidays. Professional Development: Our dedicated Learning & Development team regularly organizes Communication skills training(GL Vantage, Toast Master),Stress Management program, professional certifications, and technical and soft skill trainings. Excellent Benefits: We provide our employees with competitive salaries, family medical insurance, Group Term Life Insurance, Group Personal Accident Insurance , NPS(National Pension Scheme ), Periodic health awareness program, extended maternity leave, annual performance bonuses, and referral bonuses. Fun Perks: We want you to love where you work, which is why we host sports events, cultural activities, offer food on subsidies rates, Corporate parties. Our vibrant offices also include dedicated GL Zones, rooftop decks and GL Club where you can drink coffee or tea with your colleagues over a game of table and offer discounts for popular stores and restaurants!

About GlobalLogic

GlobalLogic is a leader in digital engineering. We help brands across the globe design and build innovative products, platforms, and digital experiences for the modern world. By integrating experience design, complex engineering, and data expertise\xe2\x80\x94we help our clients imagine what\xe2\x80\x99s possible, and accelerate their transition into tomorrow\xe2\x80\x99s digital businesses. Headquartered in Silicon Valley, GlobalLogic operates design studios and engineering centers around the world, extending our deep expertise to customers in the automotive, communications, financial services, healthcare and life sciences, manufacturing, media and entertainment, semiconductor, and technology industries. GlobalLogic is a Hitachi Group Company operating under Hitachi, Ltd. (TSE: 6501) which contributes to a sustainable society with a higher quality of life by driving innovation through data and technology as the Social Innovation Business.