jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom professional summary sr etl informatica developer 10 years successful professional experience data warehousing development different domains excellent knowledge data warehousing concepts expertise experience following areas analysis etl design etl testing etl performance tuning db sql extensive experience developing strategies extraction transformation loading mechanism using informatica power center windows environment skills informatica powercenter informatica power exchange oracle work history 062019 current etl informatica developer mysql ec2 s3 cognizant technology solutions los angeles ca title lms saas data migration role etl developer client google inc roles responsibilities participate business functional requirements gathering involves review existing systems configurations operating methodologies well understanding evolving business needs data modelling design build data warehouse components multitier architecture comprises stage operational data store analytical data mart application design develop end end application data warehousing projects applying data transformations logics using industrys standard coding practices informatica power center technical support acceptance testing responsible quality checks projects technical document preparation worked plsql programs like stored procedures functions packages etc worked production team resolve data issues production database cloud lms systems coordinate various infrastructure downstream upstream teams resolving issues major incidents certify operations running successfully business impact coordinate client resolving queriesissues faced keeping client project manager updated project status periodic basis provide value additions application continuous improvement initiatives perfective preventive adaptive activities mapped data source systems warehouses managed team 4 employees overseeing hiring training professional growth employees 042017 062019 etl informatica developer cognizant technology solutions richmond va title lms saas implementation role etl developer lms data migration specialist client toyota north america motors roles responsibilities design develop test etl mappings mapplets workflows worklets using informatica powercenter 9x work fast paced environment minimal supervision providing technical guidance team members responsible database schema design extensive tsql development integration testing projects may necessary help team achieve goals working closely onshore offshore application development leads etl mappings mapplets workflows worklets using informatica powercenter 9x identify efficiencies ways improve design development processes identify ways increase efficiency production support find solutions allow operations better job without involving development resource time developed mappingsreusable objectstransformationmapplets using mapping designer transformation developer mapplet designer informatica power center wrote oracle packages functions implement business rules transformations staging done worked pre post sessions extracted data transaction system staging area used informatica power center 9x extraction loading transformation etl data data warehouse implemented populate slowly changing dimension maintain current information history information warehouse tables used ssis packages load date spreadsheet database also used packages move data databases oracle flatfiles different servers created ssis packages extract data oltp olap systems scheduled jobs call packages stored procedures worked different data sources oracle sql flat files etc 052011 042017 etl developer education 2010 salient crgt huntsville al title lms saas implementation role etl developer lms data migration client zimmer biogen roles responsibilities designed integration tools combine data multiple varied data sources rdbms sql big data installations managed data quality issues etl processes directing qualitative failures team lead amelioration analyzing business requirements business analyst develop etl procedures consistent across systems involving data modeling sql server databases store data retrieved flat files normalizing denormalizing flat files loading sql server creating mappingssessions workflows using informatica version 95 installing configuring upgrading informatica powercenter tdmilm 101 ebfs installing reconfiguring upgrading informatica powercenter suite using different types tasks like decision timer event initialbulk load process wait command maintain dependencies sessions load balancing within informatica workflow working various transformations like router expression sql lookup normalizer aggregator building complex mapping involving designing procedures getting data source systems data warehousing system bachelor engineering technology electrical electronics engineering veltech engineering college india