Key Skills : SQL Server , SSIS , ETL Development.
- 7 to 10 years of experience in SSIS,SQL server in Development, Configurations, Deployment and maintenance of the ETL solutions
- Advanced knowledge of ETL, including the ability to read and write efficient, robust code, follow or implement best practices and coding standards, design/implement common ETL strategies (CDC, SCD, etc.), and create reusable/maintainable jobs
- Solid background in database development in SQL server PL/SQL , Complex SQLs ,triggers, functions etc
- Develop error handling processes. Create and implement scheduling strategy
- Should have good knowledge in solution deployment and release methods.
- Knowledge of relational and dimensional database structures, theories, principles, and practices.
- Knowledge on data model to develop Dimension and Fact mappings/jobs.
- Performs data validation, cleansing and analysis.
- Strong ability to research and find technical solutions via technical community collaboration in short term.
- Possess good knowledge of Agile and Waterfall methodologies.
Keyskills: design operations strategy research sql pl/sql agile ssis et