CRG Solutions - Data Anayst - SQL/SSIS/ETL (4-7 Yrs) Any Location (Systems/Product Software)

JD : - Should be able to connect with multiple data sources like excel, csv, SQL server oracle etc - Should be able to use the transformations components to transform the data - Should possess knowledge on incremental load, full load etc.
-Should Design, build and deploy effective packages - Should be able to schedule these packages through task schedulers - Implement stored procedures and effectively query a database - Translate requirements from the business and analyst into technical code - Identify and test for bugs and bottlenecks in the ETL solution - Ensure the best possible performance and quality in the packages - Provide support and fix issues in the packages Qualifications : - 4 years of working experience in SSIS/ similar ETL tools - Writes advanced SQL including some query tuning - Experience in the identification of data quality - Some database design experience is helpful - Experience designing and building complete ETL/SSIS processes moving and transforming data for ODS, Staging, and Data Warehousing - Some Knowledge of C#/VB.NET a plus - Utilize ad-hoc techniques to perform on-the-fly analysis of data - Willingness to learn new tools and technologies as per project/ organizational need

Required Skills : English