Job Title: Integration Engineer (SSIS, Python, SQL, Data Warehousing)

We are looking for a skilled Integration Engineer with strong experience in SSIS, Python, SQL, and data warehousing within enterprise environments. This role combines technical expertise with the ability to collaborate directly with business stakeholders and analysts to deliver robust data integration solutions.

Key Responsibilities:

• Provide Level 2/3 support for existing ETL workflows.
• Monitor, troubleshoot, and optimize scheduled ETL jobs, identifying root causes and resolving performance issues.
• Design and develop efficient ETL processes using SSIS, Python, and SQL (SQL Server/Oracle).
• Write complex SQL queries and stored procedures; reverse engineer existing logic where required.
• Build and optimize data pipelines for seamless ingestion, transformation, and loading across structured, semi-structured, and unstructured data sources.
• Ensure data quality, integrity, and consistency across processes.
• Follow and enforce data management, security, and governance best practices.
• Conduct code reviews to validate performance, compliance with standards, and alignment with business requirements.

Required Qualifications:

• Minimum 5 years of hands-on experience in:
• SSIS development
• Python scripting for ETL or data processing
• SQL Server-based development, working with large datasets

Preferred Qualifications:

• Experience in the Financial Services industry
• Familiarity with enterprise scheduling/orchestration tools such as Tidal or Airflow
• Experience with cloud data platforms (e.g., Snowflake)
• Solid understanding of data warehousing concepts, including OLTP, dimensional modeling, and facts/dimensions
• Knowledge of cloud-based data architecture, messaging systems, and analytics
• Experience developing and deploying ETL pipelines using Databricks (PySpark)
• Bachelor's degree in Computer Science, Engineering, or a related field (Master's preferred)