professional summary jessica claire montgomery street san francisco ca 94105555 4321000 resumesampleexamplecom dynamic etl developerdata engineerdata analyst 9 years experience helping companies diverse transitioning including sensitive financial data massive big data installations good knowledge big data analytics promotes extensive simulation testing provide smooth etl execution known providing quick effective solutions automate optimize data management tasks talented bi professional bringing advanced understanding successful strategies identifying protecting capitalizing data assets able construct new systems answer complex business needs skills data warehousing concepts datastageinformaticateradata etl unix shell scripting experience summary sql plsql oraclesql serverdb2 teradata unitsystemuatpost production testing etl etl automation control mautosystivoli big data analysis pysparkpandasnumpy hadoop hdfs spark hive sqoop python kafka real time read 082016 092019 etl developer data engineer data analyst unitedhealth group city state galaxy primary data warehouse uhg also one comprehensive entire health care industry follows dimensional schema datatables divided among different subject areas primary objective application provide single consolidated environment processing claims health service data sourced internally externally make available central location accessible entity within unitedhealth group appropriate authority responsibilities extraction data different data sources using different etl tools involved design etl jobs apply transformation logic worked complex mappings datastage used fastload multiload utilities loading data staging target teradata tables respectively developed automated script part innovation pick suitable utility based volume data dynamically worked tpt load tpt stream utilities used teradata export utilities reporting purpose developed tws jobs schedule process based frequency sources created dependencies source system using hard dependency concept rather file watchers involved purging data based retention period developed automated process data purge archival recent integration hadoop data lake using hive structured data layer top hdfs successful implementing spark process back bone hive queries involved writing python functions refine unstructured poor data make understand etl layer secior software engineer etl developer unitedhealth group city state 072010 062013 ugap national consolidated data warehouse unitedhealth group contains data multiple claim processing systems unet cosmos mamsi galaxy data sources categorized flat files db2 database data extracted transformed applying business logics loaded ugap data mart teradata final warehouse describes complete details individual claim provider details member details pharmacy details responsibilities worked onsiteoffshore coordinator lead developer involved brd gathering translation brd functional specification developer understand design etl components involved data modeling simple data marts complex data warehouse involved migration legacy dw applications spark environment sme proposed best solution complex business logics technical translations designed teradata bteq multiload fastload tpt scripts according volume data design development etl components using ibm datastage involved capacity planning data profiling data quality check design involved performance tuning etlibm datastage versions components teradata components understand technical differences teradatatraditional etl technologies spark technologies demonstrations customers convinces migrate advanced open technologies like pyspark etl pipelines trained according technical differences scotware engineer etl developer hsbc software development private limited city state india 072007 062010 worked group economic capital project basel accords calculating risk capital required hsbc group global business market creating simple data mart global group decision making reports project responsibilities responsible requirement analysis creating low level design specifications etl jobs developing jobs extraction monthly financial data feeds applying required defaulting processing data required aggregations business rules validation data applying required business transformations validation extracted staging area data loading data mart riskfrontier application masking production data dealing third party vendors following firm guidelines privacy customers automation production run controlm scheduler etl jobs run shell scripting generating required qa jobs within etl workflows sending validated values business immediate confirmation within required sla unit testing post production testing responsibilities documenting test cases managing testing defect control hp quality center maintenance version control code environments lead project related scm activities education master computer applications activities honors andhra university best performance award best team award spot award appreciations csr activities