Description

Lead the design and development of ETL pipelines using SSIS for data ingestion, processing, and analytical workflows.

Responsibilities

• Design and develop ETL pipelines using SSIS for data transformation across big data and relational databases.
• Collaborate with Azure stack modules, including Data Lakes and SQL DW, to build scalable data solutions.
• Write SQL, Python, and PySpark code for efficient data processing and transformation.
• Translate business requirements into technical designs, mapping documents, and transformation rules.
• Communicate project status to stakeholders to ensure smooth execution under high-pressure situations.

Required Skills

• 12-15 years of experience in SSIS ETL for data ingestion and processing.
• Hands-on experience with Azure services: ADLS, Azure Databricks, Data Factory, Synapse, and Azure SQL DB.
• Strong proficiency in SQL, Python, and PySpark for data transformation.
• Familiarity with DevOps and CI/CD deployment practices.
• Ability to translate complex business requirements into technical specifications.
• Strong communication skills and attention to detail.

Preferred Skills

• Experience in the insurance or financial industry.

Key Skills

Education

Any Gradute