Ssis Developer Sql Experience Job In Kanmalai Technologies Private Limited In Bengaluru / Bangalore, Chennai

Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems for processing by QRM Builds data transformations with SSIS including importing data from files, moving data from one database platform to another Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data Design, implement and maintain database objects (tables, views, indexes, ) and database security Experience working with SSIS packages Proficient with ETL tools such as Microsoft SSIS Analyze and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinations Test and prepare ETL processes for deployment to production and non-production environments Support system and acceptance testing including the development or refinement of test plans Roles: Knowledge of another BI reporting tool, like Cognos or Microstrategy, to be considered as an alternative option Oracle DB: Requested SQL server: Requested Unix: Requested SSIS package: Nice to have Agile process: Nice to have Stonebranch/Move IT: Nice to have Important Points to Prepare for Interview: Advanced SQL and Complex Queries(very important) Employee table select within a select union Group by Having Aggregation Min,Max,count,distinct etc Nested selects Select % of record using nested queries How to select only end record Department wise higher salary Joint queries

We Are Looking For Ssis Developer With Strong Sql Experience Along With Complex Queries Experience

Kanmalai Technologies Private Limited is looking for Any Graduate / Post Graduate profile candidates.