jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom professional summary 8 years etl data integration experience using datastage informatica power center 10x9x8x7x6x aws glue talend ssis matillion snaplogic sap business objects crystal reports powerbi tableau certified aws solutions architect associate 2 years implementation experience aws services tools expertise implementing maintaining system applications aws cloud windows linux experienced phases data warehouse life cycle involving requirement analysis design coding testing deployment extensive experience creating high level design documents logical design documents process flow diagrams data flow diagrams extensive experience developing etl mappings data integration data profiling master data management using etl tools expertise business model development dimensions hierarchies measures partitioning aggregation rules time series cache management expertise handling various aspects business intelligence viz data warehouse design development administration architecture etl administration development production support informatica powercenter data quality b2b master data management talend data integration data qualitymdm abinitio oracle plsql teradata plsql netezza plsql datastage bicrystal reportscontrolmmobaxtermsql developer unix shell scripting strong knowledge entityrelationship concept facts dimensions tables slowly changing dimensions dimensional modeling star schema snowflake schema experience integration various data sources like oracle db2 sybase sql server ms access nonrelational sources like flat files staging area experience development creation tickets support different vendor applications like charles river investment application eagle investment pam fiserv apl nfs bloomberg state street northern trust golden source factset experience writing testing implementation plsql triggers stored procedures functions packages experience performance tuning power center mappings sql scripts maximum efficiency performance expertise idqide tools data profiling data enrichment standardization experienced unix work environment file transfers job scheduling error handling experience support knowledge transfer production team proficient interaction business users conducting meetings clients requirements analysis phase multitasking manager wellknown creating positive workplace culture high performing teams demonstrated product service expertise including competitive offerings pricing market positioning skills computer skills work history 082018 102020 data integration lead caci international inc scottsdale az led scope estimation resources required release plan designing work approved backlog work items collaborated data modelers platform engineers data architects ddls views design based approved requirements discussions stakeholders worked platform engineers data architects aws cloud migration warehouses etl servers oversaw updates devops nightly batch reports actively troubleshooted issues reported appropriate channels independently worked creating updating data models passed data modelers approval worked intensively data governance business ensure ask implemented withing companys standards data governances approval worked dev team scrum master ensure sprint goals retrospective sprint planning effectively managed completed analyzed legacy applications gen1 data warehouse optimization reports etl framework analyzed reports manually compiled automated several reporting processes analyzed edw data layers best approach optimization dailyweeklymonth end reporting successfully assessed development effort required teams deploy get work required completed within sprint release plans worked data integration engineers creation integration ids required data governance s2t work data analysts worked closely release managers ensure promotions change requests reviewed approved scheduled ensured monitored deployments promotions higher environments successfully worked closely operations deployments based tfs builds get updates change request form tasks completed effectively managed validated approved changes tasks promoted operations regarding etl work sas eg net views ddls bo crystal reports collaborated data integration leads data leads terms work done promoted team ensure codes written stoppage projects work flight trained mentored assigned quarterly goals etl team sas eg team data analysts testers ensure development work done within sprint release plans ensure individual responsibility teams responsibilities owned several pieces logical design documents process flow diagrams data flow diagrams etl framework ksh bo reports remained point contact issues hours broke work terms scalability could completed delivered terms performance optimization worked closely automatic file transfer aft team working files extracts required go outside vendors ensure proper structure framework exists ready code work tested deployed higher environments successfully upgraded added several fields part medical claims pharmacy claims extract going outside vendors federal employee program fep change vendor required brining data gen1 sybase dw edw teradata big deal get test files complete data sent certain dates successfully oversaw development several rounds testing data integration work ensured 40000 fep members dependents never lost coverage throughout successfully integrated oversaw development testing work effort required upgrades fep subscriber spouse dependents work address primary address codes related coverage part wellmarks policies data governance standards worked cloud migration project architects ensure data replication planned tested executed monitored validated data integrity quality edw gen1 database systems ensured elastic load balancing scaling scaling timed options part sop cloud migration worked cloud migration project etl servers ensure environments migrated succession complete validations monitored testing devops engineers created 3 buckets windows rdp connections business analytics teams access data reporting 072017 042018 software developer integrator apex systems conshohocken pa created system requirements performed design analysis coding unit testing complex highly complex system functionality andor defect correction across multiple platforms identified ideas improve system performance impact availability provided functional andor technical guidance evaluating applications systems evaluating requests proposals coordinated changes influences prioritizes tasks business technical departments identified created solutions improve existing processes rapid delivery support facilitated root cause analysis data issues supported front end including vendors minimize impact future occurrences created system documentationplay books served lead technical reviewer contributor requirements design code reviews acted resource business serving analyzing developing proper solution presenting business developed accurate estimates work packages ensures accuracy estimates developed less experienced internal thirdparty team members acted technical resource throughout agile development life cycle contributed technical soft skills development team members assisted team leads management delegation technical work packages crossfunctional third party team members execution full development life cycle developed reviewed detail design document technical specification docs end end etl process flow source systems using datastage worked medics oncall coordinates system application transition development teams maintenance production teams andor constructs implements necessary controls assure system application traceability twentyfour hour running service worked development creation tickets support different vendor applications like charles river investment application eagle investment pam fiserv apl nfs bloomberg state street northern trust golden source factset created supported debugged issues controlm automation tool 072016 062017 sr etl developer honeywell tonawanda ny involved phases sdlc requirement design development testing production support production environment handled 2 terabytes data warehouse database created high level design documents process flow diagrams data flow diagrams involved endtoend development oltp systems creation data marts involved performance tuning different tables containing 1 tb data creating partitions using stored procedures cleanse scrub data uniform data type format applying mdm informatica idq tools load stage hub tables edw finally dimension rollupaggregate data business grains fact tables primary activities include data analysis identifying implementing data quality rules idq finally linking rules including address doctor power center etl processes delivery mdm data hub data consumers created queries query groups packages mdm hub console used informatica power exchange loadingretrieving data mainframe systems tuned mappings transformations tracking reader writer transformation threads session logs used tracing level verbose development small data sets used pmcmd start abort sessions tasks also used infacmd track status applications also automate service notification emails created oracle stored procedure implement complex business logic better performance created materialized view summary data improve query performance responsible loading data warehouse different sources using oracle loader load millions records used importexport utility load small tables supported oracle 10g databases running mission critical 24 7 systems used pmcmd extensively start stop schedule monitor informatica workflows 012015 062016 etl informatica developer cognizant technology solutions albany ny worked data architects business analysts understand data flow existing logic creation business requirement documents business logic involved creation feeds created logical physical design dimensional data warehouse using caerwin questtoad oracle rdms based ralph kimball methodology created technical specification development informatica extraction transformation loading etl mappings order load data classified tables data marts defined etl standards performed data model updates enhancements existing oracle designer data models required informatica power exchange mainframe used readwrite vsam files fromto mainframe optimized mappings sessionstasks source target databases part performance tuning extensively involved recovery process capturing incremental changes source systems updating staging area data warehouse respectively engaged designing developing test cases error control routines data validation load processes audit log controls using plsql sql created drill drill reports using sap business object sap bobj customized adhoc queries worked production support finalizing scheduling workflows database scripts using tidal scheduler education 052022 bachelor science information management systems university maryland global campus maryland certifications itilv4 aws certified solutions architect associate