Share this Job

Senior Specialist - Data Engineering

Apply now »

Date: Jun 24, 2022

Location: Tampa, FL, US

Company: Larsen & Toubro Infotech Ltd

Job Description :

  • SSIS developer with SQL Server 2008R2/2012.
  • Expertise in writing the Joins, Views & Indexes Stored Procedures, Functions ,CTE and Temp Tables creation.
  • Having hands on experience on Data Transformations like Lookup, Derived Column, Conditional Split, Sort, Data Conversion, Union All, Merge Join and OLEDB Command to load data into SQL Server destination.
  • Experience in SSIS packages execution, Applying security and deploying packages to servers.
  • Experience in creating configurations files, log files, error handling, Check points etc. for SSIS Packages.
  • Worked with SSRS to generate reports in different formats like Table, Matrix, Chart, Sub reports, Drilldown, Drill through and Image reports.
  • Knowledge on creation of ad-hoc reports and Linked reports etc.
  • Knowledge on Configuring Reporting server and maintaining Reporting services components.
  • Extensive experience in Creating Jobs for SQL Scripts, SSIS Packages, and Report manger level to scheduling the SSIS Package migration
  • Should have professional experience in IT industry, involved in MSBI projects with extensive usage of ETL(SSIS)
  • Experience in SQL like creating (Tables, views, indexes, sub queries, joins, constraints, union operators, aggregate)
  • Familiar with complete Data warehousing development life cycle.
  • Extensive database programming Experience in writing T-SQL Stored procedures, User Defined Data Types, Constraints and Indexes using various DDL and DML commands.
  • Good knowledge of Relational Database Management Systems and Database applications
  • Experience on SQL and T-SQL Statements (SQL joins, Sub queries, Views and Indexes).
  • Extensive database programming Experience in writing T-SQL Stored procedures
  • Good knowledge of Relational Database Management Systems and Database applications
  • Scheduling (SSIS ) Jobs/Workflow/Workflow Management.

 


Nearest Major Market: Tampa

Job Segment: Database, SQL, Data Warehouse, Engineer, Technology, Engineering