Chennai, Tamil Nadu, India
Information Technology
Other
Clarion Technologies
Overview
ID : 2564
Experience
5 - 7 years
Location
Pune
About Clarion Technologies
Clarion Technologies is an IT services company providing customized software solutions to small & medium businesses globally in a broad spectrum of industries. With 20+ years of expertise in Digital Transformation, we help our customers to improve their business performance significantly. With cutting-edge technology, Agile development, and best coding practices, we are proud to offer one of the most Usable, Reliable, and Secure software solutions. We are certified as a CMMI level 3 company, Great Place to Work in 2019 & Top Software Developers in India by Clutch. -head office in Pune, India, we have two state-of-the-art delivery centers in Pune and Ahmedabad.
About The Role
We are seeking an experienced SQL Developer with a strong background in handling large datasets and optimizing database performance. The ideal candidate will be responsible for maintaining and evolving Data Warehouse structures that support BI and analytics use cases. While deep BI tool knowledge is not mandatory, a basic understanding of Power BI or similar tools is a plus.
Job Responsibilities
Job Description
We are seeking an experienced SQL Developer with a strong background in handling large datasets and optimizing database performance. The ideal candidate will be responsible for maintaining and evolving Data Warehouse structures that support BI and analytics use cases. While deep BI tool knowledge is not mandatory, a basic understanding of Power BI or similar tools is a plus.
Key Responsibilities
- Develop and optimize complex SQL queries for large and complex datasets.
- Monitor and enhance query performance, indexing strategies, and data access patterns.
- Design and maintain schema changes in the Data Warehouse in support of BI and reporting needs.
- Collaborate with BI developers and business stakeholders to ensure data models align with reporting requirements.
- Implement and manage data pipelines for transforming and loading data into the warehouse.
- Work closely with teams to troubleshoot data discrepancies and performance bottlenecks.
- Ensure data accuracy, consistency, and integrity across integrated systems.
Education & Experience
- Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field.
- 5+ years of experience in SQL development with large datasets in enterprise environments.
- 2+ years of experience in managing and maintaining Data Warehouses (on-prem or cloud-based).
- Exposure to BI tools (Power BI, Tableau, etc.) is a plus but not required.
Technical Skills
Must Have: Expert-level SQL skills, including stored procedures, CTE, views, indexing, joins, partitioning, and performance tuning.Experience with database platforms such as MS SQL Server, Azure SQL.Solid understanding of data warehousing concepts, dimensional modeling.
Good To Have:Scheduling jobs in SQL server agentFamiliarity with ETL/ELT tools or frameworks like SSIS, SSAS TabularBasic knowledge of PowerBIExperience with scripting or programming languages (e.g., C#, PowerShell) is a plus.
Soft Skills
- Strong analytical thinking and attention to detail when working with complex data models.
- Good communication skills to interact with BI/Analytics teams and business stakeholders.
- Self-driven and capable of working independently in a remote or hybrid setup.
- Agile/Scrum team experience is preferred.
Job Requirements
We are seeking an experienced SQL Developer with a strong background in handling large datasets and optimizing database performance. The ideal candidate will be responsible for maintaining and evolving Data Warehouse structures that support BI and analytics use cases. While deep BI tool knowledge is not mandatory, a basic understanding of Power BI or similar tools is a plus.Create and maintain .NET console applications for autom
Similar Jobs
View All
1 Day ago
Software Developer 4
Information Technology
- Bangalore, Karnataka, India
Job DescriptionDesign, develop, troubleshoot and debug software programs for databases, applications, tools, networks etc.ResponsibilitiesAs a member of the software engineering division, you will take an active role in the definition and evolution ...
1 Day ago
Software Developer (ReactJS & DotNet) in Faridabad, Noida, Palwal, Ballabgarh
Information Technology
- Bangalore, Karnataka, India
As a Software Developer at Digital Shahi Pvt. Ltd., you will have the opportunity to work on cutting-edge technologies such as ReactJS, DotNet, MongoDB, MERN stack, and Node.js. Join our dynamic team and be a part of revolutionizing the digital land...
1 Day ago
iOS Developer - Objective C/SWIFT
Information Technology
- Bangalore, Karnataka, India
Job DescriptionWe are looking for a skilled and enthusiastic iOS Developer to join our team. The candidate will have experience developing and maintaining mobile applications on the iOS platform and possess a passion for creating user-friendly and h...
1 Day ago
Manual/Automation Tester
Information Technology
- Thiruvananthapuram, Kerala, India
Job DescriptionThis is a full-time on-site role located in Hyderabad. As a Testing professional with 0-2 year of experience, you will be responsible for conducting testing activities, including developing and executing test plans, test cases, and te...
1 Day ago
Sr. Software Engineer - iOS Development
Information Technology
- Thiruvananthapuram, Kerala, India
Position Description: As a Senior Software Engineer, iOS Developer, you will contribute to the development of intuitive, high-performance iOS applications for enterprise use. This role focuses on implementing features and improving the product exper...
1 Day ago
Sr. Software Engineer
Information Technology
- Thiruvananthapuram, Kerala, India
What you will do: Design, develop, enhance, and test software / embedded software for medical and connectivity products for R&D department. Closely work with peers in software engineering, software quality assurance and project & product management ...
1 Day ago
PHP Developer - Laravel Frameworks
Information Technology
- Thiruvananthapuram, Kerala, India
Location: Pune, Bengaluru, Chennai, Hyderabad, GurugramWork Model: Hybrid (3 days from office)Experience Required: 10+ yearsRole Type: Individual ContributorClient: US-based multinational banking institutionNotice Period: Immediate to 21 daysRole Su...
1 Day ago
Data Engineer - Generative AI
Information Technology
- Thiruvananthapuram, Kerala, India
About The RoleWe are seeking a skilled and passionate Data Engineer to join our team and drive the development of scalable data pipelines for Generative AI (GenAI) and Large Language Model (LLM)-powered applications. This role demands hands-on exper...
Talk to us
Feel free to call, email, or hit us up on our social media accounts.
Email
info@antaltechjobs.in