jessica claire montgomery street san francisco ca 94105 555 4321000 resumesampleexamplecom professional summary data engineer 7 year experience data ingestion processing pipelines storageretrieval optimized database systems provide solution data analytics experience conversion build database programs objects snowflake oracle teradata worked projects wide range data projects including data warehouse software services data migration ability build processes using snowsql command line interface javascript stored procedures near real time bulk batch loads knowledge creating snowflake user defined functions materialized views merge statements query optimization using profiler created snowpipe continuous data load aws s3 buckets azure blob storage good knowledge snowflake virtual warehouse internal external stages materialized view zero copy cloning query profiling user defined functions transient tables advanced dml like merge common table expressions good knowledge various dimensional models like star schema hybrid models strong experience extraction transformation loading etl data various sources data warehouses data marts using informatica power center repository manager designer workflow manager workflow monitor metadata manger created complex mappings using mapplets new transformations like sql transaction control worked data migration processes files database across relational databases good experience working various type facts slowly changing dimension scd tables handson experience across stages software development life cycle sdlc including business requirement analysis data mapping build unit testing systems integration user acceptance testing worked scheduling tools like autosys tivoli workload scheduler welldeveloped verbal written communication skills ability work cooperatively team environment design construct deliver high quality deliverables database snowflake teradata oracle skills languages shell scripting sql jil autosys dos operating systems windows linux etl tools informatica power center work history data engineer 092021 current lockheed martin corporation wilmington de developed batch process using snowsql scripts automate using shell script tivoli batch scheduler converted mload teradata scripts snowflake compatible sql scripts incorporated user defined functions commonly used transformations converted bteq scripts snowflake compatible scripts utilized internal functions created stored procedures looping structures create materialized views faster data retrieval reports created continuous dataflow using snowpipe azure blob storage change data capture using streams optimized copy statements performance built process using advanced dml like merge statements created queries using common table expression recursive data window functions created manage code versioning using code cloud git cli tool performed unit test data validations supported quality assurance teams defect resolution performance optimizations collaborated database administrators optimize virtual warehouse sizing reduce redundancy manage cluster keys query performance optimization integrated batch loads tivoli workload scheduler batch process schedule daily weekly monthly demand cycles created documents data flow production support run books best practice documents naming standards unit test results conducted daily stand updated trackers mentored junior developers participated retrospects phase planning team activities environment snowflake azure snowsql red hat linuxshell scripts tivoli workload scheduler sr etl developer 052019 082021 two95 international inc suitland md create batch jobs load data using aws s3 external stages transformed data using javascript stored procedure developed jobs load files internal stage using put commands used copy scripts bulk load tables developed shell scripts using snowsql cli utility automate loads using autosys designed developed python programs load data 3 snowflake using connector dimensional model warehouse collaborated database administrators create data shares multiple accounts snowflake within organization evaluated virtual warehouse usage resizing based compute requirements analyzed data flow business transformation document process performed data profiles using sql informatica data analyst tool designed developed extraction transforming load process using informatica power center optimized query performance using query profiler tool remove bottlenecks integrated existing systems within new rms systems built aws cloud platform snowflake database back feeding data using informatica power center necessary tools pom systems extracting staging data apply necessary transformation supplying data supply chain management report systems extract transform data various heterogeneous sources like mainframe oracle db2 others target environment using informatica worked defects issues change requests interface implementation agile methodology using jira created technical design document unit test results release notes review status project related documents code versioning using svn environment informatica 106 oracle 11g red hat linux esp snowflake snowsql snowsight etl consultant 072015 042019 ing city state prepared technical design specifications data extraction transformation load like source target mapping documentation worked informatica utilities source analyzer designer mapping designer mapplet designer transformation developer create reusable objects developed complex mappings slowly changing dimensions type iitime stamping informatica using change data capture using informatica powercenter designer used various transformations like stored procedure connected unconnected lookups update strategy filter transformation joiner transformations implement complex business logic used informatica workflow manager create workflows database connections sessions batches run mappings used variables parameters mappings pass values mappings sessions created mapping read data mainframe ebcdic files copybook layout using normalizer applied business logic load oracle data warehouse implemented restart strategy error handling techniques recover failed sessions used unix shell scripts automate presession postsession processes enhanced performance improve execution time data extraction data process using parallelizing techniques others played key role upgrading informatica version 86 91 minimum disruption business process scheduled jobs using infacmd shell scripts using autosys boxes jobs implemented best practices per standards designing technical documents developing informatica etl process environment informatica 8691 oracle 10g red hat linux autosys master science computer applications 102008 manonmaniam sundaranar university india education