Position: ETL (SSIS) Developer
Required Skills:
- Minimum 5 years or more in a development role. Minimum of 3
years of development on Data / SQL Integration Projects.
- Experience of upgrading SQL based system to new versions (SQL
Code and Objects)
- Knowledge of data warehousing architecture, techniques, design
patterns and strategies
- Experience of working both independently and collaboratively
with various teams and global stakeholders (Business Analysts/ Architects/
Support/ Business) in an agile approach while working on projects or data
quality issues
- Ability to design and code at an enterprise commercial
standard:
o SQL server database objects (Stored Procedures, Triggers, Views
etc.)
o T-SQL Query Optimization with Indexes.
o SSIS integration tasks
- Experience in development of complex / enterprise data warehouse
implemented over standard RDBMS (preferably using SQL Server Integration
Services (SSIS) and SQL Server Objects) preferred
- Prior experience of analysis and resolution of data quality and
integration issues
- Experience in providing and maintaining technical documentation,
specifically Data Mapping and Low Level / ETL Design Documentation
- Experience of Database queries (SQL) and performance
tuning
- Experience of developing ETL Code / Integration using
Informatica