jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary data engineering experience design development implementation support data warehousing 8 years experienced complete software development life cycle sdlc software testing life cycle stlc sdlc methodologies extensively worked informatica designer tools source analyze warehouse designer mapping designer mapplet designer transformation developer workflow manager tools task developer worklet workflow designer workflow monitor informatica power exchange experience working using informatica sap hana oracle ms sql teradata db2 environments hands experience migrating premise etl google cloud platformgcp using cloud native tools big query cloud data proc google cloud storage composer practical understanding data modeling concepts like star schema modeling snowflake schema modeling fact dimension tables also experience optimizing database querying data manipulation using sql plsql oracle flat files sql server database experienced implementing change data capture cdc using informatica power center oracle sap systems experienced debugging mapping analyzing data flow evaluating transformations experienced performance tuning data flow source target sessions mappings identifying resolving performance bottlenecks various stages using techniques like database tuning session partitioning experienced test strategy developing test plan details test cases writing test scripts decomposing business requirements developing test scenarios support quality deliverables involved test planning execution various test phases unit test system user acceptance testing expert analyzing designing developing installing configuring deploying ms sql server suite products business intelligence sql server reporting services sql server analysis services sql server integration services performed data profiling data cleansing data conversion exception handling data matching using informatica idq excellent communication skills good organizational skills selfmotivated hardworking ability grasp quickly learn fast open new technologies skills tools etl tools informatica power center 1051 power exchange 961901 informatica data quality 961 power connect sap bw power connect jms power connect ibm mq series power connect mainframes dts mdm erwin scheduling tidal uc4 controlm autosys opcon oracle sap hana ms sql server snowflake mongodb teradata db2 aws python java sql unix unix shell scripts html xml json microsoft office apache spark kafka kubernetes hive scala data analysis data management data warehouse big data pl sql rdbms nosql vertica spark kafka oozie maven debugging coding designing quality analysis etl sap bw aws cloud tools ec2 elastic loadbalancers elastic container service docker containers s3 elastic beanstalk cloud front elastic files system rds dynamo db dms vpc direct connect route53 cloud watch cloud trail cloud formation iam emr elb lambda functions rest api airflow data pipeline redshift google cloud platform gcp cloud storage big query composer cloud dataproc cloud sql cloud functions cloud pubsub dataflow ai building blocks looker cloud data fusion dataprep firestone azure azure storage database azure data factory azure analysis services experience senior sql developer 022022 current kpmg orlando fl responsible identifying legacy systems analyze data models business data mapping analyst worked client gather business functional requirements experience building largescale data pipelines datacentric applications using big data tooling like hadoop spark hive airflow production setting experience working rest apis data extraction development etl extract transform load code components like mappings workflows sessions database objects like stored procedures functions unix shell scripts business requirements design plan responsible identifying performance bottleneck aries systems integrated testing system testing st pt performance testing phases implement performance tuning techniques confer scrum master client partners business managers adhere agiledevops experience multiple database technologies traditional rdbms ms sql server oracle mysql postgresql distributed processing spark hadoop emr nosql mongodb dynamodb conduct code review sessions peer developers ensure code quality wrote scripts processes data integration bug fixes utilized python handle debugging automation scripting tasks created implemented complex business intelligence solutions create managing buckets 3 store db log backup upload images cnd server setup databases amazon rds ec2 instances per requirements hands experience data management data security data modeling data quality workflow automation formulas validations collaborated legacy team define data extraction methodologies data source tracking protocols used sparksql read parquet data create tables hive using scala api used various spark transformations actions cleansing input data build data pipelines airflow gcp etl related jobs using different airflow operators experience gcp dataproc gcs cloud functions bigquery analyzed existing sql queries identify opportunities improvements created optimal technical solutions user needs indepth system analysis designed implemented tsql queries reporting complex solution development managed workload independently collaborated colleagues complete larger scale tasks distributed team environment supported projects enabling delivery efficiencies technical resolution followed standard practices migrating changes test production environments helped plan data extraction processing tasks aiding eventual deployments resolved complex business issues proposing longterm solutions avoid repeat problems developed custom database objects stored procedures delivered application support enhanced existing reports introduction new system features developed reusable components exploitation coding documentation developed implemented optimized stored procedures functions using tsql designed integration tools combine data multiple varied data sources rdbms sql big data installations designed created etl code installations aiding transitions one data warehouse another utilized code versioning systems type reduce development times designed created etl code installations aiding transitions one data warehouse another designed intuitive graphical user interfaces improve user experience led version control efforts organization employing public open source repositories designed implemented scalable applications data extraction analysis conducted data modeling performance integration testing created proofs concept innovative new solutions built databases table structures web applications reviewed code debugged problems corrected issues developed unit test cases testing automation developed maintained microservices architectures using docker kubernetes openshift worked backend developers design apis used nodejs orm sqlnosql develop manage databases supervised work programmers designers technicians assigned tasks monitored performance targets tuned systems boost performance corrected modified upgraded software improve performance documented software development methodologies technical manuals used personnel future projects designed developed analytical data structures designed developed forwardthinking systems meet user needs improve productivity maintained complex tsql queries views stored procedures multidatabase environment little supervision developed functional databases applications servers support websites backend optimized web applications speed scalability security bi etl developer 082010 022022 altus group limited denver co analyzing source data coming mainframe sources working business users developers develop model effectively efficiently communicated systems solutions business problems team members business unit representatives management impacted project teams analyze modify existing stored procedures functions queries order integrate previously built reporting application utilizing ssis sql server management studio change etl process importing flat files various databases source previously built application utilizing ssis read data existing reporting server sql server databases interface report users determine requirements new existing reports develop test deploy etl jobs reliable errorexception handling rollback framework manage automation file processing well etl processes within job workflow worked data analysts match current data mappings old mainframe mappings created design documents context diagrams every projects code review created reusable lookup send emails notification users lookup used multiple developer multiple projects prepared best practices documentation teams writing nosql part informatica decommission objects project used svn archive etl code delete unwanted mappings workflows extracted data flat file staged single place applied business logic load bigquery database lead complex projects performed unit testing created qa documents participated solution brainstorming provided technical instruction coaching others within organization developed technical project deliverables created spreadsheets using power bi power pivot importing data sources directly created visually impactful dashboards excel tableau data reporting using pivottables vlookup involved migrating etl code lower environments like devtestload production environment migrated etl code using deployment groups dev prod environments created ssis package loading data coming various interfaces like oms orders adjustments objectives also used multiple transformation ssis collect data various sources worked ssis package dts importexport transferring data database oracle text format data sql server created ssis packages file transfer one location using ftp task manage document platform infrastructure go installing new consul server resolving performance issues mongodb cluster setting continuous integration pipeline senior consultant 082008 082010 boeing hazelwood mo involved phases development like analysis design coding unit testing system testing uat analyzed problematic areas provide recommendations solutions extracted data heterogenous sources performed complex transformations load data target systems closely monitored updated company systems efficiency output factors improve overall productivity assessed needs projects made proposals senior executives resolved various performance issues examining logs current design removing bottlenecks wrote complex sql queries performed extensive data analysis oracle 11g experience integration various data sources like oracle db2 sql server csv xml flat files staging area developed code extract transform load etl data inbound flat files various databases outbound flat files xml files using complex business logic developed slowly changing dimension mappings type 1 scd type 2 scd monitored improved query performance creating views indexes sub queries extensively involved enhancing managing unix shell scripts developed custom solutions based upon clients strict requirements troubleshot issues understanding issue diagnosing root cause coming effective solutions senior software developer 071999 032008 tradeam international inc city state developed databases programs processes integration implementation across enterprise trained new developers programmers company standards design review monitored ongoing operation assigned programs responded problems diagnosing correcting logic coding errors coordinated efficient largescale software deployments consulted engineering team members determine system loads develop improvement plans met stakeholders provide detailed project reports milestone updates completed analysis design testing phases software development life cycle participated highly complex projects customers managers endusers troubleshot resolved performance issues databases software monitored database performance keep workflows running smoothly resolved hardware software compatibility interface design issues participated requirements gathering solidify prerequisites determine best technical solution meet business needs discussed project progress customers collected feedback different stages directly addressed concerns boosted network system data availability integrity preventive maintenance upgrades researched integrated design strategies product specifications development schedules user expectations product capabilities tuned systems boost performance conducted data modeling performance integration testing developed conversion system implementation plans coordinated deployments new software feature updates fixes education training master science computer information systems 122017 lnmu india