jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary highly motivated sales associate extensive customer service sales experience outgoing sales professional track record driving increased sales improving buying experience elevating company profile target market skills technologies informatica 96 102 abinitio databases netezza teradata oracle sql server operating systems unix unix scripting scheduling tools controlm methodologies agile scrum programming python spark profile summary 105 years experience development data warehousing solutions using informatica 10296861 datastage 85 ab initio 3 years experience architect lead development data warehousing projects good experience understanding business application business dataflow data relation etl informatica strong experience informatica power centre 91 861 811installation configuration olap oltp concepts expertlevel designing developing complex mappings extract data multiple sources flat files xml files rdbms tables informatica designer tools warehouse designer mapping designer mapplet designer transformations workflow manager monitor quality assurance good experience reconciliation process develop complex database sql plsql validate etl report testing worked etl migration project abinitio informatica mappings integration projects like avaya systems cms systems depth knowledge azure cloud service like compute network storage identity access management participated code reviewsdesign meetings optimizing performance mappings used spark sparksql read parquet data create tables hive using scala api worked azure environment development deployment custom hadoop applications developed dashboards using python inbuild functions reporting purposes developed several algorithms generating several data patterns using python good experience writing spark applications using python scala good understanding oracledb2 architecture developed utilities good knowledge informatica power exchange idq ide data profiling informatica data quality good work experience stored procedures unix scripting good knowledge informatica architecture end end designdevelopment project code migration test uat preprod prod environments production call support extensive experience requirement analysis database design development testing good knowledge informatica power exchange cdc connect mainframe systems provide access data various formats vsam ims idms as400 files extensively used etl methodology supporting data extraction transformation loading processing corporatewideetl solution using informatica data analysis experience data design analysis user requirements analysis data transformations data cleansing web service integration data extraction erp sap database relationships source systems analysis reporting analysis experience performance tuning mappings sessions batches fixed bottlenecks tuned complex informatica mappings better performance used agile methodologies involved scrum meetings daily stand ups huddles experience 012016 current etl solution architect project honeywell saginaw mi objective initiative build business intelligence analytical reporting capabilities facilitate needs snaptanf reports design development testing data warehousing solutions using etl tools informatica 104 data design analysis data transformations data cleansing web service integration database relationships source systems analysis reporting analysis code migrationdeployment test production environments developed hive queries analysts design data modelling relation bw entitiesrelationships involved scrum meetings good knowledge agile methodologies performance tuning mappings sessions batches fixed bottlenecks tuned complex informatica mappings better performance designed developed several unix scripts execute informatica jobs worked informatica scheduling modified scripts test new controlm job cycles created presql post sql scripts need run informatica level implemented various loads like daily loads weekly loads quarterly loads using incremental loading strategy good knowledge rtc remedy optimized sql queries better performance worked loading facts dimensions maintain history records point time environment informatica powercenter 104102 teradata oracle unix controlm 102015 122015 etl lead developer american homes 4 rent denver co project pricing modernization gathered customer requirements involved business meetings analysts architects business users designed data warehousing solutions end end project worked agile development environment good knowledge agile methodologies involved iteration planning meetings epic stories tasks retrospective meetings documentation etl design process code deployment qa production environments good knowledge optimization sessions mappings developed batch processing source target reconciliation process tuning informatica mappings sessions optimum performance performance tuned mappingssessions developed complex database sql plsql validate etl report testing worked incident management tools environment informatica powercenter 10296 teradata oracle unix toad controlm 062014 092015 sr etl developer united services automobile association city state finpal financial profits losses auto mobile property insurance lines business member usaa helped analyse internal profits losses organization involved business discussions implementing business dataflow data relation prepared highlevel design documents created stm source target mapping conceptual data models srs software requirement specification documents worked different transformations slowly changing dimensions worked connected unconnected lookups performed integrated testing various mappings tested data data integrity among various sources targets designed developed mappings varied transformation logic like unconnected connected lookups router filter expression aggregator joiner update strategy monitored transformation processes using informatica workflow monitor designed data modelling environment informatica powercenter 91 netezza sql server unix controlm project par performance analytics reporting extraction transformation loading etl data using informatica powercenter developed mappings call quality sales metrics data created many plsql batches executed unix shell scripts worked designer tools like source analyzer warehouse designer transformation developer mapplet designer mapping designer extensively worked joiner functions like normal join full outer joins master outer joins detail outer join joiner transformation worked session logs work flow logs error handling troubleshooting dev environment created mappings using transformations source qualifier aggregator expression router filter sequence generator update strategy environment informatica powercenter 91 oracle db2 unix controlm 122010 052014 etl developer jpmc city state project rc3 report contact centre integrated avaya source system upgraded cisco source system help integrated source system generate reports business manager every 30 mins interval implemented scdtype2 keep track history integrated avaya cms cisco data developed informatica mappings extract data stage ods designed developed mapping transformation logic processes informatica implementing business rules standardization source data multiple systems data warehouse developed new informatica mappings workflows based specifications designed developed various informatica mappings using transformations like expression aggregator external procedure stored procedure lookup filter joiner rank router update strategy developed various adhoc mappings various business needs performed extraction transformation loading data rdbms tables flat files teradata accordance requirements specifications developed tested backend programs error handling strategies update processes created sessions workflows environment informatica powercenter 91 oracle sql server unix controlm project wave 3 semantic migrated abinitio code informatica developed code informatica using pdo integration layer semantic layer form physicalized mappings views using abinitio logics code development abinitio logics analysed business requirements worked closely various application teams business teams understand business requirements source data involved designing logical models staging production warehouses using erwin designed developed several etl scripts using informatica unix shell scripts extensively used features informatica including designer workflow manager repository manager workflow monitor worked mappings using expressions aggregators filters lookup update strategy stored procedures transformations partitioned sources improve session performance created users informatica assigned various permissions backuprestoration repositories worked defect fix code deployment qa created jobs controlm involved analysis phase data modelling environment informatica powercenter 91 abinitio teradata unix controlm project 3 digital marketing sor factory model met analysts architects business users prepared design documents per business logic extensively worked extract transform load data different source systems like oracle teradata flat files using informatica powercenter tool worked slowly changing dimensions scd type ii using lookup filter update expression transformations involved unit testing regression system testing worked performance tuning increasing cache override sql involved peer review developed mappings team members coordinated testing team make understand business transformation rules used throughout etl process created shell scripts automate production job runs environment informatica powercenter 91 oracle 11g plsql teradata unix education training b tech electronics communication engineering