Senior Specialist - Data Engineer

Posted:
7/31/2024, 5:00:00 PM

Location(s):
Haryana, India ⋅ Gurugram, Haryana, India

Experience Level(s):
Senior

Field(s):
Data & Analytics

Workplace Type:
Hybrid

You are as unique as your background, experience and point of view. Here, you’ll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspire and help you reach your potential and soar to new heights. Every day, you'll have new and exciting opportunities to make life brighter for our Clients - who are at the heart of everything we do. Discover how you can make a difference in the lives of individuals, families and communities around the world.

Job Description:

  • Efficient in developing and presenting database solutions to key stakeholders and onsite partners
  • Participate in the technical design, development, testing and user documentation and processes
  • Should be able to reverse engineer SQL/SSIS code units and re write in efficient and optimized manner
  • Very good experience in writing complex SQL queries, Stored Procedures, User Define Functions, Views, indexes and views with performance tuned
  • Builds ETL processes for cleansing, staging, migrating data from various sources(Relational, Big data) to data warehouse
  • Strong proficiency in MS SQL Server and prior experience in MS SQL Server performance tuning like Query Optimization, Indexing Strategies
  • Excellent understanding of indexes, locks, execution plans and file stats
  • Experience in Data Modeling, Database design and well versed with SQL Server best practices 
  • Experience with hybrid data environments that leverage both distributed and relational database  technologies to support analytics services
  • Good knowledge of Big Data querying tools, such as Pig, Hive, and Impala
  • Knowledge of various ETL techniques and frameworks, such as Flume
  • Diligently performs quality assurance and risk assessment guidelines to minimize operational, reputation, and legal risk
  • Foster a work environment that values people and encourages participation, creativity, learning, and accountability

Job Category:

Advanced Analytics

Posting End Date:

29/08/2024