Job Description :
Experience with moving and loading flat files into Microsoft SQL Server
Experience in working with healthcare claims files (837 & 835 formats)
Proficient in basic application development terminology and techniques, with experience developing n-tier applications.
Proficient in SQL and demonstrated knowledge of database design concepts.
Experience in ETL development language(s)/tool(s), concepts and methodologies.
Should be comfortable using command line scripts or VBS for file pre-processing
Knowledge of Data Warehousing concepts, such as EDW, ODS, DM, OLAP, Star Schema, etc.
Ability to analyze and interpret complex data across multiple source and target systems.
Ability to analyze complex code and identify issues and opportunities for enhancement.
Proficient in optimization of query performance and performance tuning of SSIS packages