AWS Data Engineer (Standard)

As a SQL + Python Developer, you will play a critical role in developing, maintaining, and optimizing SQL-based data structures and implementing Python-based applications. Your primary responsibility will be to design and manage databases, create complex queries, and utilize Python to automate data processes, analyze data, and integrate with various systems. You will collaborate with other developers, data engineers, and business analysts to ensure seamless data flow and contribute to data infrastructure projects.

Key Responsibilities:-

Design, implement, and maintain SQL databases, tables, views, and indexes for efficient data retrieval and storage.
Write and optimize complex SQL queries, stored procedures, and triggers to support application features.
Develop Python scripts and applications to automate data extraction, processing, and analysis.
Integrate Python with SQL-based systems for data manipulation, reporting, and visualization.
Troubleshoot and resolve database performance issues, data inconsistencies, and Python-related bugs.
Collaborate with cross-functional teams to gather data requirements and implement data solutions.
Ensure data integrity, security, and consistency within SQL databases.
Monitor, maintain, and improve the performance of databases and Python applications.
Write clear documentation for SQL queries, Python scripts, and processes.
Continuously evaluate and implement best practices for data management, automation, and system optimization.

Required Skills Qualifications:-

Proven experience in SQL development, including database design, complex queries, and optimization.
Strong proficiency in Python, including experience with libraries such as Pandas, NumPy, SQLAlchemy, and others relevant to data manipulation and analysis.
Experience with relational databases (e.g., MySQL, PostgreSQL, MS SQL Server, etc.) and database management tools.
Familiarity with data integration techniques and experience with APIs, ETL tools like AWS Glue or data pipelines.
Strong analytical skills and ability to work with large datasets.
Ability to write efficient and clean code for automation, data cleaning, and reporting.
Familiarity with version control systems (e.g., Git).
Excellent communication skills, both written and verbal.
Strong attention to detail, problem-solving skills, and ability to work independently.

EXPERIENCE

• 4.5-6 Years

SKILLS

• Primary Skill: Data Engineering
• Sub Skill(s): Data Engineering
• Additional Skill(s): Python, GIT, ETL, SQL