← Back to jobs

Prophecy Technologies Logo
SQL Server SSIS Developer
Posted On: Just posted
Experience: 8+ years
Availability: Onsite
Openings: 1
Category: SQL SSIS developer
Tenure: No Preference/Any
Related Jobs

No related jobs found

Description

You will design, develop, and deploy SSIS packages for ETL workflows and data integration while optimizing T-SQL queries and automating system maintenance with PowerShell.

This role is on-site.

Responsibilities

  • Design, develop, and deploy SSIS packages for ETL workflows and data integration.
  • Write, optimize, and maintain complex T-SQL queries, stored procedures, functions, and views.
  • Develop and maintain PowerShell scripts to automate database tasks, file transfers, user provisioning, and system maintenance.
  • Integrate data processes with Active Directory for authentication, group membership checks, and access management.
  • Troubleshoot SSIS packages, SQL Server jobs, and automation scripts to ensure data integrity and security.

Required Skills

  • 5-7+ years of experience in SQL Server development and SSIS.
  • Proficiency in T-SQL, including query optimization and stored procedures.
  • Strong experience writing and maintaining PowerShell scripts.
  • Working knowledge of Active Directory, including user/group management and LDAP queries.
  • Experience with job scheduling, error handling, and ETL best practices.

Preferred Skills

  • Familiarity with SSRS or other ETL solutions.
  • Experience with access provisioning or Active Directory automation via PowerShell.
  • Understanding of DevOps tools (Azure DevOps, Git) and Agile methodologies.

Education

Any Graduate

Related Jobs

No related jobs found

← Back to jobs