Data Engineer

• Design, develop, and maintain scalable data pipelines and ETL processes to collect, process, and store large datasets from various sources.
• Optimize and tune SQL queries, stored procedures, and database schemas to ensure high performance and efficiency.
• Develop and deploy SSIS packages for data integration, transformation, and loading tasks.
• Collaborate with data analysts, data scientists, and other stakeholders to understand data requirements and deliver high-quality data solutions.
• Implement data quality checks, monitoring, and alerting mechanisms to ensure data accuracy and reliability.

Qualifications

REQUIREMENTS

• Expertise in writing T-SQL queries, dynamic queries, sub-queries, and complex joins for generating stored procedures, triggers, user-defined functions, views, and cursors.
• Deep knowledge of stored procedures optimization, performance tuning, and index tuning.
• Proficiency in Python programming language, including understanding syntax, data structures, and automating tasks.
• Experience in enhancing, debugging, and deploying SSIS packages from development to production server using SSIS catalog.
• Strong problem-solving and analytical abilities, with a background in software development methodologies such as Agile, Scrum, and Waterfall