Minimum 6 years of experience in ETL development using SAS Data Integration Studio 4. 9 ETL toolset.
o Experience in building and maintaining SAS Data Integration Studio jobs & managing job flows. 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
o Hands on experience in Base SAS, Advance SAS programming, SAS Macros, SQL and optimization techniques. Knowledge of SAS architecture.
o Basic Unix commands, analytical approach for resolving issues
o Formulate solutions/recommendations, based on the requirements & technical standards. Follow design standards for ETL processes. Analyze, assess, and implement changes to existing solutions in response to business changes.
o Should have exposure DB2 database
o Good interpersonal, written, and verbal communication skills. Clear & Concise Communication.
o Collaborate with developers, subject matter experts and business users in gathering and documenting requirements for data extraction and transformation

Keyskills: Unix Base SAS SAS Macros Db2 Analytical SAS Programming SAS DI studio SQL Data extraction