Sr. ETL Developer

Role Overview We are seeking a detail-oriented ETL Developer with deep expertise in SQL and stored procedures to design, build, optimize, and maintain data integration pipelines. This role focuses on transforming and loading data from multiple source systems into data warehouses and reporting platforms while ensuring data accuracy, performance, and reliability.

Key Responsibilities

• Design, develop, and maintain ETL processes using SQL and database stored procedures
• Build efficient data transformations, aggregations, and validations for large datasets
• Optimize SQL queries, indexes, and stored procedures for performance and scalability
• Collaborate with data analysts, BI developers, and application teams to understand data requirements
• Implement error handling, logging, and monitoring for ETL workflows
• Perform data quality checks and troubleshoot data discrepancies
• Support scheduled batch loads and incremental data refresh processes
• Document ETL logic, data mappings, and technical designs
• Assist with production deployments and ongoing maintenance.

Required Skills & Qualifications

• Bachelor's degree in computer science, Information Systems, or a related field (or equivalent experience)
• 5+ Years of Expert Level Experience and Proficiency in SQL (complex joins, CTEs, window functions, performance tuning)
• 5+ Years of Extensive experience writing and maintaining stored procedures, functions, and triggers
• Hands-on experience with ETL concepts (extraction, transformation, loading)
• Experience working with relational databases (e.g., SQL Server, Oracle, MySQL)
• Solid understanding of data warehousing concepts (fact tables, dimensions, star schemas)

Preferred Qualifications

• Experience with ETL tools, Azure Data Factory, etc.
• Experience with Azure Cloud
• Familiarity with BI/reporting tools, Power BI
• Experience with incremental loads, CDC, and data reconciliation
• Exposure to cloud data platforms (Azure SQL, AWS RDS, Redshift, Snowflake)
• Basic scripting experience (PowerShell, Python, or Bash)
• Knowledge of data governance and security best practices.

Competencies

• Tech Savvy - Anticipating and adopting innovations in business-building digital and technology applications.
• Self-Development - Actively seeking new ways to grow and be challenged using both formal and informal development channels.
• Action Oriented - Taking on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm.
• Customer Focus - Building strong customer relationships and delivering customer-centric solutions.
• Optimize Work Processes - Knowing the most effective and efficient processes to get things done, with a focus on continuous improvement.

Why Join Us?

• Be part of a collaborative and agile team driving cutting-edge AI and data engineering solutions.
• Work on impactful projects that make a difference across industries.
• Opportunities for professional growth and continuous learning.
• Competitive salary and benefits package.

(ref:hirist.tech)