jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary 12 years experience strong background sdlc data integration tools including informatica powercenter informatica intelligent cloud servicesiics informatica powerexchange idq business intelligence tools like power bi expertise data warehousedata mart ods oltp olap implementations teamed project scope analysis requirements gathering data modeling effort estimation etl design development system testing implementation production support experience working informatica iics tool effectively using data integration data migration multiple source systems experience working iics concepts relating data integration monitor administrator deployments permissions schedules expertise informatica power center 102101951901867 1 extracting data oracle sql server teradata db2 databases flat files web services apis xml json files worked various transformations like normalizer expression rank filter group aggregator lookups joiner sequence generator sorter sqlt stored procedure update strategy source qualifier transaction control union etc expertise implementing complex business rules creating complex mappingsmapplets shortcuts reusable transformations partitioning sessions experience performance tuning sources targets mappings transformations sessions experience installation configuration informatica power center 10x9x client server unix experience performance tuning debugging existing etl processes experience integration various data sources like oracle teradata sql server db2 flat files various formats like fixed width csv excel designed complex mappings load snowflake expertise sqlplsql programming developing executing packages stored procedures functions triggers table partitioning materialized views skills informatica intelligent cloud services informatica powercenter 102101969108608518171 informatica powerexchange 101969108608518171 ticbo designer 5 oracle 12c11g10g9i8x sql server 200820052000 ms access teradata40 mysql tableau 102 power bi toad 1212 sqlplus sql developer sqlloader sql plsql git hub experience sr informatica developeriics developer 102020 032021 cognizant technology solutions south san francisco ca shell scripting c c xml msdos windows95982000xpvistawindows 10 unix plsql agile methodology activemq raml json google bigquery salesforce automic dimensional data modeling star schema modeling snowflake modeling pra health sciences inc provides comprehensive clinical development services including data management statistical analysis clinical trial management medical writing regulatory drug development consulting responsibilities designed built iics mappings extract data sfdc oracle sql server loaded oracledesigned etl flows generating flat file extracts per business need worked converting informatica powercenter etl code iics using pc cloud conversion service involved enhancements maintenance activities data warehouse implemented typel type2 incremental load strategies iics handled configuration activities like setup run time environment create connections schedules tasksmappingsmapplets components designed mappings integration templates bundles task flows used various transformations extract data different formatted files relational source system developed tested informatica mappings based specification design develop plsql packages stored procedure tables views indexes functions implement best practices maintain optimal performance developedautomated powercenteriics jobs automic environment iics informatica power center 104102 salesforce oracle sql server github sr informatica developer 042011 102020 benefitmall inc phoenix az tennessee valley authority corporate agency united states provides electricity business customers local power companies serving 10 million people parts seven southeastern states sr software engineer involved implementation enterprise asset management p6 data warehousing cdc efms maximo 75 version upgrade tririga enterprise content management portfolio optimization project power supply enterprise material tracking system supported various software database upgrades responsibilities involved requirement gathering analysis design development project worked design development informatica powercenter mappings workflows load data multiple sources staging area data warehouse data marts sql server oracle real time extensively used informatica power centeriics create mappings sessions workflows populating data dimension fact lookup tables simultaneously different source systems sql server oracle flat files used change data capture cdc capture changes multiple environments deliver accurate data business data warehouse applications worked migrating informatica powercenter code iics experience integrating data using iics reporting needs provided leadership direction project team understanding business processes gathering requirements identifying potential usability issues managing scope ensuring appropriate level application quality maintained times providing architecture review proposed projects enhancements aid governance process decision making worked repository db find deviations companys etl standards objects created users sources targets transformations log files mappings sessions workflows integrated data quality routines informatica mappings standardize cleanse data involved performance tuning source target mappings sessions system levels designed developed unix scripts scheduling jobs using pmcmd involved providing technical support team members well business performance tuning using round robin hash auto key key range partitioning successfully implemented slowly changing dimensions successfully integrated multiple xml sources created denormalized flatstructured file involved writing sql stored procedures functions triggers views oracle database ensure support requests properly approved documented communicated using team foundation servertfs worked project managers developers quality assurance customers resolve technical issues estimated work hours tracked progress using agile methodology reviewed etl code worked development teams correct problems run test scenarios prepare deployment met stakeholders contractor product teams customers throughout system development life cycle delivered signoff deliverables pertaining transactional data warehouse tested troubleshooting methods devised innovative solutions documented resolutions inclusion knowledge base support team use environment informatica power center 1021019691861iics informatica power exchange 1029691861 informatica data quality 861 google bigquery admin console oracle 12c11g10g sql server 2005plsql unix windowsnt40 tableau power bigit team foundation server tfs etl developer 122010 042011 wells fargo bank city state wells fargo bank one largest commercial banks united states provides customers full range financial products services etl developer wells fargo bank mortgage project design develop implement etl process load products data mart helped generate business intelligence performance management reports responsibilities extensively involved gathering business requirements translating technical requirements used informatica powercenter ab initio extract data mainframe responsible strictly maintaining naming standards warehouse standards future development coordination leading offshore development activities extracted data various sources flat files mainframe sap oracle using informatica power exchange designed developed stored procedures db2 achieved performance improvement tuning sql queries extraction procedures oracledb2 power center offered 247 production support application timetime basis developed complex power center mappings using different transformations components respectively meet data integration data quality requirements created monitored workflowssessions using informatica server managerworkflow monitor load data target oracle database performed unit testing integration testing user acceptance testing proactively identify data discrepancies inaccuracies involved performance tuning source target mapping session level prepared design documents etl specifications migration documents maintained daily tech tracker updates team regarding objects issues progress involved informatica power center 811 repository upgrade informatica power center 861 involved providing informatica technical support team members well business environment ab initioinformatica power center 811861 teradata oracle education training master science software engineering 7 2010 stratford university falls church va bachelor technology electronics communication engineering 2 2008 jntu hyderabad ap certifications informatica power center 8 certified developer