11+ HiveQL Jobs in Pune | HiveQL Job openings in Pune

Role Summary/Purpose:

We are looking for a Developer/Senior Developers to be a part of building advanced analytical platform leveraging Big Data technologies and transform the legacy systems. This role is an exciting, fast-paced, constantly changing and challenging work environment, and will play an important role in resolving and influencing high-level decisions.

Requirements:

• The candidate must be a self-starter, who can work under general guidelines in a fast-spaced environment.
• Overall minimum of 4 to 8 year of software development experience and 2 years in Data Warehousing domain knowledge
• Must have 3 years of hands-on working knowledge on Big Data technologies such as Hadoop, Hive, Hbase, Spark, Kafka, Spark Streaming, SCALA etc…
• Excellent knowledge in SQL & Linux Shell scripting
• Bachelors/Master’s/Engineering Degree from a well-reputed university.
• Strong communication, Interpersonal, Learning and organizing skills matched with the ability to manage stress, Time, and People effectively
• Proven experience in co-ordination of many dependencies and multiple demanding stakeholders in a complex, large-scale deployment environment
• Ability to manage a diverse and challenging stakeholder community
• Diverse knowledge and experience of working on Agile Deliveries and Scrum teams.

Responsibilities

• Should works as a senior developer/individual contributor based on situations
• Should be part of SCRUM discussions and to take requirements
• Adhere to SCRUM timeline and deliver accordingly
• Participate in a team environment for the design, development and implementation
• Should take L3 activities on need basis
• Prepare Unit/SIT/UAT testcase and log the results
• Co-ordinate SIT and UAT Testing. Take feedbacks and provide necessary remediation/recommendation in time.
• Quality delivery and automation should be a top priority
• Co-ordinate change and deployment in time
• Should create healthy harmony within the team
• Owns interaction points with members of core team (e.g.BA team, Testing and business team) and any other relevant stakeholders

Profile: AWS Data Engineer

Mode- Hybrid

Experience- 5+7 years

Locations - Bengaluru, Pune, Chennai, Mumbai, Gurugram

Roles and Responsibilities

• Design and maintain ETL pipelines using AWS Glue and Python/PySpark
• Optimize SQL queries for Redshift and Athena
• Develop Lambda functions for serverless data processing
• Configure AWS DMS for database migration and replication
• Implement infrastructure as code with CloudFormation
• Build optimized data models for performance
• Manage RDS databases and AWS service integrations
• Troubleshoot and improve data processing efficiency
• Gather requirements from business stakeholders
• Implement data quality checks and validation
• Document data pipelines and architecture
• Monitor workflows and implement alerting
• Keep current with AWS services and best practices

Required Technical Expertise:

• Python/PySpark for data processing
• AWS Glue for ETL operations
• Redshift and Athena for data querying
• AWS Lambda and serverless architecture
• AWS DMS and RDS management
• CloudFormation for infrastructure
• SQL optimization and performance tuning

• Promote insurance products and services through digital and offline marketing channels.

• Identify potential customers and generate qualified leads.

• Assist in organizing and participating in promotional campaigns, marketing initiatives,

and customer engagement activities.

• Support the sales team in pitching insurance plans and explaining product benefits.

• Collect and analyze market feedback for continuous improvement.

• Stay updated with industry trends and product knowledge.

• Maintain accurate records of outreach and customer interactions using CRM tools or

spreadsheets.

• Close sales deals and work towards achieving monthly/quarterly sales targets.

• Travel to different cities for client meetings, product demos, and business negotiations.

• Visit customer sites to understand requirements and build strong business relationships.

• Maintain proper documentation of leads, follow-ups, and sales activities.

• BizTalk Development:
• Design, develop, and deploy BizTalk solutions for integrating business processes.
• Build custom BizTalk maps, orchestrations, pipelines, and adapters to meet integration requirements.
• Troubleshoot and resolve issues with BizTalk applications, ensuring minimal downtime.
• Implement best practices for BizTalk development and integration.
• Create and maintain documentation related to BizTalk applications and processes.
• SQL Development & Management:
• Develop, optimize, and maintain SQL Server databases, including stored procedures, queries, and triggers.
• Write efficient SQL queries to extract, transform, and load data.
• Perform database tuning and optimization for performance improvements.
• Ensure database security, integrity, and backup.
• Conduct routine maintenance tasks such as patching and updates for SQL databases.
• Integration & Collaboration:
• Collaborate with business analysts and other developers to understand business requirements and integrate them into solutions.
• Participate in design and code reviews, ensuring quality and standards are adhered to.
• Assist in the deployment of BizTalk solutions and SQL database updates to production environments.
• Support Existing Systems:
• Provide ongoing support and maintenance for existing BizTalk applications, SQL databases, and integration processes.
• Troubleshoot, monitor, and optimize existing BizTalk integration workflows, databases, and related services.
• Ensure smooth operations by resolving issues and improving the performance of legacy systems.
• Monitoring & Support:
• Monitor the performance of BizTalk applications and SQL databases to ensure optimal performance.
• Provide ongoing support for BizTalk integrations and SQL database issues.
• Troubleshoot and resolve technical issues related to integrations and SQL queries.
• Provide 2nd/3rd line support for any issues that arise in the production environment.

Required Skills & Qualifications:

• Technical Skills:
• Strong experience with BizTalk Server (preferably BizTalk 2016 or later).
• Expertise in creating and managing BizTalk orchestrations, maps, and pipelines.
• Proficient in SQL Server (SQL Server 2012/2014/2016/2017/2019).
• Experience with T-SQL, stored procedures, triggers, views, and indexes.
• Familiarity with SQL Server Management Studio (SSMS) and SQL Server Integration Services (SSIS).
• Knowledge of web services (SOAP, REST) and messaging formats (XML, JSON).
• Experience with BizTalk adapters and message brokers.
• Analytical and Troubleshooting Skills:
• Strong problem-solving skills with the ability to debug and troubleshoot BizTalk and SQL issues.
• Ability to quickly understand new systems and integrations and provide efficient solutions.

Skills: SFDC developer, classic, lightening, Apex, VF

Notice period : 60days

After shortlisting will schedule interview

1st round: Zoom( 1pm -5pm)

SFDC- Pune

5-8yrs-20lpa

8-10yrs-25lpa