Apply Now

Resource should be 6+ Years of experienced.

Strong experience with Microsoft SQL Server (2016/2019/2022).

Expertise in SSIS (SQL Server Integration Services).

Strong SQL programming skills.

Experience in Stored Procedures, Functions, Views, CTEs, Dynamic SQL, Performance Tuning

Experience with SQL Server Agent Jobs.

Understanding of Data Migration projects.

Hands-on experience with Control Flow, Data Flow Tasks, Script Tasks, Derived Columns, Lookup Transformations, Merge/Merge Join, CDC (Change Data Capture)

Experience with source control tools such as Git, Azure DevOps, or TFS.

Design, develop, deploy, and maintain SSIS packages for data extraction, transformation, and loading (ETL).

Develop complex SQL queries, stored procedures, views, functions, and triggers.

Integrate data from various sources including SQL Server, Oracle, flat files, APIs, and cloud platforms.

Perform data cleansing, validation, and transformation activities.

Monitor and troubleshoot ETL jobs and data integration processes.

Optimize SSIS package performance and SQL query execution.

Implement error handling, logging, auditing, and recovery mechanisms.

Work closely with business analysts, data architects, and QA teams to understand requirements.

Participate in code reviews and deployment activities.

Prepare technical documentation and maintain process flow documents.