Working with various transformations such as Lookup, Conditional Split, Derived column,
merge join etc.
❖ Working on Tasks such as Dataflow task, Execute SQL, Execute Package, File system and
Containers like for loop, for each loop in Integration services development.
❖ Hands on experience in creating, deploying, trouble shooting, scheduling, and monitoring
SSIS Packages.
❖ Good knowledge in SQL Server Fundamentals and T-SQL Objects.
❖ Good understanding on SQL concepts like DML, DDL operations, functions, stored
procedures, and joins.
❖ Extensive experience in writing and debugging stored procedures, views, Functions and
triggers.
❖ A good knowledge on indexes both clustered and non-clustered
❖ Connecting data sources, importing data and transforming data for Business intelligence.
❖ Strong desire in learning new technologies and methodologies. Strong Azure BI
Development Experience (Azure Blob Storage, Azure Data Lake, Azure SQL Server,
Azure Data factory)
❖ Very good experience on implementing data pipelines using azure data factory, working
with different source and sync, linked service, data sets and data flow.
❖ Have experience migrating SSIS packages from on premises to Azure Data fa
