Previous Job
ETL Engineer (CMS)
Ref No.: 18-01687
Location: Woodlawn, Maryland
Position Type:Full Time/Contract
Start Date: 02/26/2018
·         Must have 5-7 years of experience in the ETL Engineer role
·         5 years of  proficient experience with Hadoop data ingestion, data processing and data modeling process
·         Experience working on Big Data projects or Health Insurance Market Place projects
·         Prior Health IT experience with CMS or HHS
·         Functional knowledge of CMS IT XLC (Expedited Life Cycle), MIDAS (Multidimensional Information Data Analytics System), ACA (Affordable Care Act), Health Insurance Portability and Accountability Act (HIPPA)
·         Must have experience in NiFi, Spark, AWS Glue, IBM InfoSphere DataStage, Informatica, and/or MS SQL Server Integration Services
·         Experience in Data Warehousing environment, experience in handling large volume of data
·         Experience analyzing, making recommendation, and resolving ETL, view, or query performance problems
·         Experience designing, developing, and testing ETL using SQL programming
·         Experience defining and developing source-to-target data mapping specifications
·         Experience developing ETL code from internal and external sources and have experience with various ETL tools
·         Experience working in DevOps and Agile environments
·         Experience in ETL development for relational databases with an advanced SQL programming background
·         Experience with datasets large enough to require extended storage
Preferred Skills/Experience:
·         Experience performing data analysis and data quality checks and recommends data remediation plan
·         Experience in writing Unix shell scripts
·         Experience reviewing, updating, and maintaining existing IT documentation
·         Experience creating, debugging, and extending ETL workflow