jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary 12 years experience information technology predominantly area insurance pharmaceutical entertainment banking domain expertise etl technologies informatica suite informatica power center pc power exchange px database programming sql loader database tuning building complex queries strong technical experience data model design development implementation customization maintenance production support etl migration integration data warehousing projects using informaticapowercenter tool 2 years experience cloud platform aws certified aws solution architect associate level 3 years development experience big data hadoop clusterhdfs mapreduce frameworks hive pig python 2 years experience working using spark technology familiar data architecture including data ingestion pipeline design hadoop information architecture data modeling advanced data processing experience optimizing etl workflows handson experience amazon ec2 amazon s3 amazon rds vpc iam amazon elastic load balancing auto scaling cloud front cloudwatch sns ses sqs services aws family 6 years experience data warehouse architecture design implementing data warehouses various domains sizes responsible designing logical physical data model implementing etl flows performs initial incremental batch loads performing preproduction test production monitoring etc exposure erwin database modeling 3 years experience teradata development load utilities tool sql assistant experienced sdlc agile methodologies scrum selecting appropriate aws services design deploy application based given requirements implementing cost control strategies setupmanaging cdn amazon cloud front improve site performance solid programming knowledge sparkpython good working experience hadoop tools related data warehousing like hive pig also involved extracting data tools cluster using sqoop experience handling cluster safe mode good knowledge highavailability fault tolerance scalability database concepts system software architecture security infrastructure 9 years etl experience informaticapowercenter 91 86 811101 developing administering etl mappings designer source analyzer target designer transformation developer mapping designer mapplet designer repository manager workflow manager workflow monitor admin console lead onshore offshore service delivery functions ensure endtoend ownership incidents service requests experience using oracle development tools tool oracle application development toad sql developer sql plus plsql developer projects worked open source projects tracked using jira excellent written verbal communication skills including experience business meetings sow proposals project presentations design solution walkthroughs publishing regular status reports conducting status meetings handlingresolving situations like customer facing issues etc excellent documentation skills released technical design documents design specs mapping document er model ddl scripts documents etc precise quality performed various testing activities like unit testing integrationsystem testing regression testing user acceptance testing ensured code ideal skills informatica power center 10x9x8x informatica cloud python sql unix shell scripts teradata hive work history 102016 current data engineer pyspark plsql nosql oracle 1211g10g9181 red shift unix deloitte rosslyn ri responsible business analysis requirements collection working two different datasets one using hiveql using pig latin writing mapreduce code using python order get rid certain security issues data synchronizingboth unstructured structured data using pig hive business prospectus used pig latin client side cluster hiveql server side cluster importing complete data rdbms hdfs cluster using sqoop creating external tables moving data onto tables managed tables performing subqueries hive partitioning bucketing imported data using hiveql partitioning dynamically using dynamicpartition insert feature moving partitioned data onto different tables per business requirements invoking external udfudafudtf python script hive using hadoop streaming approach setting work schedule using oozie identifying errors logs reschedulingresuming job deployed big data hadoop application using talendon cloud aws amazon web services involved designing developing enhancements product features involved designing developing enhancements csg using aws apis enhance existing product newly features like user roles lead admin developer elb auto scaling s3 cloud watch cloud trail rdsscheduling created monitors alarms notifications ec2 hosts using cloud watch cloud trail sns involved designing srs activity flow diagrams using uml employed agile methodology project management including tracking project milestones gathering project requirements technical closures planning estimation project effort creating worked informatica power center tools designer repository manager workflow manager workflow monitor migrating existing data teradata red shift performed etl operation designed customized data models data warehouse supporting data multiple sources real time involved building etl architecture source target mapping load data data warehouse created mapping documents outline data flow sources targets extracted data flat files rdbms databases staging area populated onto data warehouse working informatica 951 informatica 961 big data edition scheduling jobs created rdds spark technology extracting data data warehouseteradataon spark rdds working stateful transformations spark streaming worked batch processing realtime data processing spark streaming using lambda architecture good handson experience loading data onto hive spark rdds worked spark sql udfs hive udfs collaborated infrastructure network database application bi teams ensure data quality availability supported codedesign analysis strategy development project planning 012015 102016 etl tech lead cgi group inc belton tx responsible business analysis requirements collection worked informatica power center tools designer repository manager workflow manager workflow monitor parsed highlevel design specification simple etl coding mapping standards designed customized data models data warehouse supporting data multiple sources real time involved building etl architecture source target mapping load data data warehouse created mapping documents outline data flow sources targets extracted data flat files rdbms databases staging area populated onto data warehouse maintained stored definitions transformation rules targets definitions using informatica repository manager used various transformations like filter expression sequence generator update strategy joiner stored procedure union develop robust mappings informatica designer developed mapping parameters variables support sql override created mapplets use different mappings developed mappings load staging tables dimensions facts used existing etl standards develop mappings worked different tasks workflows like sessions events raise event wait decision email command worklets assignment timer scheduling workflow created sessions configured workflows extract data various sources transformed data loading data warehouse modified existing mappings enhancements new business requirements used debugger test mappings fixed bugs wrote unix shell scripts pmcmd commands ftp files remote server backup repository folder involved performance tuning source target mappings sessions system levels prepared migration document move mappings development testing production repositories 082008 052015 etl developer cgi group inc birmingham al requirement analysis discussion onsite dmbatech leads business requirements working session ba tech leads designing fact dimensions design documentation business requirement created dmom artifacts mapping document logical model data design document several cldwclpd components working bridge tables worked change controls new attributes added existing tables profiling source data get better understanding data data profiling post table creation check different aspects data like valid values check null values working dba team get ddl created manufacturing tables created monthly snapshot fact time warp view get financial summary policy claim month end level good understanding clpd business data modeling preparing hld lld per business requirement develop etl mappings workflows using informaticapowerexchange 95 extract data mainframe db load data oracle using informatica powercenter prepare unit test plan report data load performance tuning mappings reduce execution time 052014 012015 etl developer tata consultancy services city state gather requirements different source systems analyze design database objects code automate debug test implement preparing hld lld per business requirement use informatica power exchange extract data ims db files load teradata tables set database objects relational model design mappings create workflows monitor jobs using informatica 901 checking redundancy data using informatica data profiler 901 tool generating reports automate process provide warranty support project implementation develop etl mappings workflows using informaticapowerexchange 95 extract data mainframe db load data oracle using informatica powercenter implementing type 2 teradata capture dynamic data load create teradat bteq scripts unix implementing business logic meet requirements prepare unit test plan report data load performance tuning mappings reduce execution time education 062008 042005 certifications bachelor engineering electronic instrumentation engineering thiyagarajar college engineering madurai high school diploma valivalam desigar polytechnic college nagapattinam domain aapa 273 annuity principles products certification 2012 aapa 283 marketing annuity products certification 2012 aapa 303 administration annuity products certification 2012 technical oracle certified associate oca 2009 powercenter data integration 9xdeveloper specialist 2015 aws solution architect associate 2020