Minimum 8 years of experience in ETL development using SAS Data Integration Studio 4.9 ETL toolset.
Skilled in various DI transformations including Look-up, Loop, Transpose, Sort, Append, Rank, List Data, Extract, Table Loader, Merger, Split, SQL, SCD Type 1 & Type 2 Loader, Data Validation, Creating Custom Transformations, Change Data Capture, managing indexes and constraints, using In-Database processing, verifying data quality settings, Importing SAS Code, Deploying & Scheduling Jobs, chaining jobs, metadata promotion
Strong industry experience working in the data warehouse/BI arena including experience in data warehouse methodologies, including data management, data integration and analytics system architecture. Integrate and manage the data mappings from data sources to the Enterprise Data Warehouse using the SAS Data Management solution.
Hands on experience in Base SAS, Advance SAS programming, SAS Macros, SQL and optimization techniques. Knowledge of SAS architecture.
Experience in Onshore-Offshore model and client facing roles and managing customer communication
Collaborate with developers, subject matter experts and business users in gathering and documenting requirements for data extraction and transformation.
Act as an enabler for the effective functioning of a software development team using Agile Methodology and can act as a scrum master.
Should have experience or be aware of the Managed Service concept and willing to drive the team to adhere processes required for Managed Services project
Exceptional communication, organization, and time management skills -Ability to coach and mentor the team to reach their highest potential -Collaborative approach to decision-making -Strong analytical skills. Should be able to collaborate and work closely with local (Belgium) consultants.
Formulate solutions/recommendations, based on the requirements & technical standards.
Very Good Experience in Insurance Data model (preferably SAS DDS, but any other insurance data model is also OK)
Very Good Experience in Insurance Domain and Data Integration
Very Good Experience in Performance Tuning
Very Good Investigation skills and proactiveness on maintenance of the systems
Very Good Analytical skills
Nice to Have - Experience And/Or Knowledge ofInsurance/Banking Experience