Job Title: DB Design Engineer
Experience:
5 to 8 Years
Notice
Period: Immediate to 15 days
Location: Bangalore
JD:
Key Responsibilities:
·
Design, develop, and maintain data engineering
pipelines and workflows in AWS using services such as S3, Glue, EMR, Athena,
etc.
·
Implement data transformations, cleansing, and
aggregation processes to prepare data for analysis and reporting.
·
Develop and optimize SQL queries, stored
procedures, and database structures in MongoDB and SQL Server for efficient
data storage and retrieval.
·
Collaborate with data scientists, analysts, and
business stakeholders to understand data requirements and design appropriate solutions.
·
Implement data governance and security measures
to ensure data integrity, privacy, and compliance with regulations.
·
Monitor and troubleshoot data pipelines,
database performance, and ETL processes to identify and resolve issues.
·
Develop and maintain documentation for data
engineering processes, data models, and database schemas.
·
Participate in data architecture discussions and
contribute to the overall data strategy and roadmap.
·
Stay updated with industry trends, best
practices, and emerging technologies in data engineering and database
development.
·
Provide technical guidance, mentorship, and
support to junior team members as needed.
Qualifications:
·
Bachelor's degree in Computer Science,
Information Technology, or related field.
·
3-4 years of relevant experience in data
engineering, with a strong focus on AWS services (S3, Glue, EMR, Athena, etc.).
·
Experience with databases such as MongoDB and
SQL Server, including data modeling, query optimization, and database
administration.
·
Knowledge of IDBI (Integrated Data Bus
Interface) is considered a plus.
·
Proficiency in SQL, Python, or other scripting
languages for data manipulation and automation.
·
Familiarity with data governance, data quality,
and data security principles.
·
Strong analytical and problem-solving skills
with attention to detail.
·
Excellent communication and collaboration skills
to work effectively in a team environment.
·
Ability to manage multiple priorities and
deliver high-quality results within deadlines.