Database Specialist - Python

Description :

Position : Database Specialist

Experience : 4 to 7 yrs

Job Location : Chennai / Bangalore

Job Type : Permanent & Work From Office

Qualification : B.Tech / B.E / MCA

Job Summary :

We are looking for a highly skilled Database & Data Engineering Specialist with strong expertise in designing and managing data pipelines, integrating data from diverse sources, and working within Agile teams. The ideal candidate will have hands-on experience in Python, SQL, API development, and data modelling, along with a solid understanding of statistics and database optimization.

Must-Have Skills :

- Experience in creating data pipelines and integrating data from multiple sources using ETL/ELT processes.

- Strong knowledge of Python (data types, decorators, generators, Pandas, NumPy).

- Proficiency in SQL (joins, window functions, normalization) and familiarity with NoSQL databases.

- Ability to deliver solutions using Agile methodology.

Key Responsibilities :

- Design, develop, and maintain efficient and scalable data pipelines for structured and unstructured data.

- Integrate data from multiple internal and external sources using ETL/ELT processes.

- Collaborate with cross-functional teams to deliver data solutions in Agile sprints.

- Ensure data integrity, quality, and security across systems.

- Optimize database performance and troubleshoot issues proactively.

- Maintain documentation for data workflows, architecture, and integration processes.

- Participate in Agile ceremonies including sprint planning, daily stand-ups, and retrospectives.

- Develop and consume RESTful APIs using Flask or Fast API for data integration.

- Apply database modelling techniques (ER diagrams, normalization, star/snowflake schema).

- Implement ACID properties and best practices for transactional consistency.

- Perform statistical analysis and data validation for business insights.

Technical Skills :

Programming :

- Python (decorators, generators, datetime handling).

Data Analysis :

- Pandas, NumPy, statistical concepts.

Database :

- SQL (joins, window functions, normalization), NoSQL basics.

API Development :

- RESTful APIs using Flask or Fast API.

Tools :

- Pandas Timestamp, datetime operations, data visualization libraries.

Concepts :

- ACID properties, normalization, database modelling, Digital Twin fundamentals.

Preferred Qualifications :

- Strong Experience in Python & SQL

- Familiarity with data engineering workflows and ETL processes.

- Knowledge of API protocols (REST, SOAP, GraphQL).