jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary 7 years professional experience analysis design development testing implementation various data warehousing software applications brokerage telecom sectors extensively involved etl development using iics informatica power center 9x10x worked iics gcp environment using connectors postgresql oracle oracle big query using hierarchy builder iics convert structured data json store google cloud storage strong knowledge data architect modeling concepts including design conceptual logical physical data models entity relationship concept facts dimensions tables dimensional modeling star schema snow flake schema worked slowly changing dimensions scd type12 dimension mappings change data capture hands experience identifying resolving performance bottlenecks various levels like mappings sessions hands experience optimizing sql scripts improving performance loading data warehouse databases oracle postgresql strong writing sql joins nested queries unions multitable joins good experience performing supporting unit testing system integration testing sit uat production support issues raised application users iics powercenter 9x10x oracle postgresql big query google cloud storage sql plsql python unix shell scripting gcp google cloud platform erwin data modeler skills scrum agile methods sql developer dbeaver control autosys trello jira data analysis experience sr etl developer 102019 current two95 international inc pasadena ca project description think prosrent uber construction equipment portos dumpsters aerial equipment way earth moving equipment theres better way rent construction equipment one utilizes technology bring renters suppliers together business fairly project scope primarily responsible connect multiple source systems order life cycle billing management invoice gen supplier inventory management system notification management system datawarehouse effective design development validation support activities assure producing values business responsibilities worked business analysts data analytics team gather business requirements translated design considerations identified tracked slowly changing dimensions scd capture changes heterogeneous sources worked informatica change data capture extracted data order life cycle management system postgresql transformed data oracle database invoice generator application produce automated invoice iics converted mappings powercenter created new mappings order life cycle management system get data postgresql gcp cloud onpremises oracle datawarehouse extracted data oracle postgresql loaded oraclebig querygoogle cloud storage created various transformations like joiner aggregator expression lookup filter update strategy router etc monitored sessions scheduled running completed failed retrieve data various tables staging database wrote sql queries optimized sql scripts improve performance loading datawarehouse worked documentation describe program development logic coding testing changes corrections participated enhancements meeting distinguish bugs enhancements worked scrum master agile team development data warehouse data lake cloud technologies environment informatica powercenter 101 iics oracle 19c postgresql unix sql developer flat files etl developer 022017 102019 childrens place brandon fl project description brinkshome proven leader smart home security industries brinkshome committed providing powerful reliable smart home security fast alarm project scope responsible creating bundled customer inventory alarm notification single datawarehouse due multiple mergers bh many ordering inventory systems process alarms thus tasked connect multiple systems datawarehouse monitor alarms detect dispatch workload managing inventory responsibilities worked building datawarehouse logic sales marketing dispatch inventory management departments organization converted business requirements technical specifications etl process populating data datawarehouse developing well modifying existing mappings enhancements new business requirements mappings load staging tables target tables dwh transformed data multiple orderingalarm systems eosorder manager adt alarms loaded dwh combined customer inventory alarm information across merged companies responsible loading dataparsed alarms data pushed data target tables worked session logs workflow logs error handling troubleshooting actively used jira track status tasks participated code review integration team members participated review meetings engineering manager ensure development projects meet business system requirements environment informatica power center 961 oracle 11g python unix controlm etl developer 012016 022017 childrens place bronx ny project description frontier leading communications provider offering gigabit speeds empower connect millions consumers businesses 25 states building critical digital infrastructure across country 100 fiberoptic network cloudbased solutions project scope frontier acquisition verizons california texas florida properties 37m voice 22m broadband 12m fios video connections brought biggest conversion program team data mappers etl developers assigned convert data verizon systems frontier system responsible convert telecom provisioning data responsibilities worked data mappers collect business requirements base sqls translated informatica mappings responsible analysis verizon data integrate frontier dpi system performed source system data analysis per business requirement distributed data residing heterogeneous data sources consolidated onto target enterprise data warehouse database developed mappings sessions workflows sqls extract validate transform data according business rules created various transformations like joiner aggregator expression lookup filter update strategy router etc extensively worked design development implementation plant file loads iflcs ifld ifsmalt etc building necessary staging tables worktables oracle development environment sourced data xml files flat files oracle tables made substantial contributions simplifying development maintenance etl creating reusable mapplets transformation objects partitioned sessions reduce load time implemented performance tuning informatica sources targets mappings transformations sessions pushdown optimization partitioning implemented incremental load logic improve time taken entire mock conversions wrote sql queries as400 testing files designed executed mock conversion runs every week using integrated workflows pmcmd commands monitored sessions scheduled running completed failed environment informatica power center 961 as400 oracle 11g python shell scripting controlm education master computer applications computer science 052010 holy cross college trichy india english negotiated languages tamil negotiated