SQL Developer

2 days ago

Gurugram, India Intellismith pvt Ltd Full time

SQL Developer

Location : Gurgaon, India (Onsite - Work From Office only)

Experience : 4-8 Years

Employment Type : Full-time

Education : B.Tech, BCA, MCA

Notice Period : Immediate joiner only

Job Overview :

We're looking for a highly skilled SQL Developer with 4-8 years of hands-on experience in Hive, Big Data ecosystems, and various RDBMS platforms like Oracle or PostgreSQL. You'll be instrumental in developing complex, optimized SQL queries, ensuring high performance, and building reliable data pipelines for performance-critical systems. This role demands a deep understanding of data modeling, query optimization techniques, and the ability to collaborate effectively with cross-functional teams to deliver robust, data-driven solutions while maintaining data integrity and security.

Key Responsibilities :

- Develop, write, and maintain complex SQL queries and stored procedures across diverse data platforms, including relational databases (e.g., Oracle, PostgreSQL) and Hive tables within a Big Data ecosystem.

- Conduct advanced performance tuning and query optimization (e.g., indexing strategies, query plan analysis, partitioning) to ensure efficient data retrieval and processing for high-volume, performance-critical systems.

- Design, build, and optimize ETL/ELT processes for data ingestion, transformation, and loading from various source systems into target data warehouses or data lakes.

- Collaborate closely with data architects, data engineers, business intelligence analysts, and product managers to understand complex business requirements and translate them into robust, scalable data solutions.

- Develop and deliver useful reporting deliverables by extracting, transforming, and presenting data in formats suitable for business intelligence tools and dashboards.

- Ensure stringent data integrity, consistency, and security across all database systems and data pipelines, adhering to best practices and compliance requirements.

- Create and maintain comprehensive technical documentation for database schemas, data dictionaries, ETL processes, and complex SQL logic.

- Participate in database design discussions, contributing insights on normalization, denormalization, and data modeling best practices.

- Troubleshoot and resolve data-related issues, performing root cause analysis to prevent recurrence.

Required Skills :

- 4-8 years of dedicated experience as a SQL Developer.

- Expert-level proficiency in Advanced SQL, including complex joins, subqueries, window functions, CTEs, and procedural SQL.

- Strong hands-on experience with Hive QL and understanding of its architecture within a Hadoop/Big Data ecosystem.

- Proven experience with performance tuning, query optimization, and data modeling (dimensional and relational).

- Hands-on experience working with at least two different RDBMS platforms (e.g., Oracle, PostgreSQL, MySQL, SQL Server).

- Familiarity with ETL/ELT pipelines and data warehousing concepts.

- Strong analytical and problem-solving skills with meticulous attention to detail.

- Excellent verbal and written communication skills to articulate technical concepts and collaborate effectively with diverse teams.

Preferred Qualifications :

- Experience with cloud-based data warehouses like Snowflake or AWS Redshift.

- Knowledge of scripting languages such as Python for data manipulation or automation tasks.

- Familiarity with data visualization tools (Tableau, Power BI).

- Experience with version control systems (Git) for SQL scripts and database objects


(ref:hirist.tech)

  • SQL Developer

    2 days ago

    Gurugram, India Targeticon Digital Services Pvt. Ltd. Full time

    Role Summary :We are looking for a highly motivated and detail-oriented SQL Developer with 2-3 years of experience in Microsoft SQL Server to join our growing team. This role will focus on developing, maintaining, and optimizing SQL-based solutions to support mission-critical Payroll and HRIS applications. The ideal candidate will have a strong foundation in...

  • SQL/Senior SQL Developer

    2 weeks ago

    Gurugram, Vadodara, India AIS business solution Full time ₹ 1,04,000 - ₹ 1,30,878 per year

    Role & responsibilitiesHelp write and optimize in-application SQL statementsEnsure performance, security, and availability of databasesPrepare documentations and specifications • Profile server resource usage, and optimize and tweak as necessaryCollaborate with other team members and stakeholdersTranslate business needs to technical specificationsDesign,...

  • SQL Developer

    2 weeks ago

    Bengaluru, Gurugram, Pune, India Innova AM Tech Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Notice: - Immediate Joiners OnlyDesign, develop, and maintain SQL Server Analysis Services (SSAS) modelsCreate and manage OLAP cubes to support business intelligence reportingDevelop and implement multidimensional and tabular data modelsOptimize the performance of SSAS solutions for efficient query processingIntegrate data from various sources into SQL...

  • ▷ [3 Days Left] Senior SQL Developer

    2 days ago

    Gurugram, India V2 Retail Full time

    Job Description Role Overview: We are seeking a skilled and experienced SQL Developer / Database Engineer to design, develop, and optimize database solutions that support mission-critical applications and business intelligence needs. The ideal candidate will have advanced SQL expertise, experience in performance tuning, and a strong understanding of...

  • SQL Dba

    4 days ago

    Gurugram, Haryana, India Flairdeck Consulting Full time

    Hiring for SQL DBA For our client based at Gurugram Experience: 7+ years **Salary**: 15- 22LPA ONLY IMMEDIATE JOINERS - Proficient in managing SQL Server environments with Always On Availability Groups. - Experience in planning, executing, and verifying patches and updates to ensure high availability and mínimal downtime. - Understanding of SQL Server...

  • SQL Dba

    1 week ago

    Gurugram, Haryana, India iSHR Full time

    **About the job SQL DBA**: We need **SQL DBA Developer** **Stored Procedure** Mandatory Experience**:3 to 4 Years** Location**:Gurgaon: Onsite** Immediately to 10 Days Joiner Only Developer who has to Join with his Own Laptop Budget is **50-60 K/Month** Duration**:6 Months Initially**: Extendable as per Performance

  • SQL/ Pl-SQL

    1 week ago

    Gurugram, Haryana, India Mantra Labs Full time

    Gurugram, Haryana, India- Permanent- Software Engineering & Technology- 3 - 5 years**Job Description**: - SQL/PL-SQL with Ingenium knowledge - Good communication skills - Hands-on experience with database queries - Aware of Ingenium workflows and backend DB2 data model Experience Range: 3 - 5 years Educational Qualifications: Any graduation, Skills...

  • Snowflake SQL

    2 weeks ago

    Gurugram, Haryana, India Virtusa Full time

    **Skill: Snowflake** Role / Tier: - T2 /T3 Location: Bangalore/Hyderabad/ Gurgaon Snowflake SQL Writing SQL queries against Snowflake Developing scripts to do Extract, Load, and Transform data. Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, Python, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, and stored...

  • Senior.Net Developer

    2 days ago

    Gurugram, India Impetus Career Consultants Private Limited Full time

    Key Responsibilities :- Design, develop, and maintain .NET Core Windows Services, Web Services, and Web Applications using C#.- Diagnose and troubleshoot complex technical issues across application layers.- Collaborate with cross-functional teams to define, design, and ship new features.- Manage and maintain Windows Server-based infrastructure.- Optimize...

  • SQL Specialist

    1 week ago

    Bengaluru, Gurugram, Pune, India Mobile Programming Full time ₹ 15,00,000 - ₹ 28,00,000 per year

    Core Mandatory Skills (Must-Haves):Microsoft SQL Server (5+ years hands-on): T-SQL, stored procedures, indexes, query tuningOracle to SQL Server migration experience: schema conversion, data type mapping, transformation logic, and validationPL/SQL to T-SQL conversion: rewriting/optimizing in T-SQLPerformance tuning: optimizing queries, procedures, and...