Title : Database Engineer(MongoDB, PostgreSQl) , Pune
Designation : Database Engineer
Qualifications: BE/MCA/BCA/MCS/BCS
Salary : Upto 7 LPA
Location : Baner, Pune
Job Description :
Roles and Responsibilities:
Develop and maintain data pipelines.
Handle all data related activities such as data parsing, cleansing, storage etc.
Support in building ETL queries using Apache Spark as required by the product and analyst teams.
Assemble large, complex data sets that meet functional / non-functional business requirements.
Identify, design, and implement internal process improvements: automating manual processes optimizing data delivery, re-designing infrastructure for greater scalability, etc.
The ability to write queries that perform optimally.
Analysis and Design database structure as per requirement.
Reviewing query performance and optimizing code.
Writing queries used for front-end applications (websites, desktop applications, mobile apps or cloud apps).
Designing and coding database tables to store the application's data.
Data modeling to visualize database structure.
Working with application developers to create optimized queries.
Creating database triggers for automation, e. g., automatic email notifications
Creating table indexes to improve database performance.
Programming views, stored procedures, and functions
Experience and Skills
Strong experience in SQL.
Good working experience in python.
Experience in building data pipelines is a plus.
Working knowledge of AWS is a plus.
Experience building and optimizing big data, data pipelines, architectures, and data sets.
A successful history of manipulating, processing, and extracting value from large, disconnected datasets.
3+ years working as a database engineer working with MongoDB, BI (SSIS, SSRS), SQLite and PostgreSQL.
Experience in analytics, creating quick dashboards using Firebase queries and google analytics.
Knowledge of database design principles, query optimization, index management, integrity checks, statistics, and isolation levels.
Able to handle multiple tasks in a fast-paced environment.
Strong data analytical skills
Qualifications
3+ Years of work experience as a Data Engineer and advanced SQL coding, tuning and query optimization.
Systematic problem-solving approach, coupled with effective communication skills and a sense of drive.
Strong project management and organizational skills.
Experience supporting and working with cross-functional teams in a dynamic environment.
Experience troubleshooting applications and system performance and complex, production software issues.
Ability to tune databases based on explain plans overall system behavior. Ability to tune complex workloads.
Understanding of overall system architecture, scalability, reliability, and performance in a database
environment.
Development skills are highly desirable.
Experience designing and leading database performance benchmarks.
Experience with large-scale data analytics and data warehousing
IdealCrew Technology We are the leading IT ConsultancyServices based in pune. we provide candidates to manufacturing, IT ,NON IT ,chemical company in PAN India location.