ETL Developer

Description

Required 35 years of ETL DevelopmentShell scripting experienceExperience with Hadoop, Big Data, someone whos taken CCDAs and HL7, X12 transactions in a big data environment is nice to have but not requiredPentaho experience requiredData analysis using HIVE, SQL, Hadoop, etc.Must have the 835 and 837 formats, using that data in an analytics environmentMust have experience with X12 EDI standards for Healthcare data (835, 837, etc.) and HIPAAEstablish, maintain and enforce ETL architecture design principles, techniques, standards and best practices.Drive the technical design of ETL reference architecture to ensure high data quality, data integration performance and error recovery/handling.Review and assess existing ETL applications, to support new features, performance improvements, upgrades, and ongoing sustainmentAble to communicate and summarize work stream status effectivelyAble to map user storiesdesign and designcode traceabilityConduct design reviews, code reviews, performance tuningResearch and recommend future improvements in the Informatica operational environmentsDeliver Best practice document (PreInstall Checklist, Architecture, Job Scheduling, Multitenancy setup, Fit for Use, Comparative Evaluation, Strength/ Weakness, Upgrade Strategy, Code Deployment Strategy) for each toolDevelop inhouse knowledge repository for best practices, solution documentations, manuals, and proceduresPrepare cheat sheet on tool's features for user education