I know this is a Cognos forum but some folks who do Cognos might have had SSIS background so posting this here:
We need expert level SSIS developers.
Duration - Permanent
Location - Mumbai, Bangalore and New Delhi, India
Required Skills:
5 or more years of ETL Development experience specifically using SSIS
Strong knowledge of SQL coding, scripting and transformation of data from Snowflake to Star Schema (Kimball structure)
Ability to create efficient SSIS packages, Data Flow Tasks, Execute Tasks, Error Handling, Automation etc
Automation of SSIS jobs
Create post ETLload validation scripts
Advanced database development knowledge (SQL Server 2012 or up and Oracle 11g)
Ability to ensure performance , reliability and consistency of SSIS jobs
Strong understanding of auditing, error handling etc.
Ability to create and maintain the complete ETL cycle
Merge and analyze ambiguous data from disparate data sources
Ability to work both independently and in a team environment.
Analytical thinking
Understanding of ETL best practices
Nice To Have:
Knowledge of Sales, Inventory and Purchasing data sets
Some familiarity with an ERP system (e.g. Oracle, SAP, Peoplesoft )
Knowledge of SCD and MDM
Contact - careers@pervisol.com
Thanks!